Hi all,
On a worksheet called 'Quotations FY 14-15' I have a dynamic range called 'DynamicRegister'.
On a worksheet called 'DH Test' I would like to add a pivot table referencing this data. When I go to create the pivot table and select the Table/Range I enter =DynamicRegister but I get:
"The PivotTable field name is not valid...etc...etc..."
I'm sure it's something simple but I've been unable to find an answer to this after much browsing
Thanks for your help
David
Bookmarks