Circular Reference 2000 vs 2002

B

brent

I was asked to look over a workbook that, when opened on a machine running
Win2K / XL2000, had the #VALUE! error in a vast amount of cells.

I had the wb emailed to myself and opened it on one of my machines (XP Pro /
XL2002) and the wb opened just fine. I opened it on another machine (Win98SE
/ XL2000) and there were the errors again. I can turn Calculation to manual
and the workbook will open without the errors. I compared the Calc settings
between versions, they were set up the same. Apparently there are circular
references in this wb which XL2002 handles differently than does previous
versions.

Is there a difference in how newer versions of Excel handle circular
references?
 
J

Jim Rech

I don't know of any changes specific to circ handling but I do know that the
calc engine was reworked quite a bit in Excel 2002 to make various
improvements. If you save the workbook in 2002 and then open it in 2000 is
the circ still present? If it is, and the workbook is going to continue to
be used in 2000, I think you have to track down why Excel thinks there is a
circ. Otherwise the workbook may not calc properly.

--
Jim Rech
Excel MVP
|I was asked to look over a workbook that, when opened on a machine running
| Win2K / XL2000, had the #VALUE! error in a vast amount of cells.
|
| I had the wb emailed to myself and opened it on one of my machines (XP Pro
/
| XL2002) and the wb opened just fine. I opened it on another machine
(Win98SE
| / XL2000) and there were the errors again. I can turn Calculation to
manual
| and the workbook will open without the errors. I compared the Calc
settings
| between versions, they were set up the same. Apparently there are
circular
| references in this wb which XL2002 handles differently than does previous
| versions.
|
| Is there a difference in how newer versions of Excel handle circular
| references?
|
|
 
B

brent

Thanks Jim for the quick response. I tried saving in 2002 but the errors are
still there in 2000. Earlier this morninig I loaded the wb onto a laptop
running XP and XL2003 and placed it on the VP's desk. The wb is a proposal
and will not be used regularly.

(The VP is comfortable with 2000 and does not wish to migrate to 2002/3.
Maybe this will spur him forward)
 
Top