Refresh a pivot table
Solved
wil2168
-
Raymond PENTIER Posted messages 58546 Registration date Status Contributeur Last intervention -
Raymond PENTIER Posted messages 58546 Registration date Status Contributeur Last intervention -
Hello
I filled in new rows in my Excel file
Previously, I had 132 rows with data
I added 100 more rows
Then I modified the number of rows in the pivot table under "Change Data Source"
So I went from data!$A$1:$K$132 to data!$A$1:$K$232
When I right-click on my pivot table to refresh my data, I see no changes in the data
After checking "Change Data Source," I notice that the data range of my table hasn't changed back to data!$A$1:$K$132
Can you help me?
I filled in new rows in my Excel file
Previously, I had 132 rows with data
I added 100 more rows
Then I modified the number of rows in the pivot table under "Change Data Source"
So I went from data!$A$1:$K$132 to data!$A$1:$K$232
When I right-click on my pivot table to refresh my data, I see no changes in the data
After checking "Change Data Source," I notice that the data range of my table hasn't changed back to data!$A$1:$K$132
Can you help me?
4 réponses
Good evening.
Yes: you stopped on the way...
the last step is the [Refresh] button
--
Retirement is great! Especially in the West Indies...
Raymond (INSA, AFPA)
good evening
when I click on the "refresh" button, nothing changes in the data on my pivot table
I still have data associated with my range data!$A$1:$K$132
when I go back to "change data source," I notice that I still have the range data!$A$1:$K$132….I can't maintain my new range data!$A$1:$K$232 in "change data source"
when I click on the "refresh" button, nothing changes in the data on my pivot table
I still have data associated with my range data!$A$1:$K$132
when I go back to "change data source," I notice that I still have the range data!$A$1:$K$132….I can't maintain my new range data!$A$1:$K$232 in "change data source"
Hello,
Indeed, with Excel 365, I have the same issue as you. I don't know if it's intentional or a regression.
We can only resolve it after adding rows by completely recreating the Pivot Table via Insert/Pivot Table; in this case, the new dimensions are taken into account, but it can be tedious if the Pivot Table is a bit complex.
On the other hand, if your database is formatted as a table in Excel, this time the data range is dynamic, and you just need to refresh your Pivot Table.
Best regards
Indeed, with Excel 365, I have the same issue as you. I don't know if it's intentional or a regression.
We can only resolve it after adding rows by completely recreating the Pivot Table via Insert/Pivot Table; in this case, the new dimensions are taken into account, but it can be tedious if the Pivot Table is a bit complex.
On the other hand, if your database is formatted as a table in Excel, this time the data range is dynamic, and you just need to refresh your Pivot Table.
Best regards
Hello.
You write " previously I had 132 lines with data: I added 100 more lines "
Instead of adding these 100 lines AFTER the 132nd line, insert them BEFORE this line 132, even if it means re-sorting.
--
Retirement is great! Especially in the West Indies...
Raymond (INSA, AFPA)
You write " previously I had 132 lines with data: I added 100 more lines "
Instead of adding these 100 lines AFTER the 132nd line, insert them BEFORE this line 132, even if it means re-sorting.
--
Retirement is great! Especially in the West Indies...
Raymond (INSA, AFPA)
Hello everyone,
Well done Raymond, greetings, inserting new lines in the middle of the database allows for an automatic and correct update of the data source for the Pivot Tables.
That said, I found the issue raised by wil2168, at least for me. It's because I had used a slicer that I had linked to several Pivot Tables, a relatively recent feature in Excel, it seems. This connection is only possible if all the Pivot Tables have the same data source, which in turn makes it impossible to modify the data source for just one Pivot Table.
By removing this connection, I regain the ability to modify the data source individually for my Pivot Tables.
Maybe for wil2168, it's the same problem.
Best regards.
Well done Raymond, greetings, inserting new lines in the middle of the database allows for an automatic and correct update of the data source for the Pivot Tables.
That said, I found the issue raised by wil2168, at least for me. It's because I had used a slicer that I had linked to several Pivot Tables, a relatively recent feature in Excel, it seems. This connection is only possible if all the Pivot Tables have the same data source, which in turn makes it impossible to modify the data source for just one Pivot Table.
By removing this connection, I regain the ability to modify the data source individually for my Pivot Tables.
Maybe for wil2168, it's the same problem.
Best regards.
Hello Raymond
I just tried your method and it works
The range automatically expands and takes into account my old and new lines
Thank you for the solution
I just tried your method and it works
The range automatically expands and takes into account my old and new lines
Thank you for the solution