Stopping recalculation (minor emergency)

MagiCat

Board Regular
Joined
May 24, 2006
Messages
121
I put a formula into approximately 240,000 cells that is taking a bit of time to complete (I put the FALSE parameter into VLOOKUP) Is there a quick way to cancel a currently working Recalculation?
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

potsyboy

New Member
Joined
Oct 26, 2006
Messages
5
go to tools then options then calculation then select manual. Hit f9 when you want to recalculate
 

MagiCat

Board Regular
Joined
May 24, 2006
Messages
121
Actually, I'm looking how to stop one while it's going. I have one going right now that I need to stop (killing Excel would lose me about a half hour to 45 minutes of work so I'd rather stop the recalc)
 

Watch MrExcel Video

Forum statistics

Threads
1,113,811
Messages
5,544,437
Members
410,610
Latest member
renatha prado
Top