Skip navigation

Excel sheet Read only

29347 Views 27 Replies Latest reply: Feb 17, 2014 3:13 PM by edgeonedge RSS
  • Patrice77 Level 1 Level 1 (0 points)
    Currently Being Moderated
    Sep 18, 2012 6:49 AM (in response to hellosamuel)

    You nailed it my friend, that was my exact problem (i.e. / verus - ), who would have taught.  Thanks for saving my hours!!!

  • Patrice77 Level 1 Level 1 (0 points)
    Currently Being Moderated
    Sep 18, 2012 6:50 AM (in response to hardeep11)

    Thanks to hellosamuel for saving me hours

  • vitorneto Level 1 Level 1 (0 points)
    Currently Being Moderated
    Sep 20, 2012 2:04 PM (in response to hardeep11)

    hi there

     

    well i have been having this issues with some of the users getting this read only problem.

    So here it goes, microsoft needs to improve there coding!!

     

    in my case and i say this it might not work for all of you, (well i hope it does) the users always were using the slash ie, myfile_from_20/09/2012.xlsx.

     

    the solution that worked for me was to remove the slash and put a dash. now when they open it, it is no longer read only.

     

    i really hope this helps!, its people like you and me that make the problem solving a bit easier!

    So as someone once said.......

     

    THINK DIFFERENT!  AMEN

     

    VITOR

  • Micke.Goteman Level 1 Level 1 (0 points)
    Currently Being Moderated
    Jan 10, 2013 9:25 AM (in response to William Mcavinney)

    Same thing here. Excel 97-2004 .xls seem to allow / in the file name but 2011 .xlsx does not. Saving with - between the dates solved it for me too. Thanks everybody for the needed help and learning something new.

  • Florida Badger Level 1 Level 1 (0 points)
    Currently Being Moderated
    May 17, 2013 6:19 AM (in response to Micke.Goteman)

    Ditto on Excel Offfice for Mac 2011 converting .xlsx to read only when using "/" in filename.  Taking / out of file name corrected problem.

  • coldcall2bets Level 1 Level 1 (0 points)
    Currently Being Moderated
    Jul 11, 2013 1:35 PM (in response to hardeep11)

    Another confirmation that elminating the "/" solves this issue.... odd isn't it.

  • jasonscheltus Level 1 Level 1 (0 points)
    Currently Being Moderated
    Jul 24, 2013 9:43 PM (in response to hardeep11)

    I have also had this problem, and removing the "/" in the file name has solved the problem. Using Excel 2011. Cheers, Jason

  • mathcoach Level 1 Level 1 (0 points)
    Currently Being Moderated
    Aug 21, 2013 9:25 AM (in response to hellosamuel)

    hellosamuel:

    Thank you! Simplest solution. Ughhh! how did I not think of this!

    Peace!

    sev

  • BK182 Level 1 Level 1 (0 points)
    Currently Being Moderated
    Oct 11, 2013 9:12 AM (in response to hellosamuel)

    I was having the same problem and changing the / to a - worked perfectly!  Thank you!

  • CleverCrystal Level 1 Level 1 (0 points)
    Currently Being Moderated
    Oct 28, 2013 10:13 AM (in response to hardeep11)

    I don't have / in my file name, and it still happened.  The file is not locked, and I read/write privileges for the file and the folder.

     

    This Read Only issue occurs periodically for me.  When it occurs, I am able to save the file under a new name in the same folder. I just can't use the original file name.  This is really problematic for me.

     

    Any other suggestions?

  • hansposthumus Level 1 Level 1 (0 points)
    Currently Being Moderated
    Jan 18, 2014 5:33 AM (in response to hardeep11)

    Hi guys

     

    I have the same problem; not using anything else but letters and numbers, and sometimes it goes okay for weeks, sometimes all files are locked read only....

     

    help, very irritating!

  • Viewfinder Level 1 Level 1 (5 points)
    Currently Being Moderated
    Jan 26, 2014 3:46 PM (in response to hellosamuel)

    Same issue of read-only Excel spreadsheets..... SOLVED.... by your excellent answer to replace "/" with "-" in name.

     

    Thank you hellosamuel!

  • edgeonedge Level 1 Level 1 (0 points)
    Currently Being Moderated
    Feb 17, 2014 3:13 PM (in response to Micke.Goteman)

    I am having the same problems, but do not have any special characters in the filename. Saving as an xls file instead of xlsx did not solve the problem. I now have the file under four names. Any other suggestions?

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.