You can change this by going to the data directory or files you wish to change and simply add the Win7 user s you want to be able to edit these files without giving Excel too much access to the system run as Administrator. How to Grant Permissions in Windows 7 1. For example I will be able to open the file normally and then the next time I try the message says that the file is locked for editing by myself or another user. Are you saying there are people using different versions of Excel working with that file? The calculations all work fine, the problem is with the layout and format of what they see. One of these remote users is having a problem saving to the shared file. It is just the opening of the first file in the browser that comes up read only. You'll want to uncheck the box that says Enable Protected View for files located in potentially unsafe locations.
I understand things happen, I just need Microsoft to have open communication so I can give an explanation to my bosses. Technically it might not be supported or allowed, but it would be nice to have some clear documentation from Microsoft on this. I can then close the first file and reopen it with the shared workspace of Excel 2003 and now both files are open as shared. Everything seems to take 5 clicks now instead of 1 or 2 before. It is the worst thing to happen to me, and that includes my divorce. Could having another user with an earlier version of Office 2003 or 2007 edit the workbook cause problems for the person with Office 2010? Is there an update on how the roll out is going? So I can then close the first read only and then reopen from shared workspace and get all 3 open as editable. One was created with 2007 read only-perfect and the latest with 2010 which i have to lock so nothing happens to it.
Policy Settings Microsoft Excel's policy settings control which files it opens in Protected View and which it automatically allows you to edit. I'm still thinking it is a permissions problem but I could be wrong. In the Custom Views dialog box, select the views you want to remove, and click Delete. If I open Excel, it should just look at my license and see that I'm licensed for Excel and I'm not over my limit of devices and allows me to run it. What would be the logical reason to not apply this same shared computer usage to all business level licensed O365 users? I have checked the shares on the server and there is no lock on them. It showed that she did not have access to the new folder new year where the file was now being saved.
I want people to be able to open, look-at and print the documents but not change them. If I then open a different Excel file from within the shared workspace of Excel 2003 the file opens as shareable. Should this have worked or is this feature not yet implemented for Business versions? If anything is unclear or if there is anything I can do for you, please feel free to let me know. However it did not allow both licensed groups to authenticate, only E3. In such situations, Excel keeps the changes of the user who saves the workbook first. I just want to be sure the roll out actually began. Any advice would be greatly helpful.
We are using Office 2003 applications, is the process applicable to Office 2003? This even happens if we open the same file at the same time. Once you click this, you are able to edit the Excel document. All other excel files both local and network open fine. If someone has been able to get shared computer use Office installs to work with O365 Business Premium licensed users, please let me know how you did it. At the top under the General tab will be a box checked if the worksheet is locked.
Get Microsoft Excel tips with help from a software expert in this free video series. When I first posted it was read only as noted. To summarize where I am at now, when I first open one of the 3 Excel files from company documents in my browser, it is read only. This is going to cause a pop-up window to open. If it can't find the File Location, try re-establishing the shortcut with a new one based on the correct file location. In Excel 2016, you can simply click the Share button in the upper-right corner, save the workbook to a cloud location OneDrive, OneDrive for Business, or SharePoint Online library , type email addresses in the Invite people box, separating each with a semicolon, and then click the Share button on the pane please see the screenshot below. File Properties Under Microsoft Windows or on a Mac, you can set a file's properties so it becomes read only.
If Read-Only in the lower portion of the dialogue box is even partially selected, have them clear it. Before you install the release version, you must remove the preview from your computer. By this way you can make an workbook in excel 2010 read only and prevent users from making any changes to the file. This setting changes file permissions to make the document read-only. If someone from Microsoft can clarify if this shared use will apply to all Business level licensing or not, that would be much appreciated? Originally, Microsoft stated the roll out would begin mid-april then changed to April 30th. The detailed steps on how to do this can be found.
It did when I had Office version 1808 installed. If it does not open in read-only, then the problem probably does reside in sharepoint. When this users try to access this share folder from other pc no use tht 3 pc having the problem. The users can each run Office programs, such as Word or Excel, at the same time on the remote computer. Multiple users need to be able to access and modify the same document. If it is you that have been disconnected, you can preserve your work by saving the shared workbook with a different name, then reopen the original shared workbook and from the copy you've saved.
The workbook opens, and he can write to it, but when he goes to save, the file doesn't allow him to save to the shared file, but claims it's a read-only file. Get out of the Excel program, closing the worksheet. About 6 months ago this changed, even if I select edit workbook it still opens as read only. With a single email, a colleague can share a complicated Excel worksheet for you to customize as needed. You are free to accept or reject their changes, and after the desired changes have been incorporated, you can stop sharing the workbook. I think I have the permissions set correctly. Why would Microsoft skip over O365 Premium for shared computer activation since it sits in between O365 Business and E3? This would display the following menu list Click on the Mark as Final menu, the following dialog box would appear.
But, once I have all 3 open on one user in editable format, the other users come up and say the file is locked by the first user and get a choice of read only or to be notified when the file i closed by user 1. You can see other users' selections in different colors, your own selection is traditionally green: Note. After some messing around, It was as noted in my last post - first user could open and make changes, other users would get a message saying read only because the fle was open by another user. Unless of course you have already done all this and are still having problems. It sounds like you are willing to use one of the 5 licenses. I have tried changing the protected view in the trust center with no avail. They have been working fine for months, this just started yesterday morning.