Getpivotdata references have stopped loading pivot-refreshed value


G

Guest

I have a report that has been in production for over a year. It makes use of
pivot-tables for an OFFSET(A1,0,0,COUNTA($A:$A),COUNTA($1:$1)) named range.
Non-Pivot charts exist on other tabs that make use of 10-day trending tables.
I have a VBA macro that will move old days 1-cell-to-the-left, then load the
latest value from a GETPIVOTDATA cell. This has been working fine until
recent additions to the spreadsheet. The master source, referenced by the
named range in all pivots is updated and all the pivots refreshed. Now the
problem...the pivots show the new data, but the pivot data reference cells
[ex. =GETPIVOTDATA("Procdate", 'Pivot-Date'!$B$4) ] do not update unless they
are "touched"... i can insert a space anywhere in the GETPIVOTDATA() command,
then remove it and the cell value can be copied/pasted with the correct value
(value that = the refreshed pivot value, not the previous pivot value).

I'm at a loss and have checked thru this site to find same issue with no
avail. Any help would be appreciated. Note that the resulting spreadsheet
is 10mb in size, i'm working with Excel 2002 SP3 w/2gb of RAM on WinXPP SP2.
Thanks,
 
Ad

Advertisements

G

Guest

This situation is actually more bizarre than i noted below. All formulas
that reference other cells will not update unless the cell is selected, the
formula bar entry is mouse-selected, and ENTER is pressed. Any help is much
appreciated.
 

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

Top