Workbook "Un"sharing

[Stephen]

I shared a work book...but now I must make changes (i.e.
formatting, formulas, etc.) but I cant. How can
I "Unshare" the workbook???

Thanks in advance.
Stephen

 

[OZZIE]

TOOLS / SHARE WORKBOOK - TURN IT OFF.

 

[JanetW]

The only time I've shared a workbook, it had over 2000 records and wa
being shared by up to ten people at a time. At times it saw prett
heavy updates (over 5000 cells editted in the span of a few days), bu
most of the issues that came up turned out to be user related.

One thing I did have to change was the frequency of the automati
saves/updates. It's a trade-off between timely data and having multipl
people trying to save at the same time. It was a large file and took
few seconds to save. The more frequenly you auto-save, the more likel
there will be delays due to multiple saves happening at the same tim
(some people thought there machine was locking up). But if I saved i
less frequently, people would get concerned that their changes weren'
showing up on other people's screens