Solved

Excel files open very slow on network

Posted on 2011-09-02
3
862 Views
Last Modified: 2012-05-12
Hi experts,

I'm having a farley rare phenomenon. The clients used to work as workgroup members on the sbs domain server.
Last week I went to this installation and told them it would be better to set the computers in the domain. After doing this they are complaingin that openeing xls files take a long time.
So I went over there and opend an xls file around 2mb this took 5min 30seconds

I open a word file 45mb this is done in 13seconds (which I think is normal)
I took my notebook (brand new core i7) placed it in the domain.and open the xls file. It opens at regular speeds.
When I go to a xp client and put it out of the domain and back in workgroup. the same xls files opens at normal speeds 7 to 15 seconds.
Put the xp client back in domain Bam; 5min to open the xls file.
strange strange strange.

Anyone any answers on this one?
Thanks for assistance.
 
0
Comment
Question by:osa2
[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
3 Comments
 
LVL 40

Assisted Solution

by:als315
als315 earned 250 total points
ID: 36473243
What excel version is used?
If Excel 2003 - check Office file validation update:
http://support.microsoft.com/kb/2570623/en-us
0
 
LVL 3

Accepted Solution

by:
WiReDWolf earned 250 total points
ID: 36479624
If any version of Excel - remove the Office File Validation update.  I had this problem on several networks and it was resolved instantly by removing this update.
0
 
LVL 1

Author Closing Comment

by:osa2
ID: 36483172
I have uninstalled the whole Office Validation add in plug in via control panel -> software. Now everything is fast again.

Thanks for the solution.
0

Featured Post

Free NetCrunch network monitor licenses!

Only on Experts-Exchange: Sign-up for a free-trial and we'll send you your permanent license!

Here is what you get: 30 Nodes | Unlimited Sensors | No Time Restrictions | Absolutely FREE!

Act now. This offer ends July 14, 2017.

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…

688 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