Thread
:
Excel toooo slow
View Single Post
#
2
Posted to microsoft.public.excel.misc
Nick Hodge
external usenet poster
Posts: 1,173
Excel toooo slow
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
Reply With Quote
Nick Hodge
View Public Profile
Find all posts by Nick Hodge