Slow formula's
 

I have a spreadsheet with loads of numbers.

This then all gets sorted into stats on another sheet within the
workbook.

Because they are linked, the worksheet runs quite slowly, even with
loads of RAM. is there anyway of speeding this up by enabling the links
by a Macro when you want so it isnt constantly making calcuations?


---
Message posted from http://www.ExcelForum.com/

Slow formula's
 

Go to Tools-Options-”Calculation” Tab and you can set it to “Manual”
Piku

--
Message posted from http://www.ExcelForum.com

Slow formula's
 

Wow thats good. Can I make a button that does this that I can assign a
macro 2?


---
Message posted from http://www.ExcelForum.com/

Slow formula's
 

Sher kan!

Put this in the Button:

Application.Calculation = xlManual

-Piku

--
Message posted from http://www.ExcelForum.com