ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   suddenly my excel workbooks are "shared workbooks" (https://www.excelbanter.com/excel-discussion-misc-queries/42745-suddenly-my-excel-workbooks-%22shared-workbooks%22.html)

Maggie's mom

suddenly my excel workbooks are "shared workbooks"
 
I'm the only user on my computer but suddenly my excel 2003 workbooks are
shared workbooks. Because of this I'm unable to edit, center and merge is
greyed out. How do I correct this problem?

Conrad Carlberg

There are other things you can't do if your workbooks are shared. To
un-share one, activate it, choose Tools | Share Workbook, click the Editing
tab if necessary, clear the "Allow changes ..." checkbox, click OK, click
Yes. So doing should also automatically re-save the workbook, but it
wouldn't hurt to do so explicitly

C^2
Conrad Carlberg
--
Excel Sales Forecasting for Dummies, Wiley, 2005

"Maggie's mom" <Maggie's wrote in message
...
I'm the only user on my computer but suddenly my excel 2003 workbooks are
shared workbooks. Because of this I'm unable to edit, center and merge is
greyed out. How do I correct this problem?





All times are GMT +1. The time now is 10:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com