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,
--
Rick Johnson

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.
--
Rick Johnson


"RickJ7777" wrote:

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,
--
Rick Johnson