Any deviation from that filter state, removes the formatting.
This means if I change the filter or remove the Filter field altogether, my formatting is blown away.
I have tried exiting and restarting Endnote and I have also restart my computer, all to no avail. You know that default setting in the Pivot Table options (“Preserve cell formatting on update”)? It seems like it should prevent the loss of formatting, but it doesn’t. There is a difference between formatting a pivot table and formatting the cells around it. You have to specifically select the area of the pivot table you want to format. The minute I select another filter criteria (Southwest in this case), my formatting disappears.For example, if you want to format a Subtotal, you’ll have to hover your mouse over the edge of the Subtotal until your cursor turns into a black arrow. It seems my pivot table somehow associates formatting with the filter state it was in when that formatting was applied.Can someone imagine using Microsoft Excel without formulas? And hardly anything could compare to the frustration caused by Excel formulas stop working all of a sudden.
When this happens, a bunch of questions immediately flash across your mind. Why doesn't this formula update its value automatically?Is my Excel corrupt or is this due to some malicious virus?