workbook will calculate on one PC but not another

Giganews Newsgroups
Subject: workbook will calculate on one PC but not another
Posted by:  Tonso (wthomas…@hotmail.com)
Date: Wed, 2 Jul 2008

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

Replies