Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2013-12-01
4
Medium Priority
?
800 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

A procedure for exporting installed hotfix details of remote computers using powershell
This article explains how to install and use the NTBackup utility that comes with Windows Server.
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
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…

569 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