Skip to main content
S
SM_101511383-Newcomer
3-Newcomer
June 30, 2023
Question

Include Worksheet Sharepoint

  • June 30, 2023
  • 3 replies
  • 2222 views

I am having issues with the Include Worksheet command in Mathcad Prime 7.  I have a template with all of our standard materials propeties which I want to point to for our range of standard calculations.  I am finding that it looses the link because of how sharepoint downloads the files to you machine, it creates a personal folder on your C drive.

 

Is there a way to keep the link live rather than it using the cache data no matter what machine its downloaded to?

 

 

3 replies

J
JeffH116-Pearl
16-Pearl
July 26, 2023

The only way I have found to do this for our organization is on a standard network shared drive or from an actual IIS (web) server (with a custom web.config file that tells IIS how to recognize Mathcad .mcdx files).

 

SharePoint does not know what a Mathcad file is, how to open it, or how to access it.  I have not found a way (in many, many years) to tell SharePoint what a Mathcad file is or how to open it.  If you paste the address to your file in the SP Doc Library in the Include component, you get a server address with an "@SSL" string buried in it.  I suspect that Mathcad doesn't know how to deal with that.

 

Hope this helps.  If anyone figures out how to store and access reference Include files in a SharePoint library, I'd love to know how.

 

Jeff

S
SM_101511383-NewcomerAuthor
3-Newcomer
August 7, 2023

I have used the sync folder option in sharepoint so I am accessing it in the file explorer, so its like i am working on a local server.  My issues comes when you use the include worksheet command, the file path that comes in, the string has my name against it.  When someone then opens that file the include worksheet command has an error because they have their own folder file path.

D
DG_107567231-Visitor
1-Visitor
August 12, 2023

Upload the Excel spreadsheet to SharePoint Online document library first. Open the Excel file in the Web browser (Excel Online) >> Click on File >> Share >> Embed. In the Embed window, choose the content from the Excel spreadsheet you want to show, such as a Table, Range of Cells, or full workbook.

D
DG_107567231-Visitor
1-Visitor
August 12, 2023

Thanks for sharing this.

M
Manfred_F12-Amethyst
12-Amethyst
July 26, 2024

I had the same problem using Prime 8. I made some "experiments" and found out that I could include worksheets using a relative path. This requires that the current open worksheet has a working directory on the sharepoint (CWD). Then you can do something like: Include ..\..\xxx\yyy\materials.mcdx
Another solution which worked, is to assign a drive letter to the sharepoint folder with the windows explorer or a shell command. This even makes the access faster. I assume that the sharepoint path string contains letters which Prime does not like for example an "@".

I also had another odd effect. When I put a picture into a Prime worksheet and save it on the sharepoint, Prime will tell me the picture is corrupted, when I reopen the sheet. If I copy this file to a local drive Prime opens and displays it without a problem. Using the drive letter also helps here. Seems that the picture somehow contains an information about the file path or so....
I want to add that, accessing an excel file file for example with READEXCEL works even using an absolute sharepoint path

    Terms & ConditionsCookie settingsAccessibility statement