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...o&userid=29582
View this thread: http://www.excelforum.com/showthread...hreadid=559587

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

ToolsOptions...Calculation

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Newtonboy" wrote
in message ...

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...o&userid=29582
View this thread: http://www.excelforum.com/showthread...hreadid=559587

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

www.decisionmodels.com


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Newtonboy" wrote in message
...
|
| 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...o&userid=29582
| View this thread: http://www.excelforum.com/showthread...hreadid=559587
|