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.
How can I open Excel as an admin all the time by default?
Anónio 2013-08-15 02:09:00 I'm on a Mac, and I was having the same problem. After researching and nothing working, I've decided to change the name of the file, as it had a 'special character' - the '/'. I've just eliminated it, and the problem was solved. Kirkwood Donavin 2015-06-02 19:58:16 Also on Mac and / was my problem. Thanks! Prashant Mirjankar 2013-03-12 10:37:16 change property of the excel app in microsoft office folder in program files. and set always run as admin thats it Danny Zamolxis 2013-03-07 21:12:38 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 explorer2. Right click on file or folder and select “Properties” from Context Menu3. Click on Security tab4. Click on “Advance”5. Now click on Owner tab in Advance Security Settings for User windows6. 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.8. 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 displayed10. Now Owner name must have changed.11. Now click Ok to exist from Properties windowsOnce 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 71. Locate the file or folder on which you want to take ownership in windows explorer2. Right click on file or folder and select “Properties” from Context Menu3. Click on Edit button in Properties windows Click ok to confirm UAC elevation request.4. Select user/group from permission windows or click add to add other user or group.5. 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.6. Click Ok for changes to take effect and click ok final ok to exit from Properties window. hazem elsaiegh 2013-03-07 22:55:26 the link below is a RAR file contains 2 registry files one called take ownership and another called remove_owner ; the first will put take ownership in the context menu , so the file or folder you want will be taken by you easily just bu using this registr trick ( since the problem is i think is in ownership :) ) Sadman Hasan 2013-03-07 20:57:46 Check the Run as Administrator option in Compability! Nitesh Badala 2013-03-07 06:00:57 its security provided to your excel files. that no one can change data of these files.its actually password protected files. right click on your file ->properties->remove read only mode.it will help you. Jan Fritsch 2013-03-07 02:57:39 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" Bruce Epper 2013-03-06 23:33:32 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-"! 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. Hovsep Avedissian 2013-03-07 20:46:45 did you tried the first suggested method? Hovsep Avedissian 2013-03-06 22:54:00 go to your excell folderC:Program FilesMicrosoft OfficeOffice14excel.exeright click on excell.exe then click on compatibility there is a checkbox Privilege level; Run This program as an administrator
