Then you won't have to worry about it hanging it up in read-only mode as the features would be disabled after you converted it to the 97-2003 version. But if you don't have the latest service pack installed I would start there. Now open the saved file again. As we have been upgraded to Excel 2010, I have saved the files as. File Properties Under Microsoft Windows or on a Mac, you can set a file's properties so it becomes read only.
How to open and recover. Now, with the new user highlighted, select the type of access you wish to allow. These were 2003 and 2007 xls files. The problem did not recur. Close the file if it is there, you should be able to open it in excel now on the workstation. Update This seems to have resolved our issue. I will show here two ways to disable the read-only from an Excel file.
The way that I resolved the issue was by saving the file as an Excel 97-2003 file, opening it and ensuring it wasn't in read-only, and then resave it as just a normal Excel file and then reupload it to the network drive. Then have them double click on the file to open it. Now click on Owner tab in Advance Security Settings for User windows 6. You can delete the old Excel file, and rename the new Excel file name to the old one. If the problem still exists after trying a reboot, then disjoin and rejoin the computer from your domain.
There are no excel sheets on the intranet but I guess they would behave the same. You do this by right-clicking on the directory or file and selecting Properties, then the Security tab. Do the same thing without the preview pane on. I believe we now know where the issue is with the user's account somewhere as only she can open it correctly. Click ok when Windows Security Prompt is displayed 10.
Or are you saying that the problem is specific to Word files and that it doesn't happen with, say, Excel spreadsheets? Way 4: Forgot read only password Here will show you the way to remove the read only password in a few seconds without opening the Excel file. The default format for Excel 2007 followed this plan, and the file extension for its workbooks changed from. When the Excel file is made to read only by marked as final, typing, editing, commands, and proofing marks are disable and turn off. In two seconds, a dialog box pops up saying the read only password is removed. Excel uses two sets of Trust Center Settings to determine how it handles these files.
There are several ways to get around this issue: Recommended The simplest and most secure method to get around this issue is to simply click the Enable Editing button, on a per-document basis, when you open an Excel or other Microsoft office file that has been downloaded. Locate the file or folder on which you want to take ownership in windows explorer 2. You won't be able to edit anything on this read only Excel file, unless you remove the read only from it. As I personally discovered, in some cases it won't. In that case, you can make your file read-only with a password.
Clear the read-only status of a workbook. We are currently investigating this further and will post more information as it is available. Because an Excel workbook can carry a malware payload designed to damage or control your computer, Excel includes features that protect you from documents it considers untrustworthy. Now under Permission section check the rights which you want to grant i. Don't believe its the preview pane and no read only boxes are checked. If you want to modify this Excel file, click on No to open it. We are currently investigating this further and will post more information as it is available.
Malicious users can edit the file and remove the password. Skinny Superman - Documents on a network is trusted and is checked in the settings to be allowed. How can I open Excel as an admin all the time by default? If the read-only file is not password protected If the read-only excel file is made without any password, you can easily disable the read-only from the file. For the best file compatibility, you should make changes using the same version of Excel with which the file was created. When you open the file, if it is flagged as read only attribute Excel opens it in read only mode and that is fixed. Uncheck 'Details Pane' and 'Preview Pane'. I agree to my information being processed by TechTarget and its to contact me via phone, email, or other means regarding information relevant to my professional interests.
In this article, I will teach you the whole process and also show you how you can disable the read-only option from an Excel file. Close out of the original file, and reopen Excel. This setting changes file permissions to make the document read-only. One could be just made read-only and another one could password protected. The spreadsheets are not password protected. CeeFixes wrote: I ran into this issue just the other day.