Solved

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

Posted on 2013-12-01
4
739 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 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

Are your AD admin tools letting you down?

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

Suggested Solutions

I have been working as System Administrators since 2003. I recently started working as a FreeLancer and was amazed to find out that very few people are taking full advantage of their Windows Server Machines. Microsoft Windows Server comes with so…
OfficeMate Freezes on login or does not load after login credentials are input.
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…

914 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now