Excel files open on a mac are not allowed to be open from a PC

Hi,

We have Windows Server 2003 with shared folders.  The MAC OS X can open the shared excel files fine.  However, if the file is open on the MAC, the PC users cannot open a read-only version.  Apparently this worked ok until we upgraded from Windows 2000 to Windows Server 2003.

Can anybody shed some light?

Many thanks,

JR
techsupport111Asked:
Who is Participating?
 
patrickabConnect With a Mentor Commented:
techsupport111,

Excel does not handle 'Shared' workbooks reliably. They are often corrupted at random and apparently without cause. Clearly there is a cause but it has not yet been isolated and fixed by MS. There is nothing you can do to avoid shared workbooks corrupting. The ONLY thing that can be done is to make them single user.

To help you with the single user file system try adopting this approach instead. It does work rather well so it's worth doing. First make the file(s) single user. Second edit everyone's user profile in Excel - Tools/Options/General/UserName and in there put the person's name and telephone extension number. Then whenever you attempt to open a file that someone else is using, a dialogue box will pop-up telling you who is the current user - and it tells you their telephone extension number! The new user can opt to either call the current user or open the file as read-only.

Patrick
0
All Courses

From novice to tech pro — start learning today.