Problem Sharing a Workbook between Mac and PC

[bosstone75]

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Hello and thanks in advance for your help.

I'm trying to set up an Excel spreadsheet that is going to be shared between a Mac and a PC over a Microsoft Server. This workbook is also password protected for read rights.

In doing some testing, I found that if I open the document on both a Mac and a PC and I make a change to the SAME row, SAME cell, and if I save using the PC first, when I go to save it using the Mac, I get a message explaining that a change was already made to that cell and it asks me which change to consider the final change. This is how it is suppose to work.

HOWEVER, If I save the file on the MAC first, I never get any message when I save using the PC. It simply overwrites whatever the Mac saved. Then If I try and save the Mac version again, I get a message saying that the File Was Not Saved.

I am using Excel 2008 on my Intel Mac 10.5.4
I am using Excel 2007 on my PC Windows XP

I saved the file as an xls since that's the format that works best with a Mac.

Can anyone help?
Thanks!

 

[John McGhie]

I doubt if anyone can help: I suspect the problem is that the Mac does not
set the lock files correctly.

That said, I would be more hopeful of it working in .xlsx than in .xls.

Various things don't work properly or are not supported in the old formats.

Sorry

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Hello
and thanks in advance for your help.

I'm trying to set up an Excel spreadsheet that is going to be shared between a
Mac and a PC over a Microsoft Server. This workbook is also password
protected for read rights.

In doing some testing, I found that if I open the document on both a Mac and a
PC and I make a change to the SAME row, SAME cell, and if I save using the PC
first, when I go to save it using the Mac, I get a message explaining that a
change was already made to that cell and it asks me which change to consider
the final change. This is how it is suppose to work.

HOWEVER, If I save the file on the MAC first, I never get any message when I
save using the PC. It simply overwrites whatever the Mac saved. Then If I
try and save the Mac version again, I get a message saying that the File Was
Not Saved.

I am using Excel 2008 on my Intel Mac 10.5.4
I am using Excel 2007 on my PC Windows XP

I saved the file as an xls since that's the format that works best with a Mac.

Can anyone help?
Thanks!

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:[email protected]

 

[bosstone75]

Thanks,

When I get to work on Monday, I'll try switching it to the xlsx format and seeing if that improves functioning.