View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
harpscardiff
 
Posts: n/a
Default reducing Calulating time


Hi,

I'm looking for way to reduce my calculation time. Any good tips?

I have a few accounting spreadsheets, for my business. The only
problem is they take a long time to calulate. Can take up to 15, 20
mins.

If I converted all my formulas to UDF will this reduce the calulation
time?

I have alot of VLOOKUPs, any other way to do this?


--
harpscardiff
------------------------------------------------------------------------
harpscardiff's Profile: http://www.excelforum.com/member.php...o&userid=25960
View this thread: http://www.excelforum.com/showthread...hreadid=522108