topic Re: Embedded Excel file issue in Mathcad 10 in Mathcad

Embedded Excel file issue in Mathcad 10

Raiko — Tue, 30 Jul 2024 11:26:34 GMT

Hi guys,

I'm having issues with embedded Excel files.

After opening a Mathcad Prime 10 file with an embedded Excel file (from which I'm reading in data for calculation) MC suggests that I might be editing the Excel file and thus the calculation can't continue; see screen shot.

Has anybody experienced the same issue and (hopefully!) a solution to the problem?

Some more information:

Win 11, 64 Bit machine.
MathCad Prime 10
Checked Task Manager for background Excel files running - none.
I've deleted the Excel file and "re-embedded" a new one - same issue.
New Mathcad file with new embedded Excel file - same result.

Re: Embedded Excel file issue in Mathcad 10

terryhendicott — Tue, 30 Jul 2024 21:47:23 GMT

Hi,

I have tried with a very large Excel file and all is well on my system.

Can you uplaod the Prime sheet with the problem?

Cheers'Terry

Re: Embedded Excel file issue in Mathcad 10

terryhendicott — Wed, 31 Jul 2024 01:23:39 GMT

Hi,

Try turning off multithreading calculations

Re: Embedded Excel file issue in Mathcad 10

Raiko — Wed, 31 Jul 2024 06:50:59 GMT

Hello Terry,

thanks for your advice, but switching off multithreading doesn't work.

I've attached the "offensive" Mathcad sheet. It worked before, but since Monday it started misbehaving. Perhaps it is due to our companies switch to Win 11..

Thanks

Raiko

Re: Embedded Excel file issue in Mathcad 10

Werner_E — Wed, 31 Jul 2024 07:29:33 GMT

I can just confirm that the Excel component in the sheet you posted works pretty well here with Prime 10, Windows 10 and Excel 2016.
When assigning the output variable "parameter" there is a spelling error as the sheet name is "Parameters" and not just "Parameter".

The problem you experience may be due to Windows 11 as you suspect, but its also likely that when your company switched to Win 11 it also changed the Office/Excel version or its update and that there is some incompatibility with Prime - don't know.
Maybe PTC support can be of help?

Re: Embedded Excel file issue in Mathcad 10

Raiko — Wed, 31 Jul 2024 07:59:00 GMT

I will give PTC support a try

Re: Embedded Excel file issue in Mathcad 10

terryhendicott — Wed, 31 Jul 2024 07:59:03 GMT

OS Name Microsoft Windows 11 Pro
Version 10.0.22621 Build 22621

Kept up to date.

Excel 2019

Prime 10

All seems to be fine

Cheers

Terry

Re: Embedded Excel file issue in Mathcad 10

Raiko — Wed, 31 Jul 2024 08:03:04 GMT

Thanks for your support Terry. It must be some settings in our company's IT system

Re: Embedded Excel file issue in Mathcad 10

terryhendicott — Wed, 31 Jul 2024 09:12:03 GMT

Hi,

One thing we have not tried is using a file that is working on a system.

So returnung file with correction identified by Werner

Cheers

Terry

Re: Embedded Excel file issue in Mathcad 10

Raiko — Wed, 31 Jul 2024 09:42:28 GMT

Terry,

no change here. As soon as I opened your file an error was thrown. It's definitely our system because using a non-embedded Excel file works just fine.

Raiko