Skip to main content
P
ptc-27182801-Visitor
1-Visitor
March 9, 2012
Question

Unable to edit the input/output variables in an Excel component

  • March 9, 2012
  • 2 replies
  • 5739 views

Hi all

I have saved several MathCAD .xmcd files with Excel tables included. After reopening, intermittently I am unable to edit/add/remove any of the input or output variables.

When I right click on the table and select properties, it sometimes opens the input and output ranges but most of the time it will open just the generic variable properties (with the 5 tab headers - Display, Calc, etc. - along the top). Selecting the explicit "Add Input Variable", etc. has no effect.

I have tried it while running Microsoft Excel and also without but that seems to have no effect. I am running MathCAD 15.

Can anyone give me any pointers to prevent this happening please?

Thanks,

Andrew

2 replies

F
Fred_Kohlhepp23-Emerald I
23-Emerald I
March 9, 2012

In my version 14, if I have just the EXCEL component selected (table or icon) and right-click, I get the "variables" menu, if I drag to have the whole expression selected a right-click gets the standard "properties" menu.

P
ptc-27182801-VisitorAuthor
1-Visitor
March 15, 2012

My version 14 worked as you have described with no problems too but I upgraded to version 15 about 6 months ago and this problem has been ongoing since.

V
24-Ruby III
VladimirN24-Ruby III
24-Ruby III
March 12, 2012

Hello!

Please attach your Mathcad worksheet to the message.

P
ptc-27182801-VisitorAuthor
1-Visitor
March 15, 2012

The problem is not confined to a single workbook, it happens with most MathCAD files that I open, so I don't see any benefit in attaching a worksheet.

M
MikeArmstrong1-Visitor
1-Visitor
March 15, 2012

What version of Excel are you using.

Mike

Terms & ConditionsAccessibility statement