Hi All,

i have a workbook [xl2002, xp pro] with multiple pivot tables based on the
same data range (another sheet in the same book)... i've done this using a
dynamic named range, but whenever i open the file i get a message box saying
'reference is not valid'.

my questions a -
a) is the problem likely to be because excel is trying to show a pivot table
before its worked out where the named range is pointing to?
b) can i prevent it from happening?

i will be distributing the workbook so would prefer not to use a vba
solution (i'll just get loads of people contacting me with security
problems!)

tia,

Tim