I have just installed Win 7 on my XP system. I just make a fresh installation of win and keep all my other drive partition as it is. All my data were on D drive. The problem is that when I open my excel file it opens in read only format by default, but the properties is not set to read only, I already checked it. But when I run Excel as an Administrator (holding ctrl+shift) and then open the excel file it opens with read and write permission.
Mar 13, 2016 - If an author has made an Excel 2016 spreadsheet read-only to protect it from being modified by others but now you want to remove the. The Mac OS X Sharing & Permissions settings allow you to change who can view or edit certain files. Changing a file from read-only to read-write may require an.
How can I open Excel as an admin all the time by default? You need to take ownership of the folder where the excel file is, just follow the steps below: 1.
Locate the file or folder on which you want to take ownership in windows explorer 2. Right click on file or folder and select “Properties” from Context Menu 3. Click on Security tab 4. Click on “Advance” 5. Now click on Owner tab in Advance Security Settings for User windows 6. Click on Edit Button and select user from given Change Owner to list if user or group is not in given list then click on other users or groups.
Enter name of user/group and click ok. Now select User/group and click apply and ok. (Check “Replace owner on subcontainers and objects” if you have files and folder within selected folder) 9. Click ok when Windows Security Prompt is displayed 10. Now Owner name must have changed. Now click Ok to exist from Properties windows Once you have taken the ownership of file or folder next part comes is Granting Permissions to that file/folder or object. How to Grant Permissions in Windows 7 1.
Locate the file or folder on which you want to take ownership in windows explorer 2. Right click on file or folder and select “Properties” from Context Menu 3. Click on Edit button in Properties windows Click ok to confirm UAC elevation request.
Select user/group from permission windows or click add to add other user or group. Now under Permission section check the rights which you want to grant i.e check “Full Control” under the “Allow” column to assign full access rights control permissions to Administrators group.
Click Ok for changes to take effect and click ok final ok to exit from Properties window. Unless you used a backup or transferred the User from the old installation (Windows Easy Transfer) the user is considered 'new' and it's SID (Security Identified) has changed. An NTFS partition will detect this change and therefor no longer considers you the owner of the files. Rightclick on the partition, folder or file(s) and select Properties. Then click on the advanced button and 'Change Permissions'. Add your current user to the list with with 'Full control' and inherit these permission to the sub folders. If that doesn't work you can try resetting the permissions via an elevated command prompt: Use 'cd /D driveletter:' to navigate to the troublesome drive, then run the command 'icacls.
/T /Q /C /RESET'. This has to do with security settings on the filesystem. Since the OWNER/CREATOR was on the XP system, it can access the files normally, but all of your security identifiers on the Win7 installation do not have the correct SID (at a minimum, the machine portion has changed), so they are accessing the files as part of the Everyone, Users or Authenticated Users group which will normally only have read-only access.
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). You do this by right-clicking on the directory or file and selecting Properties, then the Security tab. Click on the Edit button and respond to any UAC prompt. Click on Add. Then type in the user accounts you want to give access to these objects.
Click Check Names to verify you haven't made a typo in the entries and if all is okay, click on the OK button. Now, with the new user highlighted, select the type of access you wish to allow. DO NOT REMOVE ANY USERS THAT START WITH 'S-1-'!
![Excel For Mac Read Only Excel For Mac Read Only](/uploads/1/2/5/6/125662039/752140714.png)
These are the XP user accounts and groups that have access to the files as well. Keep clicking on OK buttons to close the dialog boxes accepting the changes.
In my firm we have a Mac file server on our network and all users belong to a group that has read/write permissions to certain folders. A user complained about not being able to save a file on the server after working on it - she could save to other locations but not over this specific XLSX file. I reset the permissions on the folder and then checked the excel file. Sure enough, the read-only tag still appeared. I then duplicated the file and opened that. Interestingly it did not have a read-only tag.
I then added some text, saved, closed and re-opened the file, and the read-only text did not appear. So for now, I have solved my problem but am unsure what caused it. The file in question does not have any slashes, only alphabet characters, and there is no hidden file with the symbol. I was able to delete the file after confirming my duplicate was working, but only from a Windows machine.
Excel file opening in Read Only Mode I had this problem today, and finally figured out the solution. I had put a slash '/' in the filename, which is OK on the Mac, but Excel does NOT like it.
When I removed the slash from the filename (using the finder), the Excel file then opened normally. I often use slashes when adding the date as part of the filename. When working on an Excel, Word, or PowerPoint file, I have to remember to use dashes, not slashes. In this case, my filename included the phrase '64/128 bit register'. I changed it to '64 or 128 bit register'.
Hope this helps someone. I wasted a lot of time on it. MacBook Pro (Early 2011) running OS 10.8 Mountain Lion Office for Mac 2011 vers 14.2.3 (120616). Excel file opening in Read Only Mode I had this problem today, and finally figured out the solution. I had put a slash '/' in the filename, which is OK on the Mac, but Excel does NOT like it. When I removed the slash from the filename (using the finder), the Excel file then opened normally. I often use slashes when adding the date as part of the filename.
When working on an Excel, Word, or PowerPoint file, I have to remember to use dashes, not slashes. In this case, my filename included the phrase '64/128 bit register'. I changed it to '64 or 128 bit register'. Hope this helps someone. I wasted a lot of time on it. MacBook Pro (Early 2011) running OS 10.8 Mountain Lion Office for Mac 2011 vers 14.2.3 (120616). Excel file opening in Read Only Mode I had this problem today, and finally figured out the solution.
I had put a slash '/' in the filename, which is OK on the Mac, but Excel does NOT like it. When I removed the slash from the filename (using the finder), the Excel file then opened normally. I often use slashes when adding the date as part of the filename. When working on an Excel, Word, or PowerPoint file, I have to remember to use dashes, not slashes. In this case, my filename included the phrase '64/128 bit register'. I changed it to '64 or 128 bit register'. Hope this helps someone.
I wasted a lot of time on it. MacBook Pro (Early 2011) running OS 10.8 Mountain Lion Office for Mac 2011 vers 14.2.3 (120616). Excel file opening in Read Only Mode I had this problem today, and finally figured out the solution. I had put a slash '/' in the filename, which is OK on the Mac, but Excel does NOT like it. When I removed the slash from the filename (using the finder), the Excel file then opened normally. I often use slashes when adding the date as part of the filename. When working on an Excel, Word, or PowerPoint file, I have to remember to use dashes, not slashes.
In this case, my filename included the phrase '64/128 bit register'. I changed it to '64 or 128 bit register'. Hope this helps someone. I wasted a lot of time on it. Excel file opening in Read Only Mode I had this problem today, and finally figured out the solution. I had put a slash '/' in the filename, which is OK on the Mac, but Excel does NOT like it.
When I removed the slash from the filename (using the finder), the Excel file then opened normally. I often use slashes when adding the date as part of the filename.
When working on an Excel, Word, or PowerPoint file, I have to remember to use dashes, not slashes. In this case, my filename included the phrase '64/128 bit register'. I changed it to '64 or 128 bit register'.
Hope this helps someone. I wasted a lot of time on it. MacBook Pro (Early 2011) running OS 10.8 Mountain Lion Office for Mac 2011 vers 14.2.3 (120616). Microsoft is no help on this one. And no need to fiddle around with changing the name of the file.
Simply use TinkerTool or some other Mac utility program to set your Finder to show hidden files. Then reload the Finder. You will see a hidden file within the same folder as the Read-Only file with the same name except a (tilde) is in front of the name. Place this file into the Trash. This will clear your Read-Only condition.
Then use TinkerTool to hide hidden files and reload your Finder. Bill Gates placed that file into the folder to indicate to his programmers that the file was open (thus locked). Being that you did this on a different computer, left the file open, then copied the entire folder from the source computer to the one having the problem, it will be impossible to unlock the file without having the original computer to do it for you (or use the method I outlined). Moral of the story: think like Bill Gates, or don't copy files while they are open. Excel file opening in Read Only Mode I had this problem today, and finally figured out the solution.
I had put a slash '/' in the filename, which is OK on the Mac, but Excel does NOT like it. When I removed the slash from the filename (using the finder), the Excel file then opened normally. I often use slashes when adding the date as part of the filename. When working on an Excel, Word, or PowerPoint file, I have to remember to use dashes, not slashes. In this case, my filename included the phrase '64/128 bit register'. I changed it to '64 or 128 bit register'.
Hope this helps someone. I wasted a lot of time on it. MacBook Pro (Early 2011) running OS 10.8 Mountain Lion Office for Mac 2011 vers 14.2.3 (120616). Excel file opening in Read Only Mode I had this problem today, and finally figured out the solution. I had put a slash '/' in the filename, which is OK on the Mac, but Excel does NOT like it. When I removed the slash from the filename (using the finder), the Excel file then opened normally. I often use slashes when adding the date as part of the filename.
When working on an Excel, Word, or PowerPoint file, I have to remember to use dashes, not slashes. In this case, my filename included the phrase '64/128 bit register'. I changed it to '64 or 128 bit register'. Hope this helps someone. I wasted a lot of time on it. MacBook Pro (Early 2011) running OS 10.8 Mountain Lion Office for Mac 2011 vers 14.2.3 (120616).
Excel file opening in Read Only Mode I had this problem today, and finally figured out the solution. I had put a slash '/' in the filename, which is OK on the Mac, but Excel does NOT like it. When I removed the slash from the filename (using the finder), the Excel file then opened normally.
I often use slashes when adding the date as part of the filename. When working on an Excel, Word, or PowerPoint file, I have to remember to use dashes, not slashes. In this case, my filename included the phrase '64/128 bit register'. I changed it to '64 or 128 bit register'.
Hope this helps someone. I wasted a lot of time on it.