| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Slow formula's
Go to Tools-Options-”Calculation” Tab and you can set it to “Manual”
Piku -- Message posted from http://www.ExcelForum.com |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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/ |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Slow formula's
Sher kan!
Put this in the Button: Application.Calculation = xlManual -Piku -- Message posted from http://www.ExcelForum.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula's | Excel Discussion (Misc queries) | |||
| Slow Excel Navigation with Up / Down Arrow and slow scrolling | Excel Discussion (Misc queries) | |||
| formula's | Excel Discussion (Misc queries) | |||
| Formula's | Excel Worksheet Functions | |||
| Need Help w/Formula's | Excel Worksheet Functions | |||
![ianripping[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
