Renumbering footnotes

When you have pivoted a table by switching rows, columns, and layers, the footnotes may be out of order. To renumber the footnotes:

1. Activate the pivot table.
2. From the Format menu choose Renumber Footnotes.