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)
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
