Solved

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

Posted on 2013-02-03
9
3,563 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 

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

Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

An article on effective troubleshooting
Resolving an irritating Remote Desktop connection that stops your saved credentials from being used.
This Micro Tutorial will teach you how to change your appearance and customize your Windows 7 interface to your unique preference. This will be demonstrated using Windows 7 operating system.
This Micro Tutorial will give you a basic overview of Windows DVD Burner through its features and interface. This will be demonstrated using Windows 7 operating system.

695 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