Pivot Tables

Resolved · Medium Priority · Version 2013

Mon 3 Oct 2016, 16:45 Delegate Nicky said...

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?

Tue 4 Oct 2016, 09:56 Trainer Jens said...

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

Tue 11 Oct 2016: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

COUNT function vs COUNTA function

The COUNTA function works in the same way as the COUNT function, except that it will count cells that contain text (labels) and also cells that contain numbers (values). The COUNT function will only count cells that contain numbers. Blank cells are not counted by either the COUNT or the COUNTA function.

View all Excel hints and tips