Forum home » Delegate support and help forum » Microsoft Excel Training and help » Cell refs
|
|
|
The UK's most regular 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. |
Cell refs
Resolved · Medium Priority · Version 2007
Reply Wed 1 Jun 2011, 13:49Delegate Fergal said...
Fergal has attended:
Powerpoint Intermediate Advanced course
Excel Intermediate course
Cell refs
I have linked some spreadsheets to a pivot table, but when I open the linked spreadsheet without having the pivot table spreadsheet open I invariably get cell refs. How do I stop this happening?
For upcoming training course dates see: Pricing & availability
RE: cell refs
Hi Fergal, thanks for your query. Your links sound a lot like they include the GETPIVOTDATA function, which is switched on automatically and draws the information from the Pivot table held in memory. When you don't have anything in memory/the buffer you will end up with cell refs because there is nothing to draw through. Try turning off the GETPIVOTDATA functionality and rebuilding your links to the more usual A1 notation, there's a walkthrough here:
http://www.contextures.com/xlpivot06.html
Hope this helps,
Anthony
Reply Thu 2 Jun 2011, 13:44Delegate Fergal said...
RE: cell refs
Thank you Anthony!
|