Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2013-12-01
4
Medium Priority
?
794 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
  • 2
  • 2
4 Comments
 
LVL 44

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 44

Accepted Solution

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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
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…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…

971 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