Results 1 to 13 of 13
  1. #1


    Member Since
    Dec 16, 2010
    Posts
    9
    Opening excel document problem
    I have excel document and when opening it in my mac is show me open read-only, why? What can i do to continue work on it in mac.
    It will taking me a lot of time to make a new document and rewrite that document with all commands and my calculating.

    P.S: Why in every post i need to write confirmation code?

    Thanks!

  2. #2

    McBie's Avatar
    Member Since
    Apr 26, 2008
    Location
    Belgium
    Posts
    2,769
    Specs:
    2013 MBA 13" - OS X 10.11
    Maybe the person who created the Excel sheet assigned a password to it, to prevent changes.
    What app. are you using on the Mac to open the Excel sheet.

    Cheers ... McBie
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila.
    The bitterness of poor quality remains long after the sweetness of low price is forgotten.

  3. #3


    Member Since
    Dec 16, 2010
    Posts
    9
    .
    No password.
    I'm using Microsoft Excel 2011 for Mac.
    Any ideas?

  4. #4

    McBie's Avatar
    Member Since
    Apr 26, 2008
    Location
    Belgium
    Posts
    2,769
    Specs:
    2013 MBA 13" - OS X 10.11
    Can you post a screen shot of the error message ?
    Also check the file attributes of the Excel sheet .... it may be set to read only on the file system.

    Cheers ... McBie
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila.
    The bitterness of poor quality remains long after the sweetness of low price is forgotten.

  5. #5

    toMACsh's Avatar
    Member Since
    Jul 30, 2009
    Location
    Wisconsin
    Posts
    6,131
    Specs:
    Mac Mini (Late 2014) 2.6GHz Intel Core i5 Memory: 8GB 1600MHz DDR3
    Quote Originally Posted by Xtrician View Post
    I have excel document and when opening it in my mac is show me open read-only, why? What can i do to continue work on it in mac.

    P.S: Why in every post i need to write confirmation code?
    Highlight the document in a Finder Window. File > Get Info (or Command-I)
    Click the padlock at the bottom, supply your password.
    Click the Permissions arrow to expose the settings
    Change it to read and write for your user name
    Lock it back up

    post? confirmation code?
    Since I'm not confident in your use of the terminology, I can't decipher that one. Can you explain it further?

  6. #6

    MYmacROX's Avatar
    Member Since
    Mar 17, 2009
    Posts
    3,625
    Specs:
    2008 15" MBP Yosemite, 2012 21.5" iMac Yosemite
    Quote Originally Posted by toMACsh View Post
    post? confirmation code?
    Since I'm not confident in your use of the terminology, I can't decipher that one. Can you explain it further?
    I think the OP is referring to the captcha confirmation that is required for first-timers. It stops asking you after a while. Just keep posting and it'll go away eventually.
    64GB iPhone 6, 64GB iPad Air 2.

    Reminder: Please include your Mac's specs. This will make it much easier for the other members to assist you.

  7. #7


    Member Since
    Jul 12, 2011
    Posts
    9
    Same problem
    I am running Office 2011 for Mac and can not open .xls or .xlsx files that are located on my HD.
    I checked file permissions and all were fine.
    I recently bought a Mac to replace my problematic 2 year old PC laptop.
    I transferred some important work files from the PC via flash drive.
    The exact same files open fine on the mac directly from the flash drive and all other files (such as .doc and .pdf) in the same directory open fine.
    When I save them to any directory on the HD, they won't open at all.

  8. #8

    BrianLachoreVPI's Avatar
    Member Since
    Feb 24, 2011
    Location
    Maryland
    Posts
    3,733
    Specs:
    March 2011 15" MBP 2.3GHz i7 Quad Core 8GB Ram | Mid 2011 27" iMac 3.4 GHz i7 16 GB RAM 2 TB HDD
    Can you save it to your HD using a different name?

  9. #9


    Member Since
    Jul 12, 2011
    Posts
    9
    Tried that and saved in a different directory as well.
    Still struggling...
    Grant

  10. #10

    vansmith's Avatar
    Member Since
    Oct 19, 2008
    Location
    Toronto
    Posts
    19,782
    Specs:
    2012 13" MBP (2.5 i5, 8GB)
    Check the permissions. Right click the file that you copied to your HD > Get Info > Sharing & Permissions. Make sure your user has read permissions (if you just want to view it) or read & write (if you want to be able to view it and make changes).

    Do you get any sort of error message?

    EDIT: Just see now that you've checked the permissions. What are they set as?
    Important Links: Community Guidelines : Use the reputation system if you've been helped.
    M-F Blog :: Write for the blog
    Writing a Quality Post

  11. #11


    Member Since
    Jul 12, 2011
    Posts
    9
    They are set as read and write.
    The two things I find odd are:
    1) the files read/write fine from the flash drive but not on the HD, and
    2) the other files in the same directory such as .doc read and write just fine from the HD.

  12. #12


    Member Since
    Sep 20, 2012
    Posts
    1
    who would thought slash against a dash
    Quote Originally Posted by Xtrician View Post
    I have excel document and when opening it in my mac is show me open read-only, why? What can i do to continue work on it in mac.
    It will taking me a lot of time to make a new document and rewrite that document with all commands and my calculating.

    P.S: Why in every post i need to write confirmation code?

    Thanks!

    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

  13. #13


    Member Since
    Jul 12, 2011
    Posts
    9
    My HD was named some strange thing with odd characters and for some reason this conflicted with the excel program.
    I renamed my HD to Mac HDD and voila! Problem solved.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel 2011 not opening newest document
    By Cagu422 in forum OS X - Apps and Games
    Replies: 3
    Last Post: 02-15-2015, 09:27 PM
  2. Excel 2011 not locking document when editing
    By Bromd123 in forum OS X - Apps and Games
    Replies: 0
    Last Post: 10-17-2014, 04:53 AM
  3. Numbers document converted to Excel gone wrong!
    By TheLegend in forum OS X - Apps and Games
    Replies: 2
    Last Post: 03-01-2012, 06:23 PM
  4. Microsoft Word 2008 problem - not opening latest version of document
    By dogtonharrants in forum OS X - Apps and Games
    Replies: 1
    Last Post: 01-17-2010, 03:43 PM
  5. Updating Excel document over a network?
    By Garnon in forum OS X - Apps and Games
    Replies: 3
    Last Post: 05-26-2009, 03:41 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •