Excell version problem???
 

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

Excell version problem???
 

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



"Mabe-GE" wrote:

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

Excell version problem???
 

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

Vaya con dios mi chavo

"CLR" wrote:

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



"Mabe-GE" wrote:

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

Excell version problem???
 

On Tue, 24 Jan 2006 07:42:04 -0800, "Mabe-GE"
wrote:

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

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

Excell version problem???
 

Mabe-GE -

It might help if you told us what is in cell F39 (a formula?).

Or, maybe you only need to recalculate (by pressing the F9 key).

- Mike
www.mikemiddleton.com

"Mabe-GE" wrote in message
...
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