Skip to main content
gpommeranz10-Marble
10-Marble
Nov 24, 2014 8:31 PM UTC
Solved

Updating Readexcel data

I'm having an issue with the "Readexcel" command in Mathcad Prime 3.0. I have an Excel spreadsheet that contains several cells of data that I'm importing into my Mathcad worksheet. My problem is that once Mathcad reads the Excel file I can't enter a new value in the Excel sheet and get Mathcad to import it without deleting the existing readexcel input and reentering it. I've tried closing and reopening the document to no avail. Is there a way to get Mathcad to reevaluate the input without deleting it and starting over?

The cells I'm reading are part of a larger Excel worksheet and it would be easier to leave it as it's own worksheet rather than an embedded object in Mathcad.

Thanks in advance.

Werner_E
Werner_EAnswer
25-Diamond I
Nov 24, 2014 10:37 PM UTC

Doesn't a recalculation of the Prime worksheet (Ctrl-F9) do the trick? In contrary to Mathcad a sheet is not recalculated when you open a worksheet but just shows the results of the last recalculation before the laste save of the sheet.

View in thread

3 replies

Werner_E
Werner_E25-Diamond IAnswer
25-Diamond I
Nov 24, 2014 10:37 PM UTC

Doesn't a recalculation of the Prime worksheet (Ctrl-F9) do the trick? In contrary to Mathcad a sheet is not recalculated when you open a worksheet but just shows the results of the last recalculation before the laste save of the sheet.

Translate
gpommeranz10-MarbleAuthor
10-Marble
Nov 25, 2014 1:35 PM UTC

Thanks, I figured there was a way to do a recalculation in Prime. I discovered my issue was that after making a change in the Excel worksheet, I didn't save it. Once I saved it and then did a recalculation in Prime, the new value was read.

Translate
Werner_E
Werner_E25-Diamond I
25-Diamond I
Nov 25, 2014 6:38 PM UTC

Glad that it works now. The shortcuts F9 (recalc region) and Ctrl-F9 (recalc whole sheet) are shortcuts from real Mathcad (MC15 and below) and still work in Prime.

Prime seems to propagate Ctrl-F5 for recalculation of the sheet, though.

Translate
Terms & ConditionsAccessibility statement