![]() If you DO NOT check that box, Excel creates an Normal pivot table.If you check that box, Excel creates an OLAP-based pivot table, instead of a Normal pivot table.If you create a pivot table in newer versions of Excel, there is a check box for “Add this data to the Data Model”. However, those macros might not work correctly in newer versions of Excel – depending on how you build your pivot tables. Previously, I’ve posted macros to fix the headings on Normal pivot tables. If you want to quickly change multiple headings, to remove “Sum of”, or other automatic text, use a macro. Here is a link to the page Remove Sum Of With a Macro To see the steps for renaming the headings manually, watch this short video. Add a space character at the beginning or end of the text, and Excel with accept that as a valid heading. NOTE: Excel won’t allow you to use the exact name of the field, such as “Quantity”. To remove the “Sum of” or “Count of” from a single value heading, just type over the existing heading, to fix it. The TotalPrice heading has not be changed, and still shows the “Sum of” text.The Quantity heading has be revised, to remove the “Sum of” text.This screen shot shows a couple of fields in the Values area of a pivot table. There is one macro example here, and more on my Contextures website. ![]() ![]() You can manually remove that text, or use macros to quickly change the headings. When you’re building a pivot table, if you add fields to the Values area, Excel automatically adds “Sum of” or “Count of” to the start of the field name.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |