Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mabe-GE
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mabe-GE
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Middleton
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel printing problem - won't print cell under a "fill effect" bo dmotika Excel Discussion (Misc queries) 0 May 26th 05 04:38 PM
How can I update the version of Excel 2000 9.0 to version 10.0 Ramsey Can Excel Discussion (Misc queries) 1 May 11th 05 03:28 PM
excell version m-c Excel Discussion (Misc queries) 1 May 1st 05 09:46 AM
Freeze Pane problem in shared workbooks JM Excel Discussion (Misc queries) 1 February 1st 05 12:04 AM
excell 2003 will not open previous version fsg Excel Discussion (Misc queries) 2 January 21st 05 07:19 PM


All times are GMT +1. The time now is 08:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"