Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel printing problem - won't print cell under a "fill effect" bo | Excel Discussion (Misc queries) | |||
How can I update the version of Excel 2000 9.0 to version 10.0 | Excel Discussion (Misc queries) | |||
excell version | Excel Discussion (Misc queries) | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
excell 2003 will not open previous version | Excel Discussion (Misc queries) |