Is my analysis of the situation correct, and - more importantly - is there a solution? Dont suppose you know how to clear the file now available box that appears after the code completes? If somebody could help me out that would be great. Note: These steps are for System Administrators or personnel with Administrator access to the server where the Excel file resides. Is there a way to get this error message out of the way or work around it? ScanDisk found 2 errors, but I told it to fix them. How can I make it open said file as read only? But read-only mode could be removed or disabled as you wish anytime when you want to edit excel file? Click to participate the survey. Also I tried disabling the preview pain as JamminJoe suggested didnt work either. Thanks for helping make community forums a great place. When I open the properties of the file before I open it, the check box for read only is unchecked so I believe it should be good to go there.
This is true whether you right-click the mouse, go to the edit menu, or use control keys. The search bar cell is D2. The new user who wants to edit the file now will be able to exit Excel, then re-open the file to edit it. Rob If you read my original post carefully, you'll see that the changed Open line with the ReadOnly parameter is an attempt to set the ReadOnly parameter to False when I open the file - and that fails. Mine has Office 2010, so I think there might be an issue with the file itself.
Now in this article, I will list several possible cases that make your workbook and worksheet read only and introduce how we can do to remove read only status from Excel file. Does anyone know how I can change the files that Excel loads upon start up? I am just trying to narrow it down a bit. I've been working in technology for over 20 years in a wide range of tech jobs from Tech Support to Software Testing. So when the end of the week is done I have all the Employees weekly hours and days worked all finished. Rob Hi, Since you said you want to change the FileFormat, are you sure the file name is matched to the file format? If time does not fix the problem then copy or re-name the file may fix it. Im not concerned if they lose any data they've entered as I'm sure this will help them get the message to get out the file quicker.
Their file system was set up on a external hard drive which was connected as a lettered drive which was being shared from one computer to another, with the backup of the hard drive just being copied and pasted to the C drive of the main computer makes no sense to me but this is how it was set up. I have a macro that opens multiple files and runs code on them. Hi Luna, I take your point about matching the file extension to the file format. About the workbook became read-only after code running: You may need to check whether this workbook had been occupied by a background Excel process. Just a quick update and answers to your questions. She has the Preview Pane turned on in Explorer.
Here is the problem: I have a column of 14 numbers in cells A1 to A14. For stronger protection, require a password to save changes. Click to participate the survey. Rob Hi Daniel, From the threading I see here, it seems you're replying to my original post; however, your question seems as if it applies to my follow-up reply to chunchencool. This will remove the link to the corrupt workbook and only data content will be retained. Oh, and make sure you're not just trying to double-click through explorer--try File-Open from Excel. Read the solutions to fix this error below: Solution 1: Manually Open the File Recovery mode File Recovery mode is a native Excel recovery utility that automatically opens whenever any inconsistencies are found in the worksheet.
Name Any help would be apreciated. Along with manual Excel repair procedures, the blog also suggests an automated tool to execute the repair process for the retrieval of all possible data from a corrupt workbook. Alternative Solution — Stellar Repair for Excel If the above manual methods fail to fix the unreadable content error from Excel 2013 worksheets, then you can leverage the tool to fix this error. I tried changing the Open line to: xl. Only one of those two files were saved by Norton. So the problem seems to be only when I try to do this programmatically from Access.
Choose Read-Write to open it for editing. Name Any help would be apreciated. When I first started in this office. Also malware bytes and windows defender for antivirus. Feedback Buttons provided by - Copyright © 2019 DragonByte Technologies Ltd. Clear the read-only status of a workbook Note: If your workbook is shared, anyone who has Write privileges can clear the read-only status.
Doing Word's recover didn't do anything useful to it. This file is to track about 100 employees that are on a rotational work schedule. If the user has read-only permission without Office Web Apps installed , the user will not be able to click Edit Document in the ribbon. How can I get this to apply to all of the cells from A1 to A14? Some users have read only access. Hi, According to your description, I think the issue may be related to the FileFormat argument of.