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 » Getpivotdata from another closed workbook | Excel forum
Getpivotdata from another closed workbook | Excel forum
Resolved · Medium Priority · Version 2010
Jayne has attended:
Excel VBA Introduction course
Getpivotdata from another closed workbook
I have set a master spreadsheet with numerous getpivot data values obtained from two closed workbooks.
The calculations work fine when all 3 workbooks are open but show as #ref when the two workbooks holding the pivot tables are closed.
Is there a way to set these to update when opening the master spreadsheet without opening the linked workbooks?
RE: getpivotdata from another closed workbook
Hi Jayne,
Thank you for the forum question.
No when the GetPivot function is used to link data the source workbooks must be open to update the links.
You can write a macro which will open the source workbooks, refresh the master and then close the source workbooks again.
Unfortunately when you are using the GetPivot function this is the only option.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
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:Hide columns in an Excel 2010 WorksheetIf you don’t want part of the Excel worksheet to be visible or when you don’t want certain data to appear in print outs, then a simple solution is to temporarily hide a column or multiple columns. |