Why is file suddenly "Read Only"?

[Robert Crandal]

I cannot save my workbook because the file status
is suddenly showing as "Read Only". Are there any
settings in Excel 2007 which might cause a workbook
to become "Read Only"??? I login to my personal
account every day, after which I shut down all
applications and log out. Therefore, I'm somewhat
positive that I'm not logged in twice.

If it is possible that another user, such as the network
administrator or a boss, has the file open, is there a
way to see who currently has the file open?? Any
clues as to what is going on here?

Thank you!

 

[trip_to_tokyo]

I cannot save my workbook because the file status
is suddenly showing as "Read Only".   Are there any
settings in Excel 2007 which might cause a workbook
to become "Read Only"???  I login to my personal
account every day, after which I shut down all
applications and log out.  Therefore, I'm somewhat
positive that I'm not logged in twice.

If it is possible that another user, such as the network
administrator or a boss, has the file open, is there a
way to see who currently has the file open??  Any
clues as to what is going on here?

Thank you!

Robert, I occasionally see this intermittent error in WORD but never,
yet, in EXCEL.

 

[Matt Richardson]

I cannot save my workbook because the file status
is suddenly showing as "Read Only".   Are there any
settings in Excel 2007 which might cause a workbook
to become "Read Only"???  I login to my personal
account every day, after which I shut down all
applications and log out.  Therefore, I'm somewhat
positive that I'm not logged in twice.

If it is possible that another user, such as the network
administrator or a boss, has the file open, is there a
way to see who currently has the file open??  Any
clues as to what is going on here?

Thank you!

If the file is read-only as you open it, then Excel will tell you, and
will tell you who already has it open.

Is it possible you are suffering from network problems which are
causing the folder to have a read-only status and therefore
affectiving your ability to save?

Matt
http://2toria.com
http://teachr.blogspot.com

 

[Gord Dibben]

Do you get a message that the workbook is already opened by yourself and is
read-only?

Usual cause...................

When you open a workbook in Excel a temporary copy is created.

Closing the workbook should also close the temp file.

Sometimes this does not happen and the temp file remains behind.

A reboot generally clears the temp file.


Gord Dibben MS Excel MVP