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?
