Home |
Search |
Today's Posts |
#1
|
|||
|
|||
New Version Excel 2003 related question
I have MS office 2000 at home and Ms office 2003 at Office. Can I bring my
XLS file and use on Excel 2003 and after editing save or creating new file, I can open them on Excel 2000. Please advise. Regards. Irshad |
#2
|
|||
|
|||
I have Office 97 and Office 2003 on the same PC at work, and office 2000 at home and frequently travel files (up to 100 worksheets per workbook) between the 3, to date I have not had a problem, but am aware that some features of the later editions may not revert back correctly to the '97 version. To date I have not encountered any. Irshad Alam Wrote: I have MS office 2000 at home and Ms office 2003 at Office. Can I bring my XLS file and use on Excel 2003 and after editing save or creating new file, I can open them on Excel 2000. Please advise. Regards. Irshad -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=395645 |
#3
|
|||
|
|||
Yep.
But there are new features in each version of excel (say the List feature that was added in xl2003). Things like that won't be available in xl2k. Irshad Alam wrote: I have MS office 2000 at home and Ms office 2003 at Office. Can I bring my XLS file and use on Excel 2003 and after editing save or creating new file, I can open them on Excel 2000. Please advise. Regards. Irshad -- Dave Peterson |
#4
|
|||
|
|||
Hi Dave, and thanks for the 'List' - obviously a feature that I don't use. The only difference that I recall having an effect is the Date function in the Text-to-Columns, where the '97 version gets the date format from the first row, and the 2000 / 2003 versions allow you to specify for any column. My workbooks cover Cricket statistics (including the Print to Web feature), Interest calculations, and my pie charts, and if those all work there is hope that Irshad will not encounter any problems. I guess the upgrade to me was something akin to the Word upgrade, many new features, but why would I really need flashing sparkly text? Dave Peterson Wrote: Yep. But there are new features in each version of excel (say the List feature that was added in xl2003). Things like that won't be available in xl2k. Irshad Alam wrote: I have MS office 2000 at home and Ms office 2003 at Office. Can I bring my XLS file and use on Excel 2003 and after editing save or creating new file, I can open them on Excel 2000. Please advise. Regards. Irshad -- Dave Peterson -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=395645 |
#5
|
|||
|
|||
IIRC, xl97 allowed me to specify the date format I wanted for any field when I
did data|text to columns. (And I don't use the List feature much, either.) Bryan Hessey wrote: Hi Dave, and thanks for the 'List' - obviously a feature that I don't use. The only difference that I recall having an effect is the Date function in the Text-to-Columns, where the '97 version gets the date format from the first row, and the 2000 / 2003 versions allow you to specify for any column. My workbooks cover Cricket statistics (including the Print to Web feature), Interest calculations, and my pie charts, and if those all work there is hope that Irshad will not encounter any problems. I guess the upgrade to me was something akin to the Word upgrade, many new features, but why would I really need flashing sparkly text? Dave Peterson Wrote: Yep. But there are new features in each version of excel (say the List feature that was added in xl2003). Things like that won't be available in xl2k. Irshad Alam wrote: I have MS office 2000 at home and Ms office 2003 at Office. Can I bring my XLS file and use on Excel 2003 and after editing save or creating new file, I can open them on Excel 2000. Please advise. Regards. Irshad -- Dave Peterson -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=395645 -- Dave Peterson |
#6
|
|||
|
|||
Dave, yes, if you ran text-to-columns on data already in the sheet, but when run through the Wizard at File Open time was not possible, and the Import converted the column to a dateof it's chosen format. (I forget the problems we had trying to import some of our files into a single column, but was not always possible) Dave Peterson Wrote: IIRC, xl97 allowed me to specify the date format I wanted for any field when I did data|text to columns. (And I don't use the List feature much, either.) Bryan Hessey wrote: Hi Dave, and thanks for the 'List' - obviously a feature that I don't use. The only difference that I recall having an effect is the Date function in the Text-to-Columns, where the '97 version gets the date format from the first row, and the 2000 / 2003 versions allow you to specify for any column. My workbooks cover Cricket statistics (including the Print to Web feature), Interest calculations, and my pie charts, and if those all work there is hope that Irshad will not encounter any problems. I guess the upgrade to me was something akin to the Word upgrade, many new features, but why would I really need flashing sparkly text? Dave Peterson Wrote: Yep. But there are new features in each version of excel (say the List feature that was added in xl2003). Things like that won't be available in xl2k. Irshad Alam wrote: I have MS office 2000 at home and Ms office 2003 at Office. Can I bring my XLS file and use on Excel 2003 and after editing save or creating new file, I can open them on Excel 2000. Please advise. Regards. Irshad -- Dave Peterson -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=395645 -- Dave Peterson -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=395645 |
#7
|
|||
|
|||
If you were opening a .txt file via file|Open, you could still specify the date
format in that wizard. If you were opening a .csv file, then you wouldn't even see the wizard. Bryan Hessey wrote: Dave, yes, if you ran text-to-columns on data already in the sheet, but when run through the Wizard at File Open time was not possible, and the Import converted the column to a dateof it's chosen format. (I forget the problems we had trying to import some of our files into a single column, but was not always possible) Dave Peterson Wrote: IIRC, xl97 allowed me to specify the date format I wanted for any field when I did data|text to columns. (And I don't use the List feature much, either.) Bryan Hessey wrote: Hi Dave, and thanks for the 'List' - obviously a feature that I don't use. The only difference that I recall having an effect is the Date function in the Text-to-Columns, where the '97 version gets the date format from the first row, and the 2000 / 2003 versions allow you to specify for any column. My workbooks cover Cricket statistics (including the Print to Web feature), Interest calculations, and my pie charts, and if those all work there is hope that Irshad will not encounter any problems. I guess the upgrade to me was something akin to the Word upgrade, many new features, but why would I really need flashing sparkly text? Dave Peterson Wrote: Yep. But there are new features in each version of excel (say the List feature that was added in xl2003). Things like that won't be available in xl2k. Irshad Alam wrote: I have MS office 2000 at home and Ms office 2003 at Office. Can I bring my XLS file and use on Excel 2003 and after editing save or creating new file, I can open them on Excel 2000. Please advise. Regards. Irshad -- Dave Peterson -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=395645 -- Dave Peterson -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=395645 -- Dave Peterson |
#8
|
|||
|
|||
Dave Peterson wrote: [...] (And I don't use the List feature much, either.) Bryan Hessey wrote: Hi Dave, and thanks for the 'List' - obviously a feature that I don't use. [...] In fact, it's a significant "addition." Some of the important features of the list functionality a [1] It largely eliminates the need for dynamic named ranges that adversely affect the performance. Whenever the list expands, the formulas referring to ranges within the list adjust automatically. This facilitates contructing pivot tables and graphs which include new data immediately upon refresh. =COUNTIF(B4:B13,2) which refers to a range in A3:D13, converted into a list with Data|List|Create List, automatically adjusted as: =COUNTIF(B4:B13,2) after a new entry in A14. [2] Copying down the formulas is fully automatic within the list itself. One shortcoming in this respect is that the copying is not reliable when a formula refers to a (changing) range above the formula cell: Assuming that the following formula in B3 =IF((A3<"")*ISNA(MATCH(A3,$A$2:A2,0)),SUMPRODUCT( (A3$A$3:$A$16)+0)+1,"") is copied down to B16 in a list in the range A2:D16. Upon a new entry in A17, we get in B17: =IF((A17<"")*ISNA(MATCH(A17,$A$2:A18,0)),SUMPRODU CT((A17$A$3:$A$18)+0)+1,"") which is obviously wrong. This forces us to have in B3 something like: =IF((A3<"")*ISNA(MATCH(A3,$A$2:OFFSET(A3,-1,0),0)),SUMPRODUCT((A3$A$3:$A$16)+0)+1,"") [3] Provides AutoFilter, a Total Row whose results can be referred to in audit formulas. |
#9
|
|||
|
|||
Lots of companies haven't upgraded to xl2003. So using relying on this feature
(if working on the file at home), could be a problem when it's taken back to work. Aladin Akyurek wrote: Dave Peterson wrote: [...] (And I don't use the List feature much, either.) Bryan Hessey wrote: Hi Dave, and thanks for the 'List' - obviously a feature that I don't use. [...] In fact, it's a significant "addition." Some of the important features of the list functionality a [1] It largely eliminates the need for dynamic named ranges that adversely affect the performance. Whenever the list expands, the formulas referring to ranges within the list adjust automatically. This facilitates contructing pivot tables and graphs which include new data immediately upon refresh. =COUNTIF(B4:B13,2) which refers to a range in A3:D13, converted into a list with Data|List|Create List, automatically adjusted as: =COUNTIF(B4:B13,2) after a new entry in A14. [2] Copying down the formulas is fully automatic within the list itself. One shortcoming in this respect is that the copying is not reliable when a formula refers to a (changing) range above the formula cell: Assuming that the following formula in B3 =IF((A3<"")*ISNA(MATCH(A3,$A$2:A2,0)),SUMPRODUCT( (A3$A$3:$A$16)+0)+1,"") is copied down to B16 in a list in the range A2:D16. Upon a new entry in A17, we get in B17: =IF((A17<"")*ISNA(MATCH(A17,$A$2:A18,0)),SUMPRODU CT((A17$A$3:$A$18)+0)+1,"") which is obviously wrong. This forces us to have in B3 something like: =IF((A3<"")*ISNA(MATCH(A3,$A$2:OFFSET(A3,-1,0),0)),SUMPRODUCT((A3$A$3:$A$16)+0)+1,"") [3] Provides AutoFilter, a Total Row whose results can be referred to in audit formulas. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add-In causes excel 2003 to crash on startup | Excel Discussion (Misc queries) | |||
Excel 2003 crashes loading excel files created Excel 2000 | Excel Discussion (Misc queries) | |||
quattro pro converter Excel 2003 | New Users to Excel | |||
Can you use excel 2003 version with excel 2002 and 2000 on a netw. | Excel Discussion (Misc queries) | |||
can a workbook with macros created in excel 2003 work in excel 20. | Excel Discussion (Misc queries) |