I Can't 'Save As'

[jerrygolfer]

When I try to 'Save As' , I get a pop up window that says.....
"The cell or chart you are trying to change is protected and therefor
read-only.
To modify a protected cell or chart, first remove protection using th
Unprotect Sheet command. You may be prompted for a password."
I then hit the ok button 11 times and it saves.
Any ideas, I could really use your help.
Thx, Jerrygolfe

 

[Jonathan Rynd]

When I try to 'Save As' , I get a pop up window that says.....
"The cell or chart you are trying to change is protected and therefore
read-only.
To modify a protected cell or chart, first remove protection using the
Unprotect Sheet command. You may be prompted for a password."
I then hit the ok button 11 times and it saves.

Scanned for macro viruses recently? If one is trying to modify normal.dot
and failing, that might happen.

 

[RWN]

--
Regards;
Rob
------------------------------------------------------------------------

 

[RWN]

Not sure about the reference to Word's Normal.dot, doesn't mean it's
wrong, just that I'm not sure(!).

Is the workbook indeed "Read Only"?
It should say so in the Title bar "Workbook Name [Read-Only].
If not;
Have you tried following the "Unprotect" instruction?

 

[Dave Peterson]

It sounds to me like there's a helpful macro that's updating the cell when you
do File|SaveAs.

Try closing excel and reopen in safe mode:
windows start button|Run
Excel /Safe

Load the workbook and see if you can change and save.

If you can find the developer, talk to him/her and ask for help.

 

[jerrygolfer]

I ran Norton and no virusaii.
I am not trying to enter into a cell, I am trying to 'save as' a
workbook.
This happened after it was posted to our server.
Thx for your help.
jerrygolfer

 

[Dave Peterson]

Debra Dalgleish posted this to a different question yesterday.

I kind of thought that maybe it was meant for you (but I've been wrong before).

There information in the following MSKB article that may help:

XL2002: Error Saving File After Network Connection Has Been Lost
http://support.microsoft.com/default.aspx?kbid=291204

It might be worth looking at.

 

[Debra Dalgleish]

It looked like it might be relevant for the other thread (network
connection lost, VBA wiped out), but I've been wrong before!

 

[Dave Peterson]

Not that I've seen--well, not enough to have the CQC show up on your doorstep.