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

Posted on 2013-02-03
Medium Priority
Last Modified: 2013-02-18

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?

Question by:Victor Kimura
  • 5
  • 3
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


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

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:

but I did find these paths:

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?
LVL 44

Assisted Solution

by:Davis McCarn
Davis McCarn earned 2000 total points
ID: 38859356
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
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.


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?
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?

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.

Accepted Solution

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.

Author Closing Comment

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

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

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…
After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…
This Micro Tutorial will give you a basic overview of Windows Live Photo Gallery and show you various editing filters and touches to photos you can apply. This will be demonstrated using Windows Live Photo Gallery on Windows 7 operating system.

600 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