Solved

Excel files open very slow on network

Posted on 2011-09-02
3
852 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
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 Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

733 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