Daily Refresh of Ext Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding button to worksheet to refresh pivot table data 1
PivotTable auto-refresh with external data 4
Refreshing Pivot Tables 2
Import external data link disappears 1
Formatting not updating upon data connection refresh 0
Pivot Table Refresh 2
Excel 2007 -- Dates in Pivot Tables in wrong order after refresh 1
Automatic refresh of external data 1

Back
Top