Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculations
I have a sheet with very heavy calculations. Is it possible to separate the
calculation in Excel, so that I can disable calculations in that sheet only. Ie. I would like Excel to continue caluclating my sheets except for the one with a lot of calculations in it. -- Peter B Norway |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculations
Peter,
Not tried, but perhaps disable automatic calculate, and have a worksheet change event that triggers calculate on other sheets. Private Sub Worksheet_Change(ByVal Target As Range) Dim oWs As Worksheet On Error GoTo ws_exit: Application.EnableEvents = False For Each oWs In ThisWorkbook.Worksheets If oWs.Name < Me.Name Then oWs.Calculate End If Next oWs 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 RP (remove nothere from the email address if mailing direct) "Peter B" wrote in message ... I have a sheet with very heavy calculations. Is it possible to separate the calculation in Excel, so that I can disable calculations in that sheet only. Ie. I would like Excel to continue caluclating my sheets except for the one with a lot of calculations in it. -- Peter B Norway |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculations
Peter,
You need to change all your formulas to something like =IF($A$1,"",really complicated heavy formula) Then, when you want to do the calcs on that sheet, enter FALSE into cell A1. If you need to have the results available at all times, then you would need to have a macro or event that stores the values somewhere else, and use =IF($A$1, stored value cell, calculation) HTH, Bernie MS Excel MVP "Peter B" wrote in message ... I have a sheet with very heavy calculations. Is it possible to separate the calculation in Excel, so that I can disable calculations in that sheet only. Ie. I would like Excel to continue caluclating my sheets except for the one with a lot of calculations in it. -- Peter B Norway |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculations
Hi Bernie,
Neat idea! Biggest problem is that it makes the heavy calculations even heavier <G). Bob "Bernie Deitrick" <deitbe @ consumer dot org wrote in message ... Peter, You need to change all your formulas to something like =IF($A$1,"",really complicated heavy formula) Then, when you want to do the calcs on that sheet, enter FALSE into cell A1. If you need to have the results available at all times, then you would need to have a macro or event that stores the values somewhere else, and use =IF($A$1, stored value cell, calculation) HTH, Bernie MS Excel MVP "Peter B" wrote in message ... I have a sheet with very heavy calculations. Is it possible to separate the calculation in Excel, so that I can disable calculations in that sheet only. Ie. I would like Excel to continue caluclating my sheets except for the one with a lot of calculations in it. -- Peter B Norway |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculations
Bob,
Neat idea! Thanks. I tried to get something to work with events, but couldn't figure out how to do it. Of course, I had never even considered your method of having calcs turned off and forcing calculations on _other_ sheets. Now, I'm going to have to reconsider my design. Biggest problem is that it makes the heavy calculations even heavier <G). That's why I no longer use my P133 machine ;-) Bernie "Bob Phillips" wrote in message ... Hi Bernie, Bob "Bernie Deitrick" <deitbe @ consumer dot org wrote in message ... Peter, You need to change all your formulas to something like =IF($A$1,"",really complicated heavy formula) Then, when you want to do the calcs on that sheet, enter FALSE into cell A1. If you need to have the results available at all times, then you would need to have a macro or event that stores the values somewhere else, and use =IF($A$1, stored value cell, calculation) HTH, Bernie MS Excel MVP "Peter B" wrote in message ... I have a sheet with very heavy calculations. Is it possible to separate the calculation in Excel, so that I can disable calculations in that sheet only. Ie. I would like Excel to continue caluclating my sheets except for the one with a lot of calculations in it. -- Peter B Norway |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculations | Excel Worksheet Functions | |||
MPG Calculations | Excel Worksheet Functions | |||
Calculations | Excel Discussion (Misc queries) | |||
Calculations | Excel Discussion (Misc queries) | |||
Between calculations | Excel Worksheet Functions |