Excel Pivot Table Refresh Not Working
Solved
julie788
-
julie788 -
julie788 -
Hello,
It's probably just a silly oversight on my part, but I'm stuck:
I have a data table with Q columns.
I create my pivot table on a different sheet from the data in A1 to Q100, I fill in the first 3 rows of the data table, and everything is fine, I get a nice pivot table. I close the file.
I open it a few days later, and when I add a fourth row, the pivot table does not take it into account (even after "refreshing").
Worse, if I delete the data from the first 3 rows to create 3 new ones, and refresh the pivot table, the only result I get in the pivot table is N/A!
If anyone has the answer, it would help me a lot.
Configuration: Windows 7 / Chrome 21.0.1180.89
It's probably just a silly oversight on my part, but I'm stuck:
I have a data table with Q columns.
I create my pivot table on a different sheet from the data in A1 to Q100, I fill in the first 3 rows of the data table, and everything is fine, I get a nice pivot table. I close the file.
I open it a few days later, and when I add a fourth row, the pivot table does not take it into account (even after "refreshing").
Worse, if I delete the data from the first 3 rows to create 3 new ones, and refresh the pivot table, the only result I get in the pivot table is N/A!
If anyone has the answer, it would help me a lot.
Configuration: Windows 7 / Chrome 21.0.1180.89
2 answers
-
Hello,
I've already had this issue in 2010 without finding an answer as to why...
In 2010, you can turn your data into a Table before creating the PivotTable (Insert ribbon, don't forget to check the help by pressing F1 on the icon). The added rows will be automatically taken into account.
Eric
--
You should never respond to an unsolicited PM...
Well, that's done.
