Pivot Table/Report in Shared workbooks

[PSikes]

Hi,
I used a shared workbook for an order entry file located on a server, but
then generate sales reports using a series of defined Pivot Tables. I just
discovered that shared workbooks won't let you use PT's? Is there a way
around that?
What if I unshare the entry workbook, in which the order posting is done.
Can I then access the same file, in order to do the reports? Can the Pivot
tables be posted automatically in that case? Will I be still be able to
manipulate the Reports?

 

[PSikes]

Hello again. Since nobody answered, I tried unsharing the workbook. The
pivot tables still won't automatically update (Refresh), although I can
recreate them easily enough. Does anybody know why this is true?
Thanks,
Peter