Forum Discussion
Unable to Format Table for Pivot Table Updates
I typically utilize the 'format as table' function to automatically update my pivot table when I input new data into a fresh row. Today, while entering my data, the new row was initially formatted, and the pivot table was successfully updated. However, when I proceeded to input data into another new row, the formatting did not occur, resulting in the pivot table failing to update. What steps should I take to address this?
ryanlittlepump Go to File, Options, Proofing tab, "AutoCorrect Options..." button, "Autoformat as I Type" tab and check if the box "Include new rows and columns in table" is checked.
- JKPieterseSilver Contributor
ryanlittlepump Go to File, Options, Proofing tab, "AutoCorrect Options..." button, "Autoformat as I Type" tab and check if the box "Include new rows and columns in table" is checked.
- ryanlittlepumpCopper ContributorProblem solved!Thank you so much for helping me resolve the issue!