Forum Discussion
Solved
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, a...
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.
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.
Problem solved!Thank you so much for helping me resolve the issue!