Excel keeps crashing

[4ycr]

A Client has Excel 2010 in his office. He has 5 computers in a domain with 2 laptops not joined in the domain. All run Windows 7 Pro and have office 2010.

All the domain computers have no problem editing any excel spreadsheets but recently due to the snow he want to let his employees take a laptop home to work on stuff if they get snowed in. When he moved the Excel spreadsheets, Excel hangs and then crashes if you try to save or save as.

If you email the spreadsheet then it works fine and they can save the spreadsheet with no problems. If you create a spreadsheet on that computer then it also works fine. Excel crashes no matter what version of spreadsheet I load, I have tried 2003-2007 and 2010 versions.

I have started Excel up in safe mode but no effect and I have also taken ownership of the spreadsheet again with no effect. The event logs only says that excel stopped communicating with windows and I have left it for 5 minutes to see if it starts working again but with no effect.

Does anyone have anything else I could try?

 

[onetech4all]

Re:

Are they opening the Excel sheet over VPN or is the file local on the computer? If they got some mapped drive they access over VPN, where the Excel files are located, then maybe that's the problem.

 

[4ycr]

I have tried both VPN and local, both with the same result

 

[onetech4all]

When he moved the Excel spreadsheets, Excel hangs and then crashes if you try to save or save as.

- where did he move them?

 

[4ycr]

He is moving from his server or domain computer to his laptop

 

[wimwauters]

I think this is one for the dedicated Microsoft newsgroups/forums. Maybe an embedded link somewhere?

Do their links to the Z/home and Public drive work properly when connected remotely over VPN? This is not an overlapping subnet problem, is it?

And teh killer question: is this a good opportunity to let them eat LibreOffice..