C
Chuck
Have a small problem that I can't seem to figure out. I
have a large spreadsheet with piles of data with pivots,
vlookups, etc. In my final exhibit, I construct the data
by taking the results from other spreadsheets while
allowing certain fields to be customizable by the user.
I have a macro that updates all of the pivots when the
user changes these fields, but even though the pivots
themselves change, the results of the calculations on the
exhibit page don't, even when updated by the F9 button --
they will only change to the new values if I F2 the cell
then press enter.
The other thing that might be of help is that even though
I have automatic calculation on, the 'Calculate' message
in the lower bar doesn't turn off, even after an F9.
Anyone out there have an idea on what the issue might be?
have a large spreadsheet with piles of data with pivots,
vlookups, etc. In my final exhibit, I construct the data
by taking the results from other spreadsheets while
allowing certain fields to be customizable by the user.
I have a macro that updates all of the pivots when the
user changes these fields, but even though the pivots
themselves change, the results of the calculations on the
exhibit page don't, even when updated by the F9 button --
they will only change to the new values if I F2 the cell
then press enter.
The other thing that might be of help is that even though
I have automatic calculation on, the 'Calculate' message
in the lower bar doesn't turn off, even after an F9.
Anyone out there have an idea on what the issue might be?