Forum Discussion

ryanlittlepump's avatar
ryanlittlepump
Copper Contributor
Mar 24, 2024

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.

  • JKPieterse's avatar
    JKPieterse
    Silver 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.

    • ryanlittlepump's avatar
      ryanlittlepump
      Copper Contributor
      Problem solved!Thank you so much for helping me resolve the issue!

Share

Resources