Solved

Large Excel file on 2008 Server R2 very slow to open from XP computers

Posted on 2013-12-01
4
777 Views
Last Modified: 2013-12-14
Hello Experts,

We have had to replace an old Linux server with a newer machine running 2008 Server R2.

One large Excel file is very slow to open from the three computers running XP but opens fine from a computer running Windows 8.

This did not occur with the old Linux server and makes me think the sharing protocols have been optimised for the newer operating systems.  

Everyone group has Full Control. Computers have not been joined to the domain as yet and we hope to avoid that if possible to save creating new profiles.

Is there anything we can change on the server to improve the speed for the XP machines ?

thanks
0
Comment
Question by:Brett4567
[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
  • 2
  • 2
4 Comments
 
LVL 43

Expert Comment

by:Davis McCarn
ID: 39691266
One of the stock Windoze updates was the Office File Validation Tool which is known to cause major grief opening Excel files.  You don't say what version of Office is running; but, here is a registry file to merge for Officce 2003 to disable it:

Windows Registry Editor Version 5.00

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

Author Comment

by:Brett4567
ID: 39691368
They are using Excel 2000.

Will this work for 2000 ?

thanks
0
 
LVL 43

Accepted Solution

by:
Davis McCarn earned 500 total points
ID: 39692249
Change the 11.0 to 9.0 so it points to the right version

Windows Registry Editor Version 5.00

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

Author Comment

by:Brett4567
ID: 39693372
Thanks will try today and report back.

That did help thank you
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

I was supporting a handful of Windows 2008 (non-R2) 2 node clusters with shared quorum disks. Some had SQL 2008 installed and some were just a vendor application that we supported. For the purposes of this article it doesn’t really matter which so w…
You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
Suggested Courses

634 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