View Full Version : refreshing data in excel

06-23-2008, 08:32 AM
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


06-23-2008, 11:21 AM
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.:dunno