Hi all,

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,

Cathy (keeping my fingers crossed!!)