Afternoon,

I am just wondering if it's possible to name a pivot table (using a named range) so that the range is dynamic and expands and contracts as the pivot table updates? I know how to do this usually using the offset function however I was wondering if there was a way that excel would do it automatically.

I have a number of pivot tables and I want to be able to use the table names for data mining later on in my spreadsheet.

Thanks,

Alice