troubleshooting Question

Excel Opens Slowly

Avatar of TechGuy_007
TechGuy_007Flag for United States of America asked on
Microsoft ExcelNetworkingWindows Server 2003
8 Comments1 Solution124 ViewsLast Modified:
We open very large excel documents over the network that take between 7 - 10 minutes to calculate formulas or save the document on average. I wouldnt think that updating the formulas would have anything to due with the network since its working in a temp file; however, I could be wrong. When the document opens with automatic calculation the document takes a while to load, if it has manual calculation opens right away. The desktop we're opening them on runs Windows 7 Professional with 8GB of memory with an Intel Core 2 duo E8500 3.17 GHz processor. The network is a 1Gb connection at the serve and a 100Mbps connection on the client so I'm assuming there is a small switch somewhere between. Our first solution was to run the doucments straight off the server; however, it seems to run slower. The server only has 2GB of memory and has a Intel Xeon E5310 1.60 GHz processor. The spreadsheets are about 20MB in size. We need to get these sheets running faster as they run our business. Any ideas would be greatly appreciated.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros