Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
R L
 
Posts: n/a
Default File takes 40 minutes to load (auto-calculation)

I have a 7 MB Excel file that takes about 40 minutes to open up. If I
turn off auto-calculation, the file opens almost instantly. I have a
desktop with Intel P4-2.8GHz, 512MB, Win2K, Office XP with SP3. The
thing is, my coworkers who have older/slower machines can open the file
almost instantly whether auto-calculation is on or off. There is one
other person in the office who is experiencing the same problem.
Any thoughts?

  #2   Report Post  
Naz
 
Posts: n/a
Default

2 thoughs a

1) Assuming your PC is running over a network is your PC comparably slower
to the co-workers who load the file immediately? If so, if the file is linked
to many other files a slow connection could be the cause of the problem.

2) Are you all using the same version of Excel, if you are using Excel XP
and the file you are opening is an earlier version, or any files that the
main file links to are earlier versions. This could cause a problem. Test
this by opeing the file with auto-calc on but not updating the file if
promted.

Hope that helps

____________________
Naz
London


"R L" wrote:

I have a 7 MB Excel file that takes about 40 minutes to open up. If I
turn off auto-calculation, the file opens almost instantly. I have a
desktop with Intel P4-2.8GHz, 512MB, Win2K, Office XP with SP3. The
thing is, my coworkers who have older/slower machines can open the file
almost instantly whether auto-calculation is on or off. There is one
other person in the office who is experiencing the same problem.
Any thoughts?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need button or menu to load a file Spiff Excel Discussion (Misc queries) 4 January 20th 05 10:05 PM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 05:37 AM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM
Auto Calculation Automatically Turns Off???? Jeff K. Excel Discussion (Misc queries) 2 December 15th 04 01:39 AM
*.csv file wont load correctly Nightwing Excel Discussion (Misc queries) 3 December 1st 04 03:48 PM


All times are GMT +1. The time now is 04:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"