I have a spreadsheet that has two worksheets:
Worksheet 1 has absolutely no formulas associated to it and is all data entry.
Worksheet 2 is a summary spreadsheet that has alot of complex array formulas that pulls a bunch of data from Worksheet 1.
The problem i'm facing is that now when entering data in Worksheet 1 it takes nearly a second to recalculate all the formulas that are stored on Worksheet 2. Is there a way to disable the formulas from recalculating each time new data is entered in Worksheet 1 and only have the formulas run when i press a macro button?
Hopefully there is an easy solution to this. Thank you
Bookmarks