98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum 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
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?
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
RE: Pivot Tables
Great stuff - many thanks!
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. |