October 15, 2021
I thought that I had got my spreadsheets set up perfectly - the data source on one sheet, then separate sheets for each pivot table (along with a couple of slicers on each tab) and then a main dashboard with the charts connected to each pivot table and a couple of slicers to make filtering easy.
The problem is that the data is a feedback survey that updates every 2 months - I copied the latest data into the bottom of the data table and clicked to 'Refresh all' for the pivots. I then realised that it hadn't picked up the addition to the data table.
On trying to change the data table to include the extra rows I was told that I couldn't do this - something about connections?!!
(See attached screenshot)
So my question is - how do I update multiple pivot tables and slicers, all at once, when I add more data to the data source please?
I have tried Googling this and can't find any clear instructions on how I should do this - HELP!!!
Ideally I would rather not share the file, as it is survey feedback, but if needed I could email it directly to a wonderful person to help me sort it out if that's possible?
Thanks loads everyone,
July 16, 2010
If your data is stored in an Excel Table then you should be able to Refresh All and have all PivotTables pick up the new data. Rather than editing the PivotTables, have you tried fixing the table range so that it includes the new data (Table Design tab > Resize Table)? You should be able to Refresh All then.