Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

Stop calculation

Does anyone know of a way to stop excel from calculating when it is in the middle of a calculation? I have the file set to manual calculation, which is exactly what I want and I hit F9 to have it calculate. There are hundreds or thousands of formulas in this file so as you can imagine it takes a few minutes sometimes to calculate. Is there a way if I hit F9 to stop Excel in the middle of a calculation because I remembered that I didn't correct a number that needed to be corrected for the calculation? Not sure if its possible, but I thought I'd ask.

Thanks.


Post your answer or comment

comments powered by Disqus
Is there a way to have a cell that stops calculating once the cell result is calculated the first time and then keeps that first result.
Basically, once the result is more than 0, stop calculating.

I have an existing spreadsheet with different formulas in it. Just recently
I noticed that the forumlas stopped calculating. It's odd since I can cut a
formula out of a cell and paste it back into the same cell and it will work
again. What is causing this? It's annoying to have to spend 30 mins
updating formulas this way when I have only 2 mintues worth of data to imput.

Is there a way to stop calculation once it has started? I tend to do a lot
of huge spreadsheets. Sometimes I insert a column without remembering that I
have formula's that will need to re-calculate. I'd like to be able to stop
the calculation at least until I've done everything I need to do. But
sometimes escape does not stop the calculation and I have to wait until it is
done to move on.

A spreadsheet that I wrote a few months back has (for some reason) stopped
calculating totals. It's a declining balance spreadsheet used for my business
purchases. There are simple formulas to calculate column totals and then
others to do simple subtraction for the declining balance. Did I turn
something off by mistake that made this sheet do this? It worked fine when I
tested it and for about 6 months afterward and then suddenly stopped. Now, if
I go back to a previous entry and delete it and/or change it, nothing happens
to the totals that have already been calculated. I'm stumped.

Please help me with this formula, it's a tax one and soyuld be quite easy for you lot.
I have a monthly income of say £4000 every month and the tax is split up @ 10% - 22% - 40% ( £0 - £2000 ) ( £2001 - £29000 ) & (£29001 + ) First cel at 10% would tax the income to £2000 and stop calculating and go on to cel two and stop calculating at £29000 and so on
Please help

A spreadsheet worked correctly for months but suddenly stopped calculating. The function is =SUM(C2:O2) and is copied down for all the rows.

Cells are formatted as accounting. I deleted and recreated.

Any ideas?

thanks!

I figured out how to calculate the total based on the current date
=(DAY(TODAY())*2), however I want this to stop calculating at the end of the month.

Is there any way to stop calculation in an EXCEL workbook once it starts? I
didn't intend to have it calculate and it completely ties up EXCEL while
calculating.

Thanks,
Barb Reinhardt

if cell A contains a formula =today()-B1 gives the resut of 1 while on cell C if the status is complete the formula in cell A stops calculating the number of days.

Pretty new to VBA, and looking for a little help/suggestions.

I have the following code, which seems to work, but when I run it, the status bar at the bottom of my screen says "calculating" for a long time.

I have a set of data, and I want to delete any rows that do not read "WIND RIVER" in the third column, but leave the first row that has my column headers.

x = 2

Do While Cells(x, 1).Value ""
If (Cells(x, 3).Value "WIND RIVER") Then Cells(x, 3).EntireRow.Delete

Loop
x = x + 1

Am I on the right track? Any suggestions or help to make it stop running? Should I be doing it differently altogether?

Thanks!

Hello,

I have a quote feed coming into excel and I have a formula that says:

when such a price is acheived multiply A2*ThisPrice...once this action happens I want it to stop calculating...right now it is constantly calculating the price...Is there a way to disable the formula in the cell once this certain price is acheived?

I am doing this in excel with the formula bar...not in VBA

I hope I explained this correctly!

thanks,

Lino

Hello All,

I have a couple of somewhat related questions...
I have a worksheet with a Table which I have successfully mapped with an XML schema, so I can import data from .xml files into the table easily. This table is named TableA.
In a separate worksheet I have a completely separate table, named TableB, where I have several "calculated columns" which contain formulas with references to columns in TableA.

For example, Column 1 in Table B is a calculated column with the formula:
=IF(TableA[Column1]="someValue", "customValue", TableA[Column1])

Basically, if TableA has a certain value, I want to display something else in TableB, otherwise, just display the same value that is in Table A.

Now, this is a very simplified formula as an example, in reality TableB is full of fairly complicated formulas in each of the columns, usually referencing several columns in TableA. Everything WAS working fine, I would change a formula in 1 cell of a calculated column in TableB, and the rest of the column would update.

But, as I made changes to TableB, like changing the order of the columns, changing the formulas, some of the columns in TableB stopped calculating if I tried to update the formula.

For example, I might have made a change that caused "#REF" to appear in TableB, but when I went to correct the formula, the column would no longer update. In fact, the cell I edited the formula in would just display the literal formula like this:
=IF(TableA[Column1]="someValue", "customValue", TableA[Column1])

I've tried deleting the column from the table and starting from scratch by inserting a new column, but the new column STILL doesn't calculate the entire column, and most times will only display the literal formula like above.

However, if I create an entirely new table and insert the formula, it will work perfectly.
Furthermore, and this is the really weird part, if I right-click in the last column of TableB and insert a new column to the right, the new column will work perfectly as well. But, if I try to insert new columns into the middle of TableB (where the broken columns are), the new columns won't calculate.

Anyone have any clue as to why this is happening, or how to fix it?

I've spent some time putting a personal budget template together and all is fine until the worksheet stops calculating. What's going on? I know I could start another worksheet but it's time consuming, so please help.

Example: if I do the formula =sum(A1:A4) in cell A5 and type in numbers in cells A1 thru A4, nothing shows in cell A5 as the total. Same thing goes with all the cells. Help please. Thanks in advance.

MB

I have a large file which I open frequently, and it drives me crazy if I
forget to turn off automatic calculation, as it can take 10 minutes to
calculate - I usually crash out of Excel to stop it.

I added code to switch calculation to manual as the workbook opens, but
unfortunately, that workbook_open procedure seems to fire after the workbook
has been through the calculation process. Is there any code that runs
immediately when a file is opened?

Thanks in advance
Daniel

I inadvertently copied a whole sheet instead of a small range and paste specil - paste links on another sheet. It is taking excel forever to do teh paste and calculate all of the cells. I tried to hit escape to stop excel from calculating all of the cells to no avail. Is there a "break" keystroke to stop excel from completing a calculation?

Thanks

Hi,
I am trying to put together a plant register that calculates the costs from on hire and off hire dates. I am using IF function, which does calculate the cost between the two dates and stops accumulating in the to date total cost, however I also have a weekly cost which I want to return a result of 0 if there is an off hire result and this exceeds Todays date so it does not accumulate in the weekly total. I cant delete this line as then the to date total cost will be in correct.

As I send out the plant register every Friday I want this cost included up to the friday of the week off hired. Once this has been exceeded then I want this to return a 0 result to it does not contribute to the weekly cost.

Therefor I am looking for this formulae;-
If start date is more than todays date then return 0. If off hire date is entered then include cost until the Friday of the off hire week. Once Friday of that week has passed then put 0 to stop counting.

I have a formula which automatically calculates the next Friday, but this changes as its based on todays date, where as I want it fixed from the off hire date =TODAY()-CHOOSE(WEEKDAY(TODAY()),2,3,4,5,6,7,1)

Any help would be great :-)

Thanks

I need a script that once a condition is met in 2 cells that the formulas will stop calculating on another sheet and change the values to text.

On the attached sheet, once the patient ID on the sheets Form and Table1 match, and the user has entered Yes in the Completed box in cell G6 on the Form sheet, I want the formulas in columns L through R on the Table1 sheet to stop calculating and change the values to text.

Is this possible?

Thanks in advance.

I'm using Excel 2000 as part of Office 2000 Professional.
I have several sheets that I use as a financial plan
template. In one sheet I run a calculation to determine
an account balance after a defined number of years.
Since this is a template and used for each client, the
data is always different, including the age of the client
or year the calculation begins.
My problem is, I need to be able to have the calculation
start at a certain age and stop at a certain age, without
me doing it manually. I use this calculation to create a
graph of the data.
Is there a way to just enter the variables like account
balance, contributions, rate of return and then tell it
to run from say age 45 to age 59 and not have to change
things for the next case?

Any help you can give is always welcome. Thanks, Jim

I need help to calculate age but, the calculation needs to stop at 09/01/10 date. Can someone help?

I tried YEAR(B4)-YEAR(C4), I also tried (YEAR (B4)-YEAR(C4))-1, but their DOB is still calculating their age after 09/01/10. I need it to stop calculating at 09/01/10 so their rate charge does not go up.

I really appreciate your time.

I have figures and text that I have been trying to pick up using concatenate but when I get so far the workbook won't calculate. Can anyone think of a way around it?

I have numbers plus text like this - 24A

They start in R8 then U8 then X8 then AA8 then AD8

In AI8 is a count of these numbers between R8 and AD8 (Maximum of 5)

My initial thought was to concatenate(r8"/",u8,"/",x8,"/"aa8,"/",ad8)

Which works but if you only have one number in R8 it looks like this -

24A///.

I tried embedded If statements and concatenate and got the calculate problem.

A two number example of what I would like is 24A/26B.

Any ideas anyone?

I have a report whose calculation time I've reduced greatly by turning off automatic calculation and including in the worksheet code directions to only calculate the impacted range.

BUT, it still takes a lot of time to calculate on close, when I turn automatic calculation back on. I'm afraid my users will think their machines have crashed. Does anyone know of a way so that on close, the workbook does not calculate, even though Calculation is turned back on to automatic?

Many thanks in advance for any help.

This is what I have in the workbook code:


	VB:
	
 Workbook_Activate() 
    With Application 
        .Calculation = xlManual 
        .MaxChange = 0.001 
        .CalculateBeforeSave = False 
    End With 
End Sub 
 
Private Sub Workbook_Deactivate() 
    With Application 
        .Calculation = xlAutomatic 
        .MaxChange = 0.001 
    End With 
End Sub 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines


Well...my code is up and running, only I know it is calculating a large amount of cells several times. I would like to be able to tell it not to calculate until the last time through the loop (by just checking if it's on the last execution).

This way it needn't calculate itself 1000+ times over when only the last one counts.

Oh, and application.enableEvents = false doesn't work. I even tried [sheet].application.enableEvents = false to make sure it didn't have to be set more locally.

Fist person who can give me the correct answer wins a prize!

***Disclaimer: prize not redeemable for cash value, offer void where not valid (which is, of course, everywhere). ***

I've got some formulas that return a #VALUE! error if a data input is non-numeric. I use data validation to ensure that only allowed values can be entered, so if someone enters "q", for example, it throws a warning. (Error Alert style is set to "Stop.")

However, this does not appear to stop calculations from being attempted with the bad data, and various fields show #VALUE! errors. To boot, these errors don't go away when I fix the bad data back to an allowed value.

First, is there any way to prevent calculations from being attempted with invalid data?

Second, is there any way to reset the #VALUE! errors after they've been triggered?

Thanks!

Happy New Year.

Here is a problem that's rapidly becoming urgent: I have an integrated financial model that won't finish calculating. Has anyone run into this or know a way to beat it? Here are the symptoms:

Like any such model, mine is circular (cash flow -> balance sheet -> income statement -> cash flow). I have set Calculation options to Manual with Iteration (100 iterations). The model is only ~250 lines, nothing that should cause problems. When I attempt to calculate the sheet, I can see the later years flipping rapidly back and forth between two sets of "answers." When Excel gives up and stops calculating, it simply stops in mid-calculation, so that cells don't display the correct values (cell D100 might display $65 and cell D15 which is linked to D100 will display #DIV/0!).

Can anyone help sort this out, I would be very grateful.

Thanks,
Alriemer


No luck finding an answer? You could always try Google.