Read from open Excel file. MP10

[blarsen]

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 ??

[terryhendicott]

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

[blarsen]

Hi

Thanks for the fast reply. However, it does not work in my end. could it be some system setting ?

[MartinHanak]

Hi,

I have performed the following steps:

1.] I downloaded files provided by @terryhendicott 

2.] I modified paths in mcdx file > values ​​were recalculated automatically

3.] I opened xlsx file in Excel 2016

4.] I modified values in Excel window -AND- saved the file

5.] I activated MCP10 window -AND- clicked Calculate button > values ​​were recalculated

[blarsen]

Hi

Strange. I also tried to download @terryhendicott files. Unfortunately, it does not work unless I close excel before recalculating. (I modified the path and It works if excel is closed). We are running MS365 Enterprise / Win 10 and I have upgraded to Prime 10.0.1. Perhaps the upgrade is the reason.)

[MartinHanak]

---

@blarsen wrote:

Hi

Strange. I also tried to download @terryhendicott files. Unfortunately, it does not work unless I close excel before recalculating. (I modified the path and It works if excel is closed). We are running MS365 Enterprise / Win 10 and I have upgraded to Prime 10.0.1. Perhaps the upgrade is the reason.)

---

Hi,

I would suspect MS365 Enterprise rather than MCP 10.0.1.0 ... but one never knows...

[blarsen · Accepted solution]

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