hardeep11

Q: Excel sheet Read only

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

Posted on Apr 5, 2012 8:49 AM

Close

Q: Excel sheet Read only

  • All replies
  • Helpful answers

first Previous Page 3 of 3
  • by akoniski,

    akoniski akoniski Aug 12, 2014 7:50 AM in response to vbekkerm
    Level 1 (0 points)
    Aug 12, 2014 7:50 AM in response to vbekkerm

    This worked for me as well.  Usually know to avoid / but every once in awhile I forget. 

  • by cemlyn,

    cemlyn cemlyn Mar 21, 2015 5:55 PM in response to hellosamuel
    Level 1 (0 points)
    Mar 21, 2015 5:55 PM in response to hellosamuel

    that darn '/'

     

    This has driven me nuts for weeks on end.  I have date stamped my folders for many years but recently I have loaded all my file onto a Windows share at work and kept a sync copy on my ext drive.  No matter what I did with permissions I could not edit an existing file.  Changing the '/' to '-' worked fine.  So simple

     

    Thank you

  • by Mezcalhead,

    Mezcalhead Mezcalhead Apr 30, 2015 3:41 PM in response to William Mcavinney
    Level 1 (0 points)
    Apr 30, 2015 3:41 PM in response to William Mcavinney

    This did the trick!   Should have checked here first before wasting hours!!!   Thank you sir!

  • by MichaelMitchell,

    MichaelMitchell MichaelMitchell May 7, 2015 12:39 PM in response to William Mcavinney
    Level 1 (0 points)
    May 7, 2015 12:39 PM in response to William Mcavinney

    I had this exact scenario - this worked, good solution!! Thank you!

  • by markcopolodipsidolo,

    markcopolodipsidolo markcopolodipsidolo Jun 8, 2015 6:07 PM in response to MichaelMitchell
    Level 1 (0 points)
    Jun 8, 2015 6:07 PM in response to MichaelMitchell

    I also had this problem but did not have any unusual characters in the file names. File located on a USB that was formatted Fat 32 MS DOS. Ownership of volume not enabled. I was able to save the file as a new version but this just narked me. In the end I found that by by removing the spaces out of the name, the problem went away. Who would have thought? Spaces, they got the power.

  • by smellieboy,

    smellieboy smellieboy Jun 10, 2015 5:54 PM in response to hardeep11
    Level 1 (8 points)
    Applications
    Jun 10, 2015 5:54 PM in response to hardeep11

    We had this problem on a file that had no unusual characters in its name (we were already aware of the dangers of /), but we noted that the file had a .xlsx extension, and found that saving it as .xls cleared the Read Only restriction, after which, we were able to 'upgrade' the file back to .xlsx.  I suspect that the Read Only tag had arisen from the file's closure not being properly recognised, and the system thinking that the file was still open.

     

    A bit more research reveals the following:

    1. XLS is based on BIFF (Binary Interchange File Format) and as such, the information is directly stored to a binary format.
    2. On the other hand, XLSX is based on the Office Open XML format, a file format that was derived from XML. The information in an XLSX file is stored in a text file that uses XML to define all its parameters.
    3. As XLSX is stored in a text file format, Microsoft decided to remove macro support for this file format. Instead they assigned a totally different file extension that allows the use of macros; it is named XLSM. The older XLS file extension does not have this issue and it is able to hold spreadsheets that contain macros or not.
    4. In general, .xlsx/.xlsm files are somewhat less likely to become corrupt, and can be smaller, but if you make regular backups and have plenty of disk space, there's no reason to spend the time converting.

      OTOH, there's usually no reason not to take advantage of the OOXML formats for new files that you create.

    5. XLSX allows many types of formatting that XLS does not, all of those will be changed or lost. 
    6. Complex XLS files may support 4000 styles, compared to 65,536 in XLSX.
    7. If you exceed the XLS limit all the others will be lost for sure, but it may be that all formats are lost if you exceed the 4000 limit.
  • by reichman23,

    reichman23 reichman23 Oct 11, 2015 8:19 AM in response to hellosamuel
    Level 1 (0 points)
    Oct 11, 2015 8:19 AM in response to hellosamuel

    Thanks samuel! I been trying and trying to figure out why that one document was saving as 'read-only'. It's a timesheet I made, so I was saving it as 10/3 time, 10/17 time, and so on . Weird how that one / makes it save that way.

     

    anyway, thank you

  • by jkchat,

    jkchat jkchat Oct 12, 2015 9:19 AM in response to William Mcavinney
    Level 1 (0 points)
    Oct 12, 2015 9:19 AM in response to William Mcavinney

    Thanks William. I had the same problem with a file that I could not get out of "read only", and your solution solved the problem for me.

  • by steveebrafrombeverly hills,

    steveebrafrombeverly hills steveebrafrombeverly hills Apr 2, 2016 5:10 AM in response to hellosamuel
    Level 1 (4 points)
    Apr 2, 2016 5:10 AM in response to hellosamuel

    WOW!  Years of frustration on a daily basis finally resolved with your helpful suggestion.  It turns out every file I had an issue with was because I had the "/" in the name of the file which is how I name almost every file with a month and year for chronological ordering.  Thank you!

  • by jessica7yao,

    jessica7yao jessica7yao May 9, 2016 12:27 AM in response to hardeep11
    Level 1 (4 points)
    May 9, 2016 12:27 AM in response to hardeep11

    Awesome!!! Removing "/" helps me!

  • by Samuel Huskey,

    Samuel Huskey Samuel Huskey May 25, 2016 6:47 AM in response to hardeep11
    Level 1 (9 points)
    May 25, 2016 6:47 AM in response to hardeep11

    Another reason an Excel file might be opening as Read-Only: it might be in use by Word as the source file for a mail merge. If you need to edit the source file, you have to close the Word document that's using it first.

  • by BDAqua,

    BDAqua BDAqua May 25, 2016 7:56 AM in response to Samuel Huskey
    Level 10 (123,633 points)
    May 25, 2016 7:56 AM in response to Samuel Huskey

    Nice tip, thanks!

  • by camrun64,

    camrun64 camrun64 Jul 29, 2016 2:27 PM in response to hardeep11
    Level 1 (4 points)
    Jul 29, 2016 2:27 PM in response to hardeep11

    Thank you. Yes been having the same problem for a few weeks. Knocking off the s worked. Phew!!!

first Previous Page 3 of 3