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?
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.
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.
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.
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.