98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » introduction excel training - Pivot Tables
introduction excel training - Pivot Tables
Resolved · Low Priority · Version Standard
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?
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
Tue 29 May 2007, 16:44Delegate Ashley said...
RE: Pivot Tables
Great stuff - many thanks!
Tue 29 May 2007, 17:26Trainer Tracy said...
RE: Pivot Tables
No problem, anytime
Tracy
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Moving between Worksheets without using the mouseUse the 'Ctrl+PgDn' and 'Ctrl+PgUp' keys. |
