Clean Pivot Table Field Names

In case your workbook(s) contain phantom names, when you run the “Remove Phantom Names” function, you’ll see a window like this, which tells you how many phantom links were found in the currently opened workbooks.

You can select the workbooks you want to clean up, and the phantom links will be cleared quickly.


A sample file for this section is included in the Excel Power Expander software, in the file: “Phantom_Names_Tester.xls” in the “Examples” folder.