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