File wont stop Calculating

Bowlnhokie

Board Regular
Joined
Apr 23, 2002
Messages
196
I have inherited a file at work that no matter where you enter data or click your cursor, the file starts calculating. I know I can turn calculations to off in the options menu but is there anyway to research what could possible be causing this problem. The file does have a good amount of Vlookups with some indirect formulas.

I can understand the file recalcing if I touch the data the Vlookup is referring to but that isnt the issue. I can can insert a blank sheet in the book, type the number 1 and the file start to calc.

If anyone has any suggestions, they would be much appreciated
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Try running this macro and see if this behaviour stops

Code:
Sub StopEvents()
Application.EnableEvents = False
End Sub
 

ageren

Board Regular
Joined
Jul 30, 2007
Messages
60
try this;

Private Sub Worksheet_Change(ByVal Target As Range)
Application.Calculation = xlCalculationManual
End Sub


do not forget to calculate your worksheet manually (press F9) when your entities are over...
 

Forum statistics

Threads
1,181,649
Messages
5,931,214
Members
436,784
Latest member
amuljono

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top