OT, Excel "read only problem"

elevmike

Member
Join Date
Feb 2004
Location
Detroit, MI
Posts
4,012
Somehow one of my workbooks is suddenly marked as "read only". I show that theres no current password in the tools-protection, and cannot save it with new data..All subsequent save as's are also read only..

Does anybody know how to un-read only a workbook??

Edit: Never mind...I had the workbook opened in two differnet dialogs... utoh
 
Last edited:
If that doesn't work, create a new worksheet and copy all the data page for page from the read only worksheet to the new one, then work with the new one. (Delete or rename the old one if you want to keep the same name for the new one).

This system can also be used to save your bacon when you get one of those friendly Microsoft popup error windows saying "This program has caused an error and will be shut down." Before clicking OK, open a new file and copy the data from the old one - can save you hours of retyping if you haven't saved often enough in between times.
 

Similar Topics

Hello, I want to send the data from Rslogix500 to Excel. I created a connection between RSlinx and Excel. The values in Excel automatically...
Replies
5
Views
1,130
Is it possible to pull information from a specific cell in an excel spreadsheet and use it in a program? I am wanting to display a time amount for...
Replies
4
Views
1,143
Dear Friends; I am trying to read the Tag Values in excel by using VBA. I write a code but was stuck on the following error: Dim OPC Server1 As...
Replies
21
Views
6,267
I have a issue with one PLC that takes much time to response to excel through DDE and on FactoryTalk Site Edition Local. I have already tried...
Replies
4
Views
2,113
Hello I am working in a project where I have to read data from an excel file. I'm not sure whether this is possible. The screen that I'm using is...
Replies
6
Views
2,091
Back
Top Bottom