Once you have the Pivot Table displaying the values you need, you can then format the table to make the data presentable—for a while.
You see, when you update the data on which the Pivot Table is based, and then refresh the Pivot Table, all your formatting work may go away.
As I mention in my post on creating pivot charts, you can’t create pivot charts in Excel for the Mac.
Allen Wyatt With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. On refresh, it seems that cells (randomly it seems) 'forgot' that they were centred in the cell..borders (randomly it seems) disappeared. Try to click on each cell in a column randomly..will come to a point where all cells will suddenly be highlighted..will be the time you can right click and format cells...after you do this..to refresh.will see that all cell in that column has retained its formatted values... I have one file that will retain the format when new data has been added to the range and two other files were I continually have to reformat (e.g. I've read through the comments starting with this string and still don't seem to have a proper solution.I did google and tried the manuall calculation mode, that doesn't work for me.Even I tried to copy a dozen of records to a new worksheet and applied the autofilter but it showed nothing.You can the options in the drop-down filter and even select them.In fact, the pivot table (that’s created with every pivot chart) updates. I demonstrate this disappointing failure in this short demo. Go ahead and test it for yourself with the pivot chart in this Excel file.In addition to quick filtering, slicers also indicate the current filtering state, which makes it easy to understand what exactly is shown in a filtered Pivot Table report.