Terry Hendicott
New Member
- Joined
- Oct 18, 2017
- Messages
- 4
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
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