Nicky has attended:
Excel Intermediate course
Pivot Tables
I am trying to refresh a pivot table to add new data however it keeps coming up with an error message is there any reason why? I am trying to get the data from the same table as the original data already in the pivot table?
RE: Pivot Tables
Hi Nicky,
Thank you for the forum question.
I do not know exactly which problem you have with the PivotTable. When you create a PivotTable Excel create an address in your computer's memory, where the source data are stored.
It is important that when you add new records to the source list that you on the analyse tab in the ribbon in the Data group click Change Data Source. Here you must select the whole list including the added records.
If you already do this then you must have another issue.
If you want I can have a look at your file.
You can send it to:
info@stl-training.co.uk
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
