Daily Refresh of Ext Data

K

ken3260

I have a wrkbk that summarizes data from several xt sources w/pivot table
queries from two databases. I have set to refresh on open, but each user
incurs the lag time. Is there a way have update run only on first daily
opening of file, and show the date/time last updated? I could then add
manual update macro button if user needs to refresh later in the day. Tks in
advance.
 
T

ThalesNate

Perhaps you could make a blank spreadsheet with a manual update macr
button which would then populate your spreadsheet? Just force manua
and remove the automation
 
Top