• Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

Excel pivot table issue

BrilloPad

I Am Legend
Joined
Aug 24, 2006
Messages
109,681
Likes received
22,970
Thanks received
7,628
I edited the data in a pivot table. Not the source data, the pivot table. In particular it was in a row label. ( :suicide: ).

I saved without a backup ( :suicide: :suicide: )

Now I cannot get the row label to update when I add new rows to the source data. It uses the values I hard coded.

Any way round this? Apart from rebuilding the pivot table? I have tried all sorts of refresh.
 
I edited the data in a pivot table. Not the source data, the pivot table. In particular it was in a row label. ( :suicide: ).

I saved without a backup ( :suicide: :suicide: )

Now I cannot get the row label to update when I add new rows to the source data. It uses the values I hard coded.

Any way round this? Apart from rebuilding the pivot table? I have tried all sorts of refresh.



Go to the pivot table edit, drag that data range out of the "Rows" section, then put it back in again. (might work)
 
Go to the pivot table edit, drag that data range out of the "Rows" section, then put it back in again. (might work)

I did try that - it failed.

After several hours of cursing, I eventually found that when I right click on row label there is an option to Subtotal the data! Clicking that worked.

I am a bit angry at excel for making this so complex. But more angry at myself for making a newbie mistake of not making a backup before editing.

Can someone pass me the CUK dunce's hat and point me in the direction of the corner please?
 

Advertisers

Back
Top