?
Solved

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

Posted on 2013-02-03
9
Medium Priority
?
3,633 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 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 43

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
Plug and play, no additional software required!

The ATEN UE3310 USB3.1 Gen1 Extender Cable allows users to extend the distance between the computer and USB devices up to 10 m (33 ft). The UE3310 is a high-quality, cost-effective solution for professional environments such as hospitals, factories and business facilities.

 

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

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.

Question has a verified solution.

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

Assume you have an outside contractor who comes in seasonally or once a week to do some work in your office, but you only want to give him access to the programs and files he needs and keep all other documents and programs private. Can you do this o…
Resolving an irritating Remote Desktop connection that stops your saved credentials from being used.
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum editing capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.
Suggested Courses
Course of the Month8 days, 7 hours left to enroll

764 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