Slow formula's

  • Thread starter Thread starter ianripping
  • Start date Start date
I

ianripping

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?
 
Go to Tools->Options->”Calculation” Tab and you can set it to “Manual”
Piku
 
Wow thats good. Can I make a button that does this that I can assign a
macro 2?
 
Sher kan!

Put this in the Button:

Application.Calculation = xlManual

-Piku
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding button in sheet & assigning it to a macro 3
Slow Macro - Formatting Macro 1
VBA code for pasting links -- modifying RDB code for summary workbook 10
Copying cells and formula from closed workbook to all sheets in open workbook 0
Problem in adding macro to ribbon through Add-in 7
Slow response from excel 1
userform exception error 4 textboxes 7
save file using information from a cell 1

Back
Top