Excel 2003 opening files on network

The network is laid out with an XP Pro computer as the server hosting files, then 3 XP computers connecting to it for filesharing, all on it's own router. One computer can open .xls files no problem, and she runs Office XP. The other two computers run Office 2003, and cannot open any shared files by double-clicking them, or by selecting File->Open in Excel. If the file gets copied to the local computer, it opens instantly. I have tried disabling the AV on all computers, disabling the Windows firewall, and doublechecking permissions on the server. I have also tried disabling DDE, but that doesn't help at all, just like Tools->Options->unticking Ignore other applications. Any ideas? This apparently started a couple days ago

Canadian Luke

Posted 2011-06-30T19:18:30.877

Reputation: 22 162

Answers

Since you mention it starting a few days ago... Is there a chance that the Office File Validation update occurred which will give you problems with files on a network share mentioned here and acknowledged by microsoft as a known issue here

datatoo

Posted 2011-06-30T19:18:30.877

Reputation: 3 162

That looks a lot like what is happening... I'm going to see if that fixes it for my customer, thank you very much – Canadian Luke – 2011-06-30T19:44:59.590

Unfortunately, it didn't work on the first computer, but it worked on the second. What other information can I get for more help on this issue? – Canadian Luke – 2011-07-07T23:24:23.780

what have you tried on the other computer you are mentioning? Did you try an uninstall of that update? Did you look into the registry change mentioned in the MS article? Even if it is installed you can disable the file validation. – datatoo – 2011-07-07T23:29:45.203

The last section of my question. It was the original computer to have the issue. I asked them to uninstall and reboot, but it's still causing grief unless they open the file from their own hard drive isntead of the network – Canadian Luke – 2011-07-08T16:13:21.830

does it eventually open? have you tried watching the processes that are running in taskmgr to see what seems to be running and consuming resources when you open the file? It may be another cause, but uninstalling the file validation update worked for me on numerous machines, and will continue to try re-installing unless you set it to be ignored – datatoo – 2011-07-08T16:30:33.363

It doesn't open at all. I sat there waiting for 20 minutes to try, but nothing. TaskMgr just shows the regular processes, and EXCEL.exe doesn't take more than 10MB of RAM at a time while trying to load – Canadian Luke – 2011-07-12T17:33:30.480

I can confirm this. We solved this problem today too. It happens when the Office File Validation is installed on Office 2003 and Office 2007 (not applicable for 2010 or others), AND you are accessing files over a network.

We tested it on a client network, and then I introduced the patch to my network, and it behaved the same.

It happens even even when opening very small files. I tested on a 21K file.

KCotreau

Posted 2011-06-30T19:18:30.877

Reputation: 24 985

wonder how many hours have been wasted figuring out how to remove this protective measure. – datatoo – 2011-06-30T23:17:05.500