?
Solved

excel saving file slow over lan from Win7 client to Win8 as server

Posted on 2013-02-03
9
Medium Priority
?
3,698 Views
Last Modified: 2013-02-18
Hi,

I'm having problems with saving a file from Windows 7 Pro client to a Windows 8 (as the server where the file is actually saved). it takes around 15 to 20 seconds to save a small excel file.

But I have another Windows 7 Ultimate client that has no problems. I don't know what the difference is between the two computers. Same LAN. I tried changing the RJ45 cable but that didn't resolved anything. I think it's some setting.

I looked into the SMB2 protocal which I read that may be the problem but both Win 7 clients didn't have it in the registry (on nor off).

Both Windows 7 clients are using Office Pro 2007. What could be the problem where Win 7 Pro is slow bu the Win 7 Ultimate isn't?

thanks
0
Comment
Question by:Victor Kimura
  • 5
  • 3
8 Comments
 
LVL 44

Assisted Solution

by:Davis McCarn
Davis McCarn earned 2000 total points
ID: 38850910
The odds are that it is the Office File Validation which is causing the problem and not Windows, at all.  I have had it cream the network performance of Excel on several clients networks.  Either sve the following as Disable-Office-Validation.REG or change the key manually.  Reboot and see if it doesn't solve things.

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\12.0\Excel\Security\FileValidation]
"EnableOnLoad"=dword:00000000

Please note that the bolded number needs to match the version of Office (11.0=2003, 12.0=2007, 14.0=2010)
0
 

Author Comment

by:Victor Kimura
ID: 38857791
Hi DavisMcCarn,

I checked on the Windows 7. I think it's a 64bit Office because I couldn't find this path:
[HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\

but I did find these paths:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\Excel\
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\14.0\Common
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\14.0\Outlook

but I didn't see any sub-folder with as "Security\FileValidation" so I'm wondering should I create a sub-folder under one of those above paths and then create the dword for EnableOnLoad?
0
 
LVL 44

Assisted Solution

by:Davis McCarn
Davis McCarn earned 2000 total points
ID: 38859356
Hmmm.....
Many folks complain about it causing issues with Office 2007; but, MS says 2007 and 2010 don't need the patch.  Here is their article with possible fixes: http://support.microsoft.com/kb/2570623
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Victor Kimura
ID: 38862001
No, it didn't work unfortunately.

I did notice a couple of things:

- accessing the folders and files are quick.
- when I drag from the shared excel file (residing on the Windows 8 computer) to the Windows 7 Pro computer it is fast
- when I try and open the shared excel file (residing on the Windows 8 computer) on the Windows 7 Pro computer it is super slow though. I noticed in this case when I try and open this shared excel file (or I think any shared file) then the Windows Explorer tries and rescan the network and this is what seems to make it super slow. Like the green bar is shown in the address bar of Windows Explorer. But this only occurs for shared files and not read only files.
- when I try and open a read-only excel file (residing on the Windows 8 computer) on the Windows 7 Pro computer it's fast

reading lots of posts with people with similar problems and I've tried some of their suggestions but nothing seem to work.

- my other Windows 7 Ultimate has none of these problems so I'm thinking it's some setting somewhere in the Windows 7 Pro but it could be a network card issue. But if the internet is fast on the Windows 7 Pro and the read-only files are fast to read then I don't think it can be a NIC card problem.

any ideas?
0
 
LVL 44

Assisted Solution

by:Davis McCarn
Davis McCarn earned 2000 total points
ID: 38864391
Is your antivirus interfering?
If you copy a file to the Pro system, does it open fast locally?
0
 

Author Comment

by:Victor Kimura
ID: 38865533
I turned off the firewall of my Norton 360. Didn't do anything.

Copying a shared file and non-shared file from the Windows 8 to the Windows 7 Pro is fast. It's only when I'm actually trying to share a file like an excel file or a Quickbooks shared file. This is when things just slow to a crawl and I notice that the Windows 7 Pro rescans the LAN in the Network of Windows Explorer.

Oddly, this does not occur at all on my other Windows 7 Ultimate with the same files from Windows 8. So it's some settings of the Windows 7 Pro or some bug that Microsoft hasn't addressed yet.
0
 

Accepted Solution

by:
Victor Kimura earned 0 total points
ID: 38887940
i think I solved the problem. I had to get the original driver from Intel and download. It's an on-board NIC card for my motherboard. Download the right driver and 64-bit and Windows 7 and the shared (the Quickbooks file anyway thus far tested) is really fast all of a sudden. So I think that's the solution.
0
 

Author Closing Comment

by:Victor Kimura
ID: 38901083
The original nic driver had to be installed from Intel's site.
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to install and use the NTBackup utility that comes with Windows Server.
For anyone that has accidentally used newSID with Server 2008 R2 (like I did) and hasn't been able to get the server running again because you were unlucky (as I was) and had no backups - I was able to get things working by doing a Registry Hive rec…
This Micro Tutorial will teach you how to the overview of Microsoft Security Essentials. This is a free anti-virus software that guards your PC against viruses, spyware, worms, and other malicious software. This will be demonstrated using Windows…
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…
Suggested Courses

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question