Solved

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

Posted on 2013-02-03
9
3,532 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
9 Comments
 
LVL 43

Assisted Solution

by:Davis McCarn
Davis McCarn earned 500 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 43

Assisted Solution

by:Davis McCarn
Davis McCarn earned 500 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
Free Webinar: AWS Backup & DR

Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.

 

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 43

Assisted Solution

by:Davis McCarn
Davis McCarn earned 500 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

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!

Question has a verified solution.

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

Resolve DNS query failed errors for Exchange
When you try to extract and to view the contents of a Microsoft Update Standalone Package (MSU) for Windows Vista, you cannot extract the files from the MSU. Here we are going to explain how to extract those hotfix details without using any third pa…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
This Micro Tutorial will teach you the basics of configuring your computer to improve its speed. It will also teach you how to disable programs that are running in the background simultaneously. This will be demonstrated using Windows 7 operating…

749 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