I am currently trying to insert 8 references (worksheets) into a central worksheet to pull data for a calculation.
Previously, when using 4 references I have not had any errors. In my current calculation, out of the current 8 references, 2 have errors as shown below:
"There are calculation errors inside "......." "
There are no errors in the referenced worksheets, I have also tried to copy the calculation into a new worksheet, restart the computer, re-enter the reference etc.
Has anyone else had this issue before?
Could it be due to there being too many references?
(I am using Mathcad Prime 3.0 and have tried this in 4.0)
You must respect the following chart.
Constants and variables defined in a reference file, must not be redefined in the program that makes use of the reference.