cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Need help navigating or using the PTC Community? Contact the community team. X

Read from open Excel file. MP10

blarsen
10-Marble

Read from open Excel file. MP10

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

ACCEPTED SOLUTION

Accepted Solutions

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

View solution in original post

6 REPLIES 6

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

Capture2.JPG

Capture.JPG

Hi

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

blarsen_0-1733483642271.png

 

 

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


Martin Hanák

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.)


@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...


Martin Hanák

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

Announcements

Top Tags