excel learn london - pivot table
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

excel learn london - Pivot table

resolvedResolved · Low Priority · Version Standard

replyReply Wed 16 Jan 2008, 09:41Delegate Rita said...

Rita has attended:
Excel Advanced course

Pivot table

how do I update the table with fresh data

For upcoming training course dates see: Pricing & availability

replyReply Fri 25 Jan 2008, 19:20Trainer Katie said...

RE: Refresh Pivot table data

Hi Rita,

Thanks for your question.

In order to refresh the pivot table, you can:

  1. 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:

Get back to active cell

If you have scrolled away from the active celland want to get back t it quicly you can Ctrl and Backspace to get back

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard