Excell version problem???

M

Mabe-GE

When opening a excel sheet with version 2003 (11.5612.5606) I see the cell
F39 with the value 10.96% but if I open the SAME file with version 2000
(9.0.3821 SR-1) I see the same cell with the value 13.06

The cell values should be equal regardless of the excel version ¿right?

Please help
 
C

CLR

I don't use 2003, but I have run in to differences between 2000 and XL97.
Some code does not perform the same between the two, and if the Analysis
Toolpak is not installed in one or the other there can be differences in some
calculations. So, if your cell value is derived from code or formulas, one
or the other of those could account for your difference.

hth
Vaya con Dios,
Chuck, CABGx3
 
M

Mabe-GE

Thanks
I will try installing the analysis tool pack in both versions and let you
know ASAP

Vaya con dios mi chavo
 
R

Ron Rosenfeld

When opening a excel sheet with version 2003 (11.5612.5606) I see the cell
F39 with the value 10.96% but if I open the SAME file with version 2000
(9.0.3821 SR-1) I see the same cell with the value 13.06

The cell values should be equal regardless of the excel version ¿right?

Please help
Click to expand...

Forget about what you "see"

What, exactly, is "contained" within the cell? In other words, what is the
contents of the cell as seen in the formula bar?

If it is a formula, what is the formula, and what are the contents of the
precedents?

Some statistical functions have been changed in 2003. In addition, if these
values are dependent on a date, the two workbooks might be using different date
systems.


--ron
 
Top