Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » introduction excel training - Pivot Tables

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

introduction excel training - Pivot Tables

Resolved · Low Priority · Version Standard

Reply Tue 29 May 2007, 09:46Delegate Ashley said...

Ashley has attended:
Excel Advanced course

Pivot Tables

Instead of refreshing the pivot table manually (once changes have been made to the raw data), can this happen automatically?

For upcoming training course dates see: Pricing & availability

Reply Tue 29 May 2007, 15:57 Edited on Tue 29 May 2007, 15:58Trainer Tracy said...

RE: Pivot Tables

Hi Ashley,

Thanks for the question.

Yes you can update the pivot table automatically. Simply by using the Pivot Table toolbar, click on the dropdown arrow that says Pivot Table. Go down to Options, there is a checkbox at the bottom of the dialog box where you can tick that says refresh every .... minutes and you can set your time in there

Hope that helps

Tracy

Reply Tue 29 May 2007, 16:44Delegate Ashley said...

RE: Pivot Tables

Great stuff - many thanks!

Reply Tue 29 May 2007, 17:26Trainer Tracy said...

RE: Pivot Tables

No problem, anytime

Tracy

Excel articles

· Make Things Easier In Excel With Lists
· How To Use Excel To Track Your Weight Loss
· A Hidden Gem In Excel - Formula Auditing
· MS Excel: Excel At Making The Most Of Your Christmas
· How Excel Can Help You See Into Your Business's Future

Excel tip:

Screen Splitters in Excel

Screen splitter icons can be set from the ribbon bar, or dragged from the scroll bars. The icon just above the up arrow on the right scroll bar controls the horizontal splitter; the icon to the right of the right arrow on the bottom scroll bar controls the vertical splitter.

These icons can be double-clicked to split the screen at the top left of the cell currently in use.

View all Excel hints and tips