software

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?

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,
Peterquot;PSikesquot; wrote:

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