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


"PSikes" wrote:

> 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?