I edited the data in a pivot table. Not the source data, the pivot table. In particular it was in a row label. ( ).
I saved without a backup ( )
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 saved without a backup ( )
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.
Comment