Rachelle Haid is a valued member of Zayo Bandwidth’s team. She is an Excel wiz and has the following tip for linking to Pivot tables, without having a strange pivot table named range show up in your formula:
Linking to a cell in pivot table so you don’t get the get pivot in your cell, check or uncheck the Generate GetPivotData
http://support.microsoft.com/kb/287736
If you liked my post, feel free to subscribe to my rss feeds
BlogoSquare