Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problems between 2002/2003
Numerous people using Excel 2002 work on a document with many tabs. The
information is data with some calculations such as SUM, PER CENT, etc., but otherwise pretty basic. Would we anticipate potential problems if one individual working on this document has Excel 2003? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problems between 2002/2003
The Excel 2007 user must always save as in Excel 97-2003 format
She must not exceed the column and row max of Excel 2003 He must not use any of the new Excel functions SUMIF, COUNTIFS, AVERAGEIF and AVERAGEIFS She must not use conditional formatting with more that three rules If he is an average user who has come form Excel 2003 I cannot see that he/she will cause any problem You might expect XL 2007 to issue warnings about incompatible features but if the user has obey the rules above, then all should be wee. I do it all the time - open a XLS file in XL2007 work on it and save as XLS. -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Brenda from Michigan" wrote in message ... Numerous people using Excel 2002 work on a document with many tabs. The information is data with some calculations such as SUM, PER CENT, etc., but otherwise pretty basic. Would we anticipate potential problems if one individual working on this document has Excel 2003? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problems between 2002/2003
Thanks for the reply, but we do not have any users with Excel 2007. We are
only concerned about 2002/2003. It sounds like we should not have problems with 2002/2003???? I'm just looking for confirmation of that information. "Bernard Liengme" wrote: The Excel 2007 user must always save as in Excel 97-2003 format She must not exceed the column and row max of Excel 2003 He must not use any of the new Excel functions SUMIF, COUNTIFS, AVERAGEIF and AVERAGEIFS She must not use conditional formatting with more that three rules If he is an average user who has come form Excel 2003 I cannot see that he/she will cause any problem You might expect XL 2007 to issue warnings about incompatible features but if the user has obey the rules above, then all should be wee. I do it all the time - open a XLS file in XL2007 work on it and save as XLS. -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Brenda from Michigan" wrote in message ... Numerous people using Excel 2002 work on a document with many tabs. The information is data with some calculations such as SUM, PER CENT, etc., but otherwise pretty basic. Would we anticipate potential problems if one individual working on this document has Excel 2003? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problems between 2002/2003
No problems anticipated.
Gord Dibben MS Excel MVP On Mon, 12 Jan 2009 11:36:02 -0800, Brenda from Michigan wrote: Numerous people using Excel 2002 work on a document with many tabs. The information is data with some calculations such as SUM, PER CENT, etc., but otherwise pretty basic. Would we anticipate potential problems if one individual working on this document has Excel 2003? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problems between 2002/2003
The eyesight is not what is was!
There is essentially no difference between XL2002 and XL2003 This is what John Walkenbach had to say when it was released "The new features in this version a (a) improved support for XML, (b) a new "list range" feature, (c) Smart Tag enhancements, and (d) corrected statistical functions. Most users will not find the upgrade worthwhile." Note items (b) and (d). Your user should no make Excel Lists using the command Data | Lists You might find stats functions giving different results from XL2002 but only with very 'odd' data. For example XL2002 could not find the standard deviation of 10000000001,10000000002, 10000000003. It gave a totally 'silly' answer while XL2003 gets it right So other than some small technically things you can expect smooth sailing! best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Brenda from Michigan" wrote in message ... Thanks for the reply, but we do not have any users with Excel 2007. We are only concerned about 2002/2003. It sounds like we should not have problems with 2002/2003???? I'm just looking for confirmation of that information. "Bernard Liengme" wrote: The Excel 2007 user must always save as in Excel 97-2003 format She must not exceed the column and row max of Excel 2003 He must not use any of the new Excel functions SUMIF, COUNTIFS, AVERAGEIF and AVERAGEIFS She must not use conditional formatting with more that three rules If he is an average user who has come form Excel 2003 I cannot see that he/she will cause any problem You might expect XL 2007 to issue warnings about incompatible features but if the user has obey the rules above, then all should be wee. I do it all the time - open a XLS file in XL2007 work on it and save as XLS. -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Brenda from Michigan" wrote in message ... Numerous people using Excel 2002 work on a document with many tabs. The information is data with some calculations such as SUM, PER CENT, etc., but otherwise pretty basic. Would we anticipate potential problems if one individual working on this document has Excel 2003? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problems between 2002/2003
Thanks!
"Gord Dibben" wrote: No problems anticipated. Gord Dibben MS Excel MVP On Mon, 12 Jan 2009 11:36:02 -0800, Brenda from Michigan wrote: Numerous people using Excel 2002 work on a document with many tabs. The information is data with some calculations such as SUM, PER CENT, etc., but otherwise pretty basic. Would we anticipate potential problems if one individual working on this document has Excel 2003? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems with HYPERLINK in Excel 2002 and 2003 | Excel Worksheet Functions | |||
OfficeXP 2002 / Excel....Problems with emailing. | Excel Discussion (Misc queries) | |||
Problems inserting pictures in Excel 2002 sp-2 | Excel Discussion (Misc queries) | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
Problems with Excel formulas when 2002 upgraded to XP | Excel Worksheet Functions |