-
refreshing data in excel
I am pulling data from a database to excel columns and i made settings in the data range properties for refreshing the data ,data gets refreshed upon opening the excel sheet but it always gives a prompt for each column showing the database name , asking for the password and then i am clicking OK .after performing all these operations it gets refreshed,i saved my password but i need to press OK everytime for each column ,is it possible to write a macro which refreshes the data in the excel or is there any setting need to be done to get rid of the prompts. i tried changing many settings but could not find a way to automate it.could you please help me out in this issue
thanks
satyam
-
Normally I just use Application.DisplayAlerts = False to get rid of annoying notification boxes, but I don't believe that will work in this situation.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules