Skip navigation

Excel sheet Read only

29193 Views 27 Replies Latest reply: Feb 17, 2014 3:13 PM by edgeonedge RSS
1 2 Previous Next
hardeep11 Level 1 Level 1 (0 points)
Currently Being Moderated
Apr 5, 2012 8:49 AM

I have office 2011. I have an issue with excel sheet, whenever I make new excel sheet and save it. I cant write in this sheet next day, it becomes read-only file. then i have to make the new excel sheet. Is their anybody who can tell me, How to remove that read-oly tag from my excel sheet file.

 

 

Thanks

MacBook Pro, iOS 5.0.1
  • BDAqua Level 10 Level 10 (114,665 points)
    Currently Being Moderated
    Apr 5, 2012 11:09 AM (in response to hardeep11)

    Hello,

     

    Do a Get Info on the Folder that these are in, at the bottom do you have Read Only privileges for that folder?

     

    If you do a Get Info on that Excel sheet file, can you change it so you have Read & Write?

  • BDAqua Level 10 Level 10 (114,665 points)
    Currently Being Moderated
    Apr 5, 2012 12:14 PM (in response to hardeep11)

    Where are these files exactly, path wise?

     

    As far as the Locked, is the Red arrow's box checked?

     

    As far as rights, have you expanded the little triangle & unlocked the Blue Arrow's lock with an admin Password?

    GetInfoLoced&Lock.jpg

  • BDAqua Level 10 Level 10 (114,665 points)
    Currently Being Moderated
    Apr 5, 2012 1:43 PM (in response to hardeep11)

    For ownership and permission, i did choose the option read and write only

    Was that on both the folder above, (never did hear what that folder was or where it is), & the File both?

  • BDAqua Level 10 Level 10 (114,665 points)
    Currently Being Moderated
    Apr 5, 2012 3:34 PM (in response to hardeep11)

    Did you check Documents & the sub folder?

     

    http://support.apple.com/kb/HT2963

  • BDAqua Level 10 Level 10 (114,665 points)
    Currently Being Moderated
    Apr 5, 2012 4:16 PM (in response to hardeep11)

    Were you able to change the file's rights in the Finder to You Read & Write?

     

    What happens if you open the File & save a copy somewhere else?

  • William Mcavinney Level 1 Level 1 (0 points)
    Currently Being Moderated
    Jun 11, 2012 4:40 PM (in response to hardeep11)

    Hi,

     

    I've had this problem and found that saving the file in Excel 97-2004 Workbook (xls) format cured it. The file I had this problem with had a date (m/d/yy) included in the file name. Removing the date also worked, but that wasn't a good solution for me.

     

    Bill

  • hellosamuel Level 1 Level 1 (0 points)
    Currently Being Moderated
    Jun 25, 2012 9:38 PM (in response to William Mcavinney)

    Another solution we found is the you can not use '/' in the name of your file. It will allow you to save it on your mac, where as in Windows it says you can't use the character / (backslash) however once you save it and reopen it on a mac, it will be read only....

  • vbekkerm Level 1 Level 1 (0 points)
    Currently Being Moderated
    Sep 11, 2012 9:28 PM (in response to hellosamuel)

    Thank you, hellosamuel!! Replacing / with - worked.

1 2 Previous Next

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.