Skip to main content
IA_1269937210-Marble
10-Marble
Feb 10, 2026 10:57 AM UTC
Solved

Mathcad - Excel Component

Hi all, 

 

Currently experiencing an issue with an Excel component on a colleagues computer. 

The Mathcad file, attached, works on my computer fine but not my colleagues. States his "excel is busy". 

Any ideas why it works on my computer but not my colleagues?  

 

Many thanks,

Iain 

 

FYI, I am using Mathcad Prime 10.0.0.0 (and is my colleague). 

terryhendicott
terryhendicottAnswer
21-Topaz II
Feb 12, 2026 9:07 AM UTC

Hi Iain,

Here is answer to your question.  Got sidetracked?

Capture.JPG

Cheers

Terry

View in thread

7 replies

LucMeekes23-Emerald V
23-Emerald V
Feb 10, 2026 12:22 PM UTC

This problem has beeen around for years: https://community.ptc.com/t5/Mathcad/Problem-with-Excel-component-being-quot-busy-quot/m-p/146047#M57273 

This may help: https://community.ptc.com/t5/Mathcad/Mathcad-Prime-11-Excel-Component-Error/m-p/1014944 

 

Success!
Luc

Translate
IA_1269937210-MarbleAuthor
10-Marble
Feb 10, 2026 12:34 PM UTC

Thanks Luc, 

 

I am trying to do it via READEXCEL but struggling to use Vector & Matrix functions to look for corresponding section property data. 

See attached, any ideas? 

 

Kind regards,

Iain 

Translate
LucMeekes23-Emerald V
23-Emerald V
Feb 10, 2026 1:39 PM UTC

Hi Iain,

 

The hlookup function (from help):

• hlookup(z, A, r, [modifier | f])—Looks in the first row of matrix A for a given value z, subject to the conditions of the optionalmodifier, and returns the value(s) in the same column(s) in the row specified by r. When the value(s) are returned, they appear in a vector, starting from the left.

 

In your case for

LucMeekes_0-1770730581833.png

 

the parameters to hlookup are:

z=SectionName = the string "W14X38"

A= The matrix SP read via ReadExcel (you didn't provide the Excel file, so I cannot run the sheet)

r= SP<3>The full fourth column of SP, so a vector, where it requires a scalar, pointing to a specific column. Hence the error. Maybe just use '3' here?

[modifier|f] = in you provide a unit instead of a modifier string or function.

 

The string doesn't appear to be present in the first (top) row of matrrix SP, so a 'not found' error is issued once you correct the Area error...

 

Study the help to find out how to use the functions.

Success!
Luc

 

Translate
Terms & ConditionsAccessibility statement