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

excel learn london - pivot table

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel learn london - Pivot table

excel learn london - Pivot table

ResolvedVersion Standard

Rita has attended:
Excel Advanced course

Pivot table

how do I update the table with fresh data

RE: Refresh Pivot table data

Hi Rita,

Thanks for your question.

In order to refresh the pivot table, you can:

    1 - Make changes on the original raw data table
    2 - Click on the PIVOT TABLE
    3 - On the Pivot table toolbar, click on Red Exclamation Mark to refresh


Hope this is useful.

Regards,

Katie

Excel tip:

How to apply the same formatting and data to multiple sheets at the same time in Excel 2010

When you want to format more than one sheet in a worksheet exactly the same way, Ctrl-click the tabs of the sheets you want to group together and they will all turn white. While they are grouped, anything you enter in one sheet gets entered into the others.

After you have done this, remember to click on the tabs to take them out of the group so that you do not accidentally insert data in multiple sheets when you just want to insert data in one.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.