Sharing a workbook - I lose some functions & Pivot Tables

[miker1999]

Hello,
I have a workbook that is shared amoung several users. When I mak
some changes to it, I have to change it to 'unshared' and then back t
shared. When I do this, I seem to have some mal-functions. Like:

1) Any hidden 'helper' columns are now viewable.
2) The Auto-filter command is turned off.
3) Some frames are un-frozen

And worst of all... My Pivot Tables will not work on a Share
Workbook.... I need these!

Please help