workbook will calculate on one PC but not another

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
 
F

Flick Olmsford

Have you checked the settings for Iteration on the Tools menu | Options |
calculation tabs on the PCs?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top