Problems gaining write permission on excel sheet sent that was created on window

Question

Problems gaining write permission on excel sheet sent that was created on windows 7 Hi and I'm really hoping someone can help. I use at work, my Macbook Pro using Office 2011 for Mac. Everyone else in the office uses PC and Office 2010. On our business server I have acccess to various excel sheets that I need to edit etc. The boss has protected the sheets but allowed write prrivileges for everyone on completing a password. These all work on all of the PC's. When I use my Mac and Office for Mac and I try and edit anything, it comes up that I need to go to tools and unprotect the workbook/worksheet. My boss obviously doesn't want me to have this facility as I could edit the formula's etc and I only need to copy and paste basic information. When the others using PC's try to edit anything a small box appears and says "Unlock Range" a cell that you are trying to edit is password protected. This doesn't happen on my maac using office for mac and so I cannot edit anything? Any ideas anyone? Many thanks

Explanation / Answer

The Windows version of Excel has more sophisticated Protection featuress than those included in the Mac versions, Range Protection beinng one of them. Mac Excel seees the sheet as simply being eitherProtected or Unprotected..

Unfortunately, there is no way around it except what you are currently doing... other than using Win Excel on your Mac via a VM/Boot Camp/Crosasover or doing without Range Protection altogether. [I'm sure the latter is totally unacceptable to your 'boss'- :-)]

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.