Why do some of my Excel Workbooks open in "Shared" mode when I am the only
user? How can I prevent Shared mode?
Thanks,
Keith
Why do some of my Excel Workbooks open in "Shared" mode when I am the only
user? How can I prevent Shared mode?
Thanks,
Keith
Hi Keith,
If you turn on Tracking you also turn on Shared.
To turn off
Tools, protection, protect and share workbook, (uncheck) share workbook
Tools, sharing, (uncheck) allow change by more than 1 user...
Be sure to save the workbook or nothing will change.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"keithb" <k31thb@yahoo.com> wrote in message news:uNcpY%23JtFHA.2072@TK2MSFTNGP14.phx.gbl...
> Why do some of my Excel Workbooks open in "Shared" mode when I am the only
> user? How can I prevent Shared mode?
>
> Thanks,
>
> Keith
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks