But when I run Excel as an Administrator holding ctrl+shift and then open the excel file it opens with read and write permission. I'll uninstall it and see if I get the same behavior. . If you open the document later on, Excel will say that it is broken, in use or weiteprotected. Step 1: Open the Excel 2016 workbook. But opening it programmatically in Access now opens it as ReadOnly - even though opening it directly in Excel does not. Note: If you open a copy of the file, then a duplicate version of the same file is created in the directory of the original file.
Close out of the original file, and reopen Excel. I ended up copying the entire big folder tree to MyDocuments, and then opening all the databases from there. Are you sure the workbook you want to open is not opened before you run the code and you can save as the workbook manually? Proffitt I don't use Microsoft's email login because I am not a moron. You can check this on your server for verification. Rob Hi, I also didn't change the filename when using SaveAs method. So the problem seems to be only when I try to do this programmatically from Access. If the problem still exists after trying a reboot, then disjoin and rejoin the computer from your domain.
It is only one computer sharing with one other computer. It's more an annoyance then an effect safety feature. There are numerous suggestions for other read only files in this thread above. I think I've finally hit the wall with Microsoft, this is a deal breaker and their ignoring tweets about it as well - in fact I just looked for mine and it looks like they've removed it! No one expects every day folk to understand or follow the instructions so far. It is the next general release update. It works exactly as stated to solve the nasty problem.
This seems to me to be a bug in this situation - there doesn't seem to be a way to force the file to open in read-write mode. Save excel file and read-only mode would be removed from excel file. For information on how to Activate Office, see:. Have you tried the code Luna provided? Maybe this will be a boon for Apple but here it's all good. File info in finder shows the file unlocked.
Maybe there is some registry settings to be changed or some incompatibility between Widows 7 workstations and Windows 2003 sbs shared folder. Sometimes this issue manifests after you attempt to sync a document that requires check-in on OneDrive. Google eart is a Rugby ball?! On windows I have looked around if there is any way using notepad++ or other popular editors to get the same behavior as on Linux. But you can open it from Internet Explorer. My job depends on it Thank you so much LibreOffice is a free download. Getting back to this, I put a box together with no McAfee on it whatsoever, problem still exists, so McAfee isn't the culprit here. Your Mac will take a long time to boot up as disk repair and maintenance utilities run in the background.
Any advice would be greatly helpful. May be like a right click and say open read only or edit mode etc. Otherwise, you just could let excel file read-only all the time. Thanks for helping make community forums a great place. You need to take ownership of the folder where the excel file is, just follow the steps below: 1. Hi Jennifer Thanks for your suggestion.
Just like in Linux using less would open it by default in read only mode and vi or vim would open to edit it. It also nerfs some of their tracking, apparently, but that could change with the constant updates. I am just trying to narrow it down a bit. I have been using a computer since 1984 and have never ran across this problem. However, your answer about the Details Pane is correct. In some versions of Windows you choose Options from the View menu. You can check the file properties by right-clicking on the file and choosing Properties.
Hi Luna, I take your point about matching the file extension to the file format. Those fonts are not in the font library anymore. How can I open Excel as an admin all the time by default? Hi, According to your description, I think the issue may be related to the FileFormat argument of. The solution is an easy one. What originally caused the problem was this.
The New Action dialog box expands. How to open a new copy of a Excel file? When the update is installed, the fonts that come with Office should be replace automatically. Ever since then I have had this problem only a couple of days. Any further idea will be very appreciated, Thanks in advance for your help… We are having this issue as well even when no local copy of Office is installed on the computer. I don't really mind Windows asking me if I'm sure to want to copy something to Program Files folder. In this case, to disable read-only, you need to unprotect the sheet by the following steps. These lockfiles are usually hidden, so you wanna make all files visible by using the terminal command Google.
We use McAfee agent here as well. Office 2016 Office 2010 Office 2013 You may find that when you are opening files, they open as read-only. My original - which worked perfectly well - did not have that. Right Click on your Documents folder or whatever folder contains the documents and choose Get Info. Thanks for helping make community forums a great place. Surely, read-only excel file could prevent accidental changes on it.