We've password protected an Excel 2007 document on the network. A PC user is working on it. When a Mac user, tries to open it, they're told that the document is being used and whether they want to open it as read-only. You select 'OK' and are told that the Excel file is either damaged or can't be found.
If another PC users tries to open the file instead of the Mac user, then they are prompted by a password and can view it as read-only, just how it should be.
This happens with even new Excel files I've created. It looks as though it's something to do with the Mac Office 2008 or something. Anybody know what's going on?