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