Skip to main content
J
JohnWarhus1-Visitor
1-Visitor
January 27, 2018
Question

excel component errors

  • January 27, 2018
  • 3 replies
  • 6614 views

I have a worksheet in which I am using the excel component to build an output table.  It appears that there is a limit to how much you can put into an excel component, because, when I reach a point in building the table, when I add one more element I get the error message "this expression is too large to be calculated".  The error occurs even on expressions that are constants.  In a couple of cases, the files have somehow become corrupted and crash within second of opening them.

Does anyone have any insights?

Thanks,

John W

3 replies

L
LucMeekes23-Emerald IV
23-Emerald IV
January 27, 2018

Please attach your worksheet.

You may have to zip it first.

A serious bug in this forum often prevents from attaching a mathcad file. In Windows Explorer click with the right-mouse button on the mathcad file and select 'Send to' -> 'Compressed (zipped) folder'. The resulting .zip file can be attached.

You can add to the zip-file any additional files needed to operate the sheet.

 

Luc

R
RichardJ19-Tanzanite
19-Tanzanite
January 27, 2018

Which version of Mathcad? There is Mathcad, and there is Mathcad Prime, and they are worlds apart in every respect.

J
JohnWarhus1-VisitorAuthor
1-Visitor
January 27, 2018

The file with problem is attached, along with another excel file it uses for some data.  The file has no errors now, but if you add one more excel expression the excel component, the error message will generate.

R
RichardJ19-Tanzanite
19-Tanzanite
January 27, 2018

There are missing Excel files at the start of the document, so your worksheet is a sea of red.

 

Whatever. It can be reduced to just the Excel component, in which case for me adding one more expression does not cause an error.

J
JohnWarhus1-VisitorAuthor
1-Visitor
January 28, 2018

The "missing file" is in the zipped package I posted.  I have found that you sometime have to redo those readexcel call to get then to work properly.  The referenced file in in the directory tree one level above the file with the problem.

Terms & ConditionsAccessibility statement