cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

excel component errors

Participant

excel component errors

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

Tags (2)
14 REPLIES 14

Re: excel component errors

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

Re: excel component errors

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

Re: excel component errors

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.

Highlighted

Re: excel component errors

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.

Re: excel component errors

This is a file for version 4.0. Can you please attach a PDF vesion of this worksheet?

Re: excel component errors

Sure

Re: excel component errors

Thanks!

Re: excel component errors

There's not much to see. Just an Excel component with 15 input expressions (the worksheet from the OP had 14).

Re: excel component errors

Richard,

 

please try adding an excel expression to the first excel component.  I put the second on in while trying to figure out what is going on.  You can remove it as it is not part of the problem.

Announcements