TheoTester
New Member
- Joined
- Aug 28, 2020
- Messages
- 1
- Office Version
- 2019
- 2016
- Platform
- Windows
When you click a column label in a pivot table and type something, then all occurences of that label will have the new value.
Even after a data refresh.
Is it possible to check which labels have been overwritten?
Is it possible to reset all values of the labels to the ones in the linked database?
Is it possible to block this 'feature'? I can't think of any valid reason why anyone should be able to change the values reported from the database in a pivot table?
Even after a data refresh.
Is it possible to check which labels have been overwritten?
Is it possible to reset all values of the labels to the ones in the linked database?
Is it possible to block this 'feature'? I can't think of any valid reason why anyone should be able to change the values reported from the database in a pivot table?
