-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
automatic refresh
-
R
E2010: "Automatically refresh on opening" option for Pivot Tables does not work
Greetings, I have an Excel worksheet that pulls data from a SharePoint list, and then uses PivotTables on different worksheets to summarize the data. The query to SharePoint is set to refresh automatically each time the worksheet is opened, and this seems to work. However, the PivotTables are...- rmgarrett
- Thread
- automatic refresh pivottable
- Replies: 0
- Forum: Excel Questions
-
H
Refresh Excel Pivot Tables at Set Date/Time
Hi All, I am working on an excel project where I have multiple pivot tables in a report attached to an external source cube of data. The pivot tables in the workbook take about 45-60 minutes (blocking the usage of other excel sheets) to go through a total refresh of the data given the level of...- hallcr
- Thread
- application.ontime automatic refresh pivot tables pivot tables refresh schedule refresh
- Replies: 0
- Forum: Excel Questions
-
S
Excel Refresh Query
Hi All Quick question, I have three sheets in an excel file, two of which have sql queries running off them, currently I have to go into the sheet and right click to update the information (date=?) so I manually input the date inoder for the refresh, I want the date pop up box to appear when I...- seannewtoexcel
- Thread
- automatic refresh
- Replies: 0
- Forum: Excel Questions
