Hi,
I am having a very worrying issue with Excel 2011 in office Mac 2011.
I have been sent a spreadsheet created in excel 2007 by a windows using colleague.
When I open it on the mac it shows as a read only document.
I altered the permissions under get info to "read and write" however when I try to enter any data in a field I get the following message:
THE CELL OR CHART YOU ARE TRYING TO CHANGE IS PROTECTED AND THEREFORE READ ONLY.
To remove protection, on the tools menu, point to protection, and click unprotect sheet. You may be prompted for a password.
I thought I was going mad, so I asked the sender to unprotect it. He said that it wasn't protected.
I then copied the file to a usb stick and opened it on my clunky dell running office 2007 and windows XP. Faultless.
I then opened the file in Numbers. It came up with a warning that password protection was not supported and was removed. I exported it and re-opened it within excel 2011 and it behaved itself just fine.
Have I missed something with permission issues or is office 2011 just incapable of letting me work in a proper manner?
It's very frustrating and certainly a deal breaker in attempting to use my mac in a grown up and professional manner. or do I just run windows 2007 under boot camp and be done with it?
I really don't want to start running virtualisation layers and the like - I have paid good money for office 2011 and would prefer to use this natively on my mac.
I'm sorry for the frustration, but it's little details like this that just make you appear to come across as a complete idiot to your clients and customers. So i'm back to my using my five year old dell running xp and office 2007 along side a shiny iMac 28" with a bought and paid for office 2011 which is seemingly unwilling to let me edit a spreadsheet which the dell has no trouble with- and I know I could go the parallels or bootcamp route but why should I? if I had wanted to do that I wouldn't have spent the best part of £200 on a full copy of Office 2011 with outlook.
I am having a very worrying issue with Excel 2011 in office Mac 2011.
I have been sent a spreadsheet created in excel 2007 by a windows using colleague.
When I open it on the mac it shows as a read only document.
I altered the permissions under get info to "read and write" however when I try to enter any data in a field I get the following message:
THE CELL OR CHART YOU ARE TRYING TO CHANGE IS PROTECTED AND THEREFORE READ ONLY.
To remove protection, on the tools menu, point to protection, and click unprotect sheet. You may be prompted for a password.
I thought I was going mad, so I asked the sender to unprotect it. He said that it wasn't protected.
I then copied the file to a usb stick and opened it on my clunky dell running office 2007 and windows XP. Faultless.
I then opened the file in Numbers. It came up with a warning that password protection was not supported and was removed. I exported it and re-opened it within excel 2011 and it behaved itself just fine.
Have I missed something with permission issues or is office 2011 just incapable of letting me work in a proper manner?
It's very frustrating and certainly a deal breaker in attempting to use my mac in a grown up and professional manner. or do I just run windows 2007 under boot camp and be done with it?
I really don't want to start running virtualisation layers and the like - I have paid good money for office 2011 and would prefer to use this natively on my mac.
I'm sorry for the frustration, but it's little details like this that just make you appear to come across as a complete idiot to your clients and customers. So i'm back to my using my five year old dell running xp and office 2007 along side a shiny iMac 28" with a bought and paid for office 2011 which is seemingly unwilling to let me edit a spreadsheet which the dell has no trouble with- and I know I could go the parallels or bootcamp route but why should I? if I had wanted to do that I wouldn't have spent the best part of £200 on a full copy of Office 2011 with outlook.
Last edited: