Excel toooo slow

[Newtonboy]

Hi All,

I am using an excel sheet which is loaded with vlookup's and links to
all over the place inside the excel sheet. And it has data for abot
25,000 items.

Problem is that excel takes ages to open up, close, perform any
calculations and makes the system very slow. Any ideas to speed it up
a bit ?

I am running a Acer Aspire 5030 notebook with 512 MB RAM.

Cheers,
Newtonboy

 

[Nick Hodge]

Turn Calculation to manual. It won't help opening or closing, but you then
only need to calculate (F9) when you want, not each time you change any
dependent cell

Tools>Options...>Calculation

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[Niek Otten]

For many tips to improve speed, certainly with VLOOKUPs, see

www.decisionmodels.com


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
| Hi All,
|
| I am using an excel sheet which is loaded with vlookup's and links to
| all over the place inside the excel sheet. And it has data for abot
| 25,000 items.
|
| Problem is that excel takes ages to open up, close, perform any
| calculations and makes the system very slow. Any ideas to speed it up
| a bit ?
|
| I am running a Acer Aspire 5030 notebook with 512 MB RAM.
|
| Cheers,
| Newtonboy
|
|
| --
| Newtonboy
| ------------------------------------------------------------------------
| Newtonboy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29582
| View this thread: http://www.excelforum.com/showthread.php?threadid=559587
|