posted
I have had several spreadsheets recently that lock up as far as formatting goes. I put one together and save it. Later, I'll come back and add or change some things, but I can't change the formatting on the cells. When I click on format cells, I get nothing.
I've checked the sheet protection and it's not on. Does anyone know anything else I can try?
Posts: 221 | Registered: Mar 2003
| IP: Logged |
posted
We used to have a lot of trouble with that in Sigmaplot (a graphing program). To get us by until the new version came out, we created a new file and just copied the data in. The files may have been corrupted somehow, I'm not sure.
In Excel, you probably can't do this without copying the format unless you paste as values. This may not be very helpful if you have formulas
Posts: 1777 | Registered: Jan 2003
| IP: Logged |
posted
Of course, I forgot the original point of the post, which was to eliminate the mysterious locking. I don't know whether my approach will bring over the locked state or not. Might be worth a try.
Maybe apply everything I said except Formats.
[ October 17, 2003, 01:10 PM: Message edited by: John Van Pelt ]
Posts: 431 | Registered: Oct 2003
| IP: Logged |
posted
My first guess is that the spreadsheet is protected somehow. Read this for more info on spreadsheet protection. I'm not too familiar with the latest version of Excel, so I don't know if there's some way to automatically protect a spreadsheet when you save it.
Posts: 1805 | Registered: Jun 1999
| IP: Logged |