LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Why does my spreadsheet calc slower when many other windows are op

Recently upgraded from Excel 2002 to 2003, from Windows 2000 to XP, and from a
dual P4 to dual Xeon 5100, i.e. four cores. This is a big, fast machine.
But one sheet is running slower!

This particular sheet calcs in about 1 second with not much else running,
but
4-8 seconds when all windows (about 40 total) are open.
It is not short of CPU - task manager shows about 25% CPU usage, and in this
state Excel itself never goes above 10% CPU usage.
It is not short of memory - this machine has 4GB of RAM and around 2GB used.

I have looked at the network traffic and it doesn't seem to be doing file
I/O. The sheet does receive a lot of data from Reuters (via RtGet) but that
shouldn't change just because I opened some more windows.

Any ideas what it could be, or what to try?

Bryan

 
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
Syncing spreadsheet windows gjcase Excel Discussion (Misc queries) 1 March 16th 06 12:18 AM
auto calc on, but have to edit (f2) cells to force re-calc..help! Curt Excel Worksheet Functions 3 February 13th 06 06:05 PM
need to convert e-mail info from excel spreadsheet ot windows XP merlinus Excel Discussion (Misc queries) 1 December 28th 05 03:04 PM
windows explorer will not open an excel spreadsheet. hal Excel Discussion (Misc queries) 2 June 24th 05 02:07 AM
Windows cant open excel spreadsheet.xls? suzy Excel Worksheet Functions 1 June 18th 05 09:13 PM


All times are GMT +1. The time now is 10:50 PM.

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"