Posted to microsoft.public.excel.programming

Siva[_2_]

external usenet poster

Posts: 1

Make Excel 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
How can I make reports faster in excel using ADO	ST	Excel Discussion (Misc queries)	1	July 29th 06 02:03 AM
How to get Excel to work faster	Siva	Excel Worksheet Functions	4	April 7th 06 01:48 PM
Make Excel Work faster	Siva	New Users to Excel	1	April 7th 06 10:33 AM
How Can I make excel go faster	Jason Zischke	Excel Programming	8	March 23rd 05 03:55 PM
make my vba/excel program faster	pikus	Excel Programming	0	May 18th 04 04:44 PM

All times are GMT +1. The time now is 03:06 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us