Note: If you only want to recommend users to open the Excel file as read-only, without protecting it, don't enter a password and check Read-only recommended. We have a 2007 excel spread sheet that was saved to 2003. It seems that no-one is able to provide an answer as to how to get Access 2003 to open the file in read-write mode, or even to verify that this is indeed the problem when Excel 2007 is installed. Now you have been able to edit excel file and make any changes to worksheet or workbook. The results are the same for the 2003 user, it opens in read only with the X1000001 file name. Your workbook is read-only now. Here you can use the Protect Worksheet and Unprotect Worksheet utilities of Kutools for Excel to quickly protect or unprotect multiple worksheets or all workrksheets in current workbook with password at the same time in current workbook.
You can delete the old Excel file, and rename the new Excel file name to the old one. If the workbook is read-only, I don't think we can save as it with the same file name successfully. No, I don't believe that's what essexboy was thinking. I tried changing the Open line to: xl. If this is the case, you need to request permission from the original sender. If you want to modify this Excel file, click on No to open it.
Feel free to post back for an update and let us know if you need more help. Press the Ctrl + 1 keys simultaneously to open the Format Cells dialog box. Open this Excel file, you will find the read only is disable. Create a new discussion If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Click on Security tab 4.
This measure is more a suggestion than a requirement, and you can get around it easily. Rob Hi, Since you said you want to change the FileFormat, are you sure the file name is matched to the file format? With an account that has write permission click tools then protection and make sure those setting have the sheet un protected. Yes, if the privileges they are given say they can read and write. Malicious users can edit the file and remove the password. James: this will indeed be the cause in most cases. Surely, read-only excel file could prevent accidental changes on it. This is using Excel Version 1808 Build 10730.
I've had the same problem pop up a couple of times around here. Download a tool called , install it on computer. I do not want to change the filename, only the filetype. Click Protect Workbook in the same location and type password to unprotect workbook structure and windows. Quote from: Jaynet Zhang TechNet Community Support. Otherwise, you just could let excel file read-only all the time.
Restricted by Password Although password restriction is different from being marked as read-only, you won't be able to make edits to your Excel sheet if it's password protected. Locate the file or folder on which you want to take ownership in windows explorer 2. Close the file if it is there, you should be able to open it in excel now on the workstation. But read-only mode could be removed or disabled as you wish anytime when you want to edit excel file? But maybe the Save method also allows me to set that parameter. Once you click this, you are able to edit the Excel document.
As I personally discovered, in some cases it won't. On the Review tab, click Protect Document. In addition, if you are sure you can do that manually, I suggest you recording a macro about the process of saving as the workbook without changing file name in Excel. I was about to say that I can't use the Save method, because I want to change the FileFormat. It will list your name, your staff and everyone else who has access to this file.
Enter a file name and click Save. Using Efficient And Powerful Tabs In Excel, Word And Other Office Applications, Just Like Chrome, Firefox, Safari And Internet Explorer. And then read only is disabled on this Excel file. Hi Chris, Getting your document a read-only file means that the document can be read or copied but not modified. Depending on your network setup, the setting might be Enable Protected View for files originating from the Internet. Kerry -- Dave Peterson ButtonSave AsExcel WorkbookToolsGeneral Options.