Fergal has attended:
PowerPoint Intermediate Advanced course
Excel Intermediate course
Excel Advanced 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?
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
