Add info into Pivot Table

Resolved · Medium Priority · Version 2016

Thu 31 Jan 2019, 13:20 Delegate Muhammad said...

Muhammad has attended:
Excel Intermediate course
Excel Advanced course

Add info into Pivot Table

Hi

I am working on our monthly payroll extracts sheet and one of the item is already existing in data but that is not being calculated on actual pivot table. Could you please explain what should I do to get it done? Please let me know if I should send a sample sheet?

Thanks

Muhammad

Thu 31 Jan 2019, 19:56 Trainer Jens said...

RE: Add info into Pivot Table

Hi Muhammed,

Thank you for the forum question.

Yes please send an example file. I am not sure I understand what you want to achieve.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
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

Fri 1 Feb 2019, 11:07 Delegate Muhammad said...

RE: Add info into Pivot Table

Hi Jens

Thank you for getting back to me.

Could you please share your email address so I can send an example file.

I am actually working on advance excel sheet that is created by my colleague. We enter payroll extracts figures on monthly basis on data tab and then refresh the pivot table. It is then captures by pivot table and updated on summary sheet. However at the moment one of the column is already in the data but it is not captured by pivot table. I will send you an example sheet so you can have a look and explain. Thank you.

Regards

Muhammad

Fri 1 Feb 2019, 13:21 Trainer Jens said...

RE: Add info into Pivot Table

Sorry Muhammad,

I would have been a good idea to tell you where to send it.

info@stl-training.co.uk

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
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

Sun 3 Feb 2019, 12:14 Trainer Jens said...

RE: Add info into Pivot Table

Hi Muhammad,

I have received your email.

Normally it is outside the scope of our forum to setup a screen sharing meetings, but I will see what I can do and we will be in touch we you very soon.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Excel 2010 Shortcuts - Start and End of the Worksheet

Did you know you can quickly move to either the beginning or the end of an Excel Worksheet using just a couple of keys on the keyboard?

Press Ctrl + Home key to move the cursor to cell A1

Press Ctrl + End key to move the cursor to the end of the current worksheet.

View all Excel hints and tips