I use at work, my Macbook Pro using Office 2011 for Mac. Everyone else in the of

Question

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 access to various excel sheets that I need to edit etc.

The boss has protected the sheets but allowed write privileges 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 mac using office for mac and so I cannot edit anything?

Any ideas anyone???

Many thankss

Explanation / Answer

The Windows version of Excel has more sophisticated Protection features than those included in the Mac versions, Range Protection being one of them. Mac Excel sees the sheet as simply being either Protected or Unprotected.

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

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

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