Read from open Excel file. MP10

Forum|Forum|1 year ago
December 6, 2024
1 reply
1772 views

Hi

Excel is great for condensing information in a small space so when I have multiple input variables (+50) to my mathcad file I read those from an excel file. In MathCad 15 this excel file could be open and editable while mathcad was still able to read the values which allow for a very efficient "trial and error" workflow. (change data in excel - press ctrl F9 in mathcad. Review result and repeat as necessary) In Prime I have to close the excel file between each recalculation of the mathcad fil - do you know of any workaround or fix to this ??

Mathcad Usage

Best answer by blarsen

Hi

It seems to be onedrive causing the issue. If I move the files to a "normal" drive it all works as it should. Thanks for your time

T

terryhendicott

21-Topaz II

Hi,

Using the READEXCEL() function to read cells or ranges works if the EXCEL file is open or closed.

This means the EXCEL sheet can be open adjust the cells and press save then recalculate in the open Prime GUI.

The Excel sheet and Prime remains visible at all times you just need to remember to save to update the EXCEL file before recalculating the values in Prime.

It is possible to bring in many variables at once