Posted to microsoft.public.excel.worksheet.functions

Siva

Posts: n/a

How to get Excel to work faster

I have a file, that is +- 200MB in size, and has +- 150 worksheets with 700
lines of formulaes in each worksheet.

Problem is that when I update the one sheet where the lookup is, it takes
about 10min to do the calculation.

I am also running a PIV 3Ghz HT with 1gig RAM.

How can I get Excel to perform faster?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Make Excel Work faster	Siva	New Users to Excel	1	April 7th 06 10:33 AM
Excel 97 formula doesn't work in Excel 2003	[email protected]	Excel Discussion (Misc queries)	2	April 4th 06 09:34 PM
POI doesn't work with Excel 97	Sean	Excel Worksheet Functions	0	March 9th 06 07:25 PM
Windows in TaskBar in Excel doesn't Work the Same as in Word	msander508	Excel Discussion (Misc queries)	1	September 7th 05 02:21 AM
Windows in TaskBar in Excel doesn't Work the Same as in Word	Mike	Excel Discussion (Misc queries)	0	September 7th 05 01:14 AM

All times are GMT +1. The time now is 11:44 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us