pivot table

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Table

Pivot Table

resolvedResolved · Medium Priority · Version 365

Keiko has attended:
Excel Advanced course

Pivot Table

When I change the part of data table, it sometimes wouldn't reflect properly on the pivot table. Most grateful if you share tips to sort out.

RE: Pivot Table

Hi Keiko,

Thank you for your question in STL's forum.

It is a bit hard to give a constructive answer based on just the information you gave me. There could be all sorts of reasons for the PivotTable not reflecting your changes to the table.

It would be helpful if you could send me a copy of your file so I can determine the reason for it not updating. You can send it to

ron.oldeboom@stl-training.co.uk.

When I get the file I can give you some pointers

Kind regards

Ron Oldeboom
Learning and Development Consultant
STL-training


 

Excel tip:

Finding your worksheets quickly

The arrows to the left of the worksheets are used to move between one sheet at a time or first / last worksheet, but if you right click on the arrow buttons it gives you all worksheets in your workbook.

View all Excel hints and tips


Server loaded in 0.07 secs.