I'm using Excel 2010 pivot table through 'multiple consolidation range' as I have a number of worksheets with data that I would like summarising on a front worksheet. I have set the ranges and it summarises, however I now want to go back and edit the range/data source. How do I get back into the 'Multiple Consolidation Range' feature to edit this? I have tried ALT+D+P but this only allows me to create a new pivot table.

Hope you can help.

Thanks,
Sanchez