Home |
Search |
Today's Posts |
#1
|
|||
|
|||
getpivotdata refresh problems
Hi,
Just have a quick problem with the getpivotdata function - I have a file with a pivot table in it (call it file A) and a second file that accesses the data in it via the getpivotdata function (file B). Works fine but when I save and close the files and then reload file B, the values update to zero, even though the underlying data has not changed. This doesn't seem to be in keeping with other workbook references that retain their data. Has anyone else experienced this? What am I doing wrong? Thanks Chris |
#2
|
|||
|
|||
The GETPIVOTDATA function, like some other functions, only returns data
for references in the same file, or another open file. http://support.microsoft.com/default.aspx?id=299303 Calgarychris wrote: Just have a quick problem with the getpivotdata function - I have a file with a pivot table in it (call it file A) and a second file that accesses the data in it via the getpivotdata function (file B). Works fine but when I save and close the files and then reload file B, the values update to zero, even though the underlying data has not changed. This doesn't seem to be in keeping with other workbook references that retain their data. Has anyone else experienced this? What am I doing wrong? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Thanks very much for the quick reply - that answers my question!
"Debra Dalgleish" wrote: The GETPIVOTDATA function, like some other functions, only returns data for references in the same file, or another open file. http://support.microsoft.com/default.aspx?id=299303 Calgarychris wrote: Just have a quick problem with the getpivotdata function - I have a file with a pivot table in it (call it file A) and a second file that accesses the data in it via the getpivotdata function (file B). Works fine but when I save and close the files and then reload file B, the values update to zero, even though the underlying data has not changed. This doesn't seem to be in keeping with other workbook references that retain their data. Has anyone else experienced this? What am I doing wrong? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refresh queries, graphs, and charts | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
How to make Bullen's FilterCriteria() data refresh real-time? | Excel Discussion (Misc queries) | |||
Manual Refresh of Links | Excel Discussion (Misc queries) | |||
Pivot Table Refresh Problems | Excel Discussion (Misc queries) |