Refreshing Cells

[Terry Hendicott]

Hi.

I am using MathCad to insert values into some cells in Excel. This is working fine.
However cells that rely on the inputted values do not update.

I insert a cell value using MathCad say Sheet2!A1.
I set cell Sheet1!A1 = Sheet2!A1.

On exporting the data from Mathcad with excel file closed it does set the value of Sheet2!A1
On opening Excel the value is in Sheet2!A1. the formula is in Sheet1!A1 but the value does not update in the cell unless you edit the formula again.

How do I get the cell Sheet1!A1 to update after automatically importing value into Sheet2!A2

 

[JoeMo]

Is calculation set to Automatic?

 

[Terry Hendicott]

Is calculation set to Automatic?

Yep first thing I checked.

 

[JoeMo]

With Sheet1 active, hold down the shift key and press the F9 key - does Sheet1!A1 update?

 

[Terry Hendicott]

With Sheet1 active, hold down the shift key and press the F9 key - does Sheet1!A1 update?

Excellent idea but did not work. Must be some flag on the cell Sheet2!A1 that has not been set to let Excel know Sheet1!A1 needs updating?

It updates if I manually change Sheet2!A1 cell.
It updates if I edit Sheet1!A1 formula.

 

[JoeMo]

Don't know anything about MathCad, but if you are willing to convert your workbook to a macro-enabled workbook, you could install the code below to place the desired formula in Sheet1 A1 when the workbook is opened.
To install ThisWorkbook code:
1. With your workbook active press Alt and F11 keys. This will open the VBE window.
2. In the project tree on the left of the VBE window, find your project and double-click the 'Thisworkbook' icon.
3. Copy the code below from your browser window and paste it into the white space in the VBE window.
4. Close the VBE window and Save the workbook. If you are using Excel 2007 or a later version do a SaveAs and save it as a macro-enabled workbook (.xlsm file extension).
5. Make sure you have enabled macros whenever you open the file or the code will not run.

Private Sub Workbook_Open()
Sheets("Sheet1").Range("A1").Formula = "=Sheet2!A1"
End Sub

 

[Terry Hendicott]

Thanks

Cheers
Terry

 

[JoeMo]

You are welcome - thanks for the reply.