T
Tonso
Using xl2002, I created a workbook. it contains a circular reference.
i created a workbook_open procedure that appears to have eliminated
the problem on my PC...
Application.MaxChange = 0.001
ActiveWorkbook.PrecisionAsDisplayed.
when i open the workbook on my pc it opens right up, and works. on
other PCs, a message appears...
"Microsoft Excel cannot calculate a formula. Cell references in the
formula refer to the formula's result, creating a circular
reference......."
Why does the workbook work fine on my PC, and not on others? What can
I do to make it work universally?
Thanks...
Tonso
i created a workbook_open procedure that appears to have eliminated
the problem on my PC...
Application.MaxChange = 0.001
ActiveWorkbook.PrecisionAsDisplayed.
when i open the workbook on my pc it opens right up, and works. on
other PCs, a message appears...
"Microsoft Excel cannot calculate a formula. Cell references in the
formula refer to the formula's result, creating a circular
reference......."
Why does the workbook work fine on my PC, and not on others? What can
I do to make it work universally?
Thanks...
Tonso