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

Referencing multiple worksheets - Error

Highlighted
Newbie

Referencing multiple worksheets - Error

Hi everyone,

 

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)

 

Thanks,

 

Henry

 

2 REPLIES 2

Re: Referencing multiple worksheets - Error

Can you post the worksheets..?

Re: Referencing multiple worksheets - Error

Hi,

You must respect the following chart.

About references.jpg

Constants and variables defined in a reference file, must not be redefined in the program that makes use of the reference.