It's because the pivot is trying to refresh on opening and you don't have
the source from which the data is dragged. Either the initial 'owner' need
to save the data with the workbook, or they need to 'break the link' and you
will just get a 'flat' version of the data
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England www.nickhodge.co.uk
(e-mail address removed)
