Changes not automatically updating

[HarvardMajesty]

I have a spreadsheet with about 100,000 rows and 30 columns. I made a pivot table from the data. When I made a change to one of the cells in the data, it was not reflected in the pivot table. In fact, the pivot table just kept entering the original values, even when I deleted the entire worksheet and created a new pivot table. Why is it not updating? I have it set to auto update on formulas. The change I made was linked to another sheet of lists. Oh, I'm using Office 2013.

[NeedForExcel]

Because, Pivot Tables do not refresh on their own.. You need to do that by Right Clicking on the Pivot Table and click on refresh..

https://support.office.com/en-za/art...6-8b6568ca9be2

Hope that helps!