Hopefully I can explain this in a way that makes sense... if not I will upload a sample.
I have a pivot table that includes countries as rows & fields for multiple years as values. I would like to be able to select a specific year (or years) by toggling them on & off in the Pivot Table Fields side bar. I would also like to maintain the number format for the values associated with those years.
The problem I'm having is that when I deselect a year & add it back in, the number formatting is lost (in this case, it's simply a number with a single decimal place). I've made sure to check the "Preserve cell formatting on update" box in Pivot Table Options, but the issue with this is that I'm not updating the table per se. I am only deselecting a year (or years), and then selecting it/them again to add them back into the table. I am not refreshing the table.
I could, of course, reformat the values each time, but that is tedious and inefficient so I'm hoping there is a simple solution.
Please let me know if a sample sheet would be beneficial & I will upload one.
Thanks in advance!
Bookmarks