iLogic GoExcel issue

[Anonymous]

I'm running this code to input user parameter values to a linked excel spreadsheet. When any of the values of cells B2-B6  are changed, the spreadsheet automatically runs a solver macro, which generates values in cells B19-B22.

The code works (eventually) but as the solver is running through all it's possibilities, the model is trying to regenerate each one which takes a long time.

Is there a way I can delay reading from the spreadsheet until the solver has produced the final result?

GoExcel.CellValue("3rd Party:GAS SPRING CALCULATION.xlsm", "Data Input", "B2") = casewidth
GoExcel.CellValue("B3") = casedepth
GoExcel.CellValue("B4") = caseheight
GoExcel.CellValue("B5") = glass
GoExcel.CellValue("B6") = plinthheight
    
 
openangle = GoExcel.CellValue("3rd Party:GAS SPRING CALCULATION.xlsm", "Data Input", "B19")
posA = GoExcel.CellValue("B20")
posB = GoExcel.CellValue("B21")
posC = GoExcel.CellValue("B22")

GoExcel.Save
GoExcel.Close

[GeorgK]

AssemblyOptions.DeferUpdate Property

Description
Property that enables or disables updating assemblies when you edit components. Setting this property to True will defer updates of an assembly until the Update button is clicked or the Update method of the document is called.

Syntax
AssemblyOptions.DeferUpdate() As Boolean

[Anonymous]

That doesn't work unfortunately, is it because the rule I'm running is in an ipt and not an assembly?

[MechMachineMan]

Try adding

GoExcel.Application.EnableCalculation = False

Followed by 

GoExcel.Application.EnableCalculation = True

at the end of the code.

[Anonymous]

@MechMachineMan

Thanks for your suggestion. I get this error:

Public member 'EnableCalculation' on type 'Application' not found.

It may be due to where I've placed the two lines, should they both be placed together at the end of the code before saving and closing the document?

I'm not sure what result to expect either, as I couldn't find much about the GoExcel.Application.EnableCalculation boolean online.

[MechMachineMan]

It's excel API. It is the option you need in excel to prevent calculations.
One line at the start, one line at the end. The first line shoulf be placed
after you open the excel file with GoExcel, the next should be before you
close excel or after you are done pasting info into excel.