Opening excel document problem

Joined
Dec 16, 2010
Messages
9
Reaction score
0
Points
1
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!
 
Joined
Apr 26, 2008
Messages
2,963
Reaction score
120
Points
63
Location
Belgium
Your Mac's Specs
iPad Pro 12.9 latest iOS
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
 
Joined
Apr 26, 2008
Messages
2,963
Reaction score
120
Points
63
Location
Belgium
Your Mac's Specs
iPad Pro 12.9 latest iOS
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
 
Joined
Jul 30, 2009
Messages
7,297
Reaction score
301
Points
83
Location
Wisconsin
Your Mac's Specs
Mac Mini (Late 2014) 2.6GHz Intel Core i5 Memory: 8GB 1600MHz DDR3
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?
 
Joined
Mar 17, 2009
Messages
3,626
Reaction score
111
Points
63
Your Mac's Specs
2018 15" MBP, 2019 11" iPad Pro, iPhone 11 Pro
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.
 
Joined
Jul 12, 2011
Messages
9
Reaction score
0
Points
1
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.
 

BrianLachoreVPI


Retired Staff
Joined
Feb 24, 2011
Messages
3,733
Reaction score
124
Points
63
Location
Maryland
Your Mac's 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?
 
Joined
Jul 12, 2011
Messages
9
Reaction score
0
Points
1
Tried that and saved in a different directory as well.
Still struggling...
Grant
 

vansmith

Senior Member
Joined
Oct 19, 2008
Messages
19,924
Reaction score
559
Points
113
Location
Queensland
Your Mac's Specs
Mini (2014, 2018, 2020), MBA (2020), iPad Pro (2018), iPhone 13 Pro Max, Watch (S6)
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?
 
Joined
Jul 12, 2011
Messages
9
Reaction score
0
Points
1
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.
 
Joined
Sep 20, 2012
Messages
1
Reaction score
0
Points
1
who would thought slash against a dash

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
 
Joined
Jul 12, 2011
Messages
9
Reaction score
0
Points
1
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.
 

Shop Amazon


Shop for your Apple, Mac, iPhone and other computer products on Amazon.
We are a participant in the Amazon Services LLC Associates Program, an affiliate program designed to provide a means for us to earn fees by linking to Amazon and affiliated sites.
Top