Copying Live Pivot Tables?

[Lorna B]

Hi everyone

I was wondering if someone could help.

i have a few pivot tables from live data on a shared workbook. Obviously i can not refresh these while the workbook is shared and multiple users are in it - I have been asking staff to exit the spreadsheets - unshare the workbook and refresh the pivot table - get the information that i need and then share the book again.

this is time consuming and i bet there is another way of doing it -

I had before a new workbook which contained a copy of the pivot tables and because this was not shared i could refresh at anytime using the data from the orginal workbook??

I can not for the life of me remember how this was done?

Can anyone help me with this?

Regards

Lorna