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 réponses
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.
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.
This bug leaves me perplexed, but the main thing is to have a solution.
Thanks Eriiic