Pivot name changes automatically
 

Hi,

I have a couple of pivot tables in a file which via sql accesses a
database to extract data.

I have a menu on the first page which has a drop down to select the
country. Once selected, the Pivot fields in all the pivots changes to
the selection made.

However whenever I refresh the tables, the pivot name changes
automatically. Is there a way i can freeze the pivot name so that it
does not change after refresh or give the sheet name to the pivot table
on each sheet automatically via another macro.

The macro for changing the pivot field uses the pivot name to change
it. However as the pivot name changes automatically after refresh, the
macro no longer becomes usable until I manually again change the pivot
name back to pre-defined names.

Regards
Sandip.