Now, whenever you format your Pivot Table and refresh it, the formatting will not be disappeared any more. Then check Preserve cell formatting on update item under the Format section.In the PivotTable Options dialog box, click Layout & Format tab. Then choose PivotTable Options from the context menu. Select any cell in your pivot table, and right click. To keep the formatting when you refresh your pivot table, do with following steps: I was then able to refresh/slice/filter the data and the custom chart formats were all preserved.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |