If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Calculations of cells
Hi,
I have problem with cell calculations, the formula don't been calculated. The Tool- Options- Calculations is set to Automatic, but it does not calculates and nothing happens if I press F9. But if I double-Click the Cell (edit Formula) and then press enter key its calculates. Can I do anything so it's calculates automatic, without this procedure. //Lasse |
#2
|
|||
|
|||
Calculations of cells
Sounds like the cells are formatted as text.
Select them all, and DataText To Columns, with fixed width but no breaks. That should sort it. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Lasse" wrote in message ... Hi, I have problem with cell calculations, the formula don't been calculated. The Tool- Options- Calculations is set to Automatic, but it does not calculates and nothing happens if I press F9. But if I double-Click the Cell (edit Formula) and then press enter key its calculates. Can I do anything so it's calculates automatic, without this procedure. //Lasse |
#3
|
|||
|
|||
Calculations of cells
"Bob Phillips" wrote: Sounds like the cells are formatted as text. Select them all, and DataText To Columns, with fixed width but no breaks. That should sort it. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Lasse" wrote in message ... Hi, I have problem with cell calculations, the formula don't been calculated. The Tool- Options- Calculations is set to Automatic, but it does not calculates and nothing happens if I press F9. But if I double-Click the Cell (edit Formula) and then press enter key its calculates. Can I do anything so it's calculates automatic, without this procedure. //Lasse |
#4
|
|||
|
|||
Calculations of cells
I have a problem with the calculations as well. I am running Excel with a
simulation program called Extend. It's a discrete event model and everytime time jumps, my model recalculates. Extend will let you choose the number of model runs, however I want the spreadsheet to only calculate at the beginning of each run. Because the users desire to have a "no contact" approach, they don't want to have to press F9. Does anyone know of another way that I can have it recalculate just once without closing and re-opening Excel? Kathleen "Bob Phillips" wrote: Sounds like the cells are formatted as text. Select them all, and DataText To Columns, with fixed width but no breaks. That should sort it. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Lasse" wrote in message ... Hi, I have problem with cell calculations, the formula don't been calculated. The Tool- Options- Calculations is set to Automatic, but it does not calculates and nothing happens if I press F9. But if I double-Click the Cell (edit Formula) and then press enter key its calculates. Can I do anything so it's calculates automatic, without this procedure. //Lasse |
#5
|
|||
|
|||
Calculations of cells
If you have some way of knowing when a run starts and ends, you could manage
the calculation mode via code. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Kathleen" wrote in message ... I have a problem with the calculations as well. I am running Excel with a simulation program called Extend. It's a discrete event model and everytime time jumps, my model recalculates. Extend will let you choose the number of model runs, however I want the spreadsheet to only calculate at the beginning of each run. Because the users desire to have a "no contact" approach, they don't want to have to press F9. Does anyone know of another way that I can have it recalculate just once without closing and re-opening Excel? Kathleen "Bob Phillips" wrote: Sounds like the cells are formatted as text. Select them all, and DataText To Columns, with fixed width but no breaks. That should sort it. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Lasse" wrote in message ... Hi, I have problem with cell calculations, the formula don't been calculated. The Tool- Options- Calculations is set to Automatic, but it does not calculates and nothing happens if I press F9. But if I double-Click the Cell (edit Formula) and then press enter key its calculates. Can I do anything so it's calculates automatic, without this procedure. //Lasse |
#6
|
|||
|
|||
Calculations of cells
Ok, thanks. Is there a way to manage it by the changing of some cell value?
Kathleen "Bob Phillips" wrote: If you have some way of knowing when a run starts and ends, you could manage the calculation mode via code. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Kathleen" wrote in message ... I have a problem with the calculations as well. I am running Excel with a simulation program called Extend. It's a discrete event model and everytime time jumps, my model recalculates. Extend will let you choose the number of model runs, however I want the spreadsheet to only calculate at the beginning of each run. Because the users desire to have a "no contact" approach, they don't want to have to press F9. Does anyone know of another way that I can have it recalculate just once without closing and re-opening Excel? Kathleen "Bob Phillips" wrote: Sounds like the cells are formatted as text. Select them all, and DataText To Columns, with fixed width but no breaks. That should sort it. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Lasse" wrote in message ... Hi, I have problem with cell calculations, the formula don't been calculated. The Tool- Options- Calculations is set to Automatic, but it does not calculates and nothing happens if I press F9. But if I double-Click the Cell (edit Formula) and then press enter key its calculates. Can I do anything so it's calculates automatic, without this procedure. //Lasse |
#7
|
|||
|
|||
Calculations of cells
Yes, ideal, you could use worksheet change event
Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Const WS_RANGE As String = "H1" '== change to suit On Error GoTo ws_exit Application.EnableEvents = False If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then With Target If .Value = "Off" Then Application.Calculation = xlCalculationManual Else Application.Calculation = xlCalculationAutomatic End If End With End If ws_exit: Application.EnableEvents = True End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Kathleen" wrote in message ... Ok, thanks. Is there a way to manage it by the changing of some cell value? Kathleen "Bob Phillips" wrote: If you have some way of knowing when a run starts and ends, you could manage the calculation mode via code. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Kathleen" wrote in message ... I have a problem with the calculations as well. I am running Excel with a simulation program called Extend. It's a discrete event model and everytime time jumps, my model recalculates. Extend will let you choose the number of model runs, however I want the spreadsheet to only calculate at the beginning of each run. Because the users desire to have a "no contact" approach, they don't want to have to press F9. Does anyone know of another way that I can have it recalculate just once without closing and re-opening Excel? Kathleen "Bob Phillips" wrote: Sounds like the cells are formatted as text. Select them all, and DataText To Columns, with fixed width but no breaks. That should sort it. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Lasse" wrote in message ... Hi, I have problem with cell calculations, the formula don't been calculated. The Tool- Options- Calculations is set to Automatic, but it does not calculates and nothing happens if I press F9. But if I double-Click the Cell (edit Formula) and then press enter key its calculates. Can I do anything so it's calculates automatic, without this procedure. //Lasse |
Thread Tools | |
Display Modes | |
|
|