• Quick note - the problem with Youtube videos not embedding on the forum appears to have been fixed, thanks to ZiprHead. If you do still see problems let me know.

More problems with Excel

Waddauno

New Blood
W
Joined
Mar 17, 2006
Messages
21
To All:

My thanks to those who responded to my last Excel poser. I've another one. I inhereted an iMac from my predecessor. She had Excel set on manual calc in the settings, which was driving me nuts. Y'all helped me with that, and I reset it to Automatic. Now, all the spreadsheets that she had set up are telling me that they are read only. We've got a month by month progression of things and now I can't save changes to a spreadsheet I changed just last month. I've tried resetting to manual as the lesser of two evils, and it won't stick.

Anyone got an idea?

Thanks. I realize these sorts of entreaties don't really add a lot to the board, but we've got a lot of knowledgable folks here and I hope someone can help.

Thanks again.
 
Can't help I'm afraid, except to suggest reposting in the computer section?
 
Waddauno said:
Now, all the spreadsheets that she had set up are telling me that they are read only. We've got a month by month progression of things and now I can't save changes to a spreadsheet I changed just last month. I've tried resetting to manual as the lesser of two evils, and it won't stick.
Click to expand...
I'm fairly sure the problems aren't related.

One solultion is to open the file read-only, then save-as to a new name.
 
Waddauno said:
Now, all the spreadsheets that she had set up are telling me that they are read only. We've got a month by month progression of things and now I can't save changes to a spreadsheet I changed just last month. I've tried resetting to manual as the lesser of two evils, and it won't stick.
Click to expand...
When one user creates a file, the file permissions may default to read-only (or no access) for other users. Not sure how your user accounts are related there. But, you can try going to file ... get info, and see if you what your permissions are, and whether you are authorized to change the permissions for various users/groups.

If you plan to share these files back and forth, you need to make sure that you keep the file read&write for both users, AND save it in a location that allows read&write for both users. If you don't need to continuously share the file, just save the most recent as a new file (in your user area), double-check the permissions, and then you should be able to save updates after you make them.

Does that help?
 
Right click on the filename in Windows.
Select properties from the menu
Unclick 'read only' box.

I assume you have Microsoft Windows?
 
rjh01 said:
Right click on the filename in Windows.
Select properties from the menu
Unclick 'read only' box.

I assume you have Microsoft Windows?
Click to expand...
Nope. The OP says iMac.

I'm not familiar enough with Mac OSX to tell some one how to get that information through the GUI.

I could tell 'em how to get it through the command line (OSX is unix underneath,) but I think that'd be more confusing.
 
Last edited:
Can't you just copy everything and paste it into a new workbook where you do have write access?
 
Lothian said:
Try: tools; protection; unprotect sheet.

It may ask for a password. If it does try hitting return as many people don’t add a password.

If it is password protected try Brodski’s suggestion. Select all copy and paste into a new sheet.
Click to expand...

It doesn't sound like a protection issue. Protected sheets/workbooks will tell you the instant you try to edit. He's saying he can't save his edits, which on a Mac means file permissions, probably related to user accounts (see above).

User permissions cause me occasional grief, even when both users are me!
 
You must log in or register to reply here.

Back
Top Bottom