Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question on functions various Excel versions support
I am in process of creating an Excel template file that will be used by
multiple users who may have multiple versions of MicroSoft Excel on their PC. The user will download the Excel file from my site, enter information in the file and then upload the data to my website. Most of the data in the Excel spreadsheet will be free form. There will be one colum where I'm creating a picklist that the user must select from. I am currently using MicroSoft Excel 2002. If I save this file as an older version like version 5.0/95 Workbook, will users who have this version on their PC support the picklist functionality I've created in the template file? Ted |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question on functions various Excel versions support
If you're using data|Validation, I believe that was added in xl97.
You may want to use a dropdown from the Forms toolbar. TP wrote: I am in process of creating an Excel template file that will be used by multiple users who may have multiple versions of MicroSoft Excel on their PC. The user will download the Excel file from my site, enter information in the file and then upload the data to my website. Most of the data in the Excel spreadsheet will be free form. There will be one colum where I'm creating a picklist that the user must select from. I am currently using MicroSoft Excel 2002. If I save this file as an older version like version 5.0/95 Workbook, will users who have this version on their PC support the picklist functionality I've created in the template file? Ted -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question on functions various Excel versions support
Yes, I was using the data/validation function. Just to be certain I should
be able to save the file as Excel 97-2002 & 5.0/95 Workbook and it would work fine for any user from XP to xl97, correct? Why do you think the Forms toolbar is a better route to go than Data/Validation? "Dave Peterson" wrote: If you're using data|Validation, I believe that was added in xl97. You may want to use a dropdown from the Forms toolbar. TP wrote: I am in process of creating an Excel template file that will be used by multiple users who may have multiple versions of MicroSoft Excel on their PC. The user will download the Excel file from my site, enter information in the file and then upload the data to my website. Most of the data in the Excel spreadsheet will be free form. There will be one colum where I'm creating a picklist that the user must select from. I am currently using MicroSoft Excel 2002. If I save this file as an older version like version 5.0/95 Workbook, will users who have this version on their PC support the picklist functionality I've created in the template file? Ted -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question on functions various Excel versions support
If your users are only using xl97 to xl2002, then just save it as a normal
workbook. But there is stuff that was added in xl2002 and xl2003 that doesn't exist in previous versions. You'll want to test--although, I'd bet you won't have any trouble. And if any of your users are using xl95, the dropdown from the forms toolbar is much better than Data|Validation--since that won't work in xl95. In fact, if someone is using xl95, I'd just tell them that they have to upgrade--your workbook doesn't support it. (11 years is pretty darn old in software time.) TP wrote: Yes, I was using the data/validation function. Just to be certain I should be able to save the file as Excel 97-2002 & 5.0/95 Workbook and it would work fine for any user from XP to xl97, correct? Why do you think the Forms toolbar is a better route to go than Data/Validation? "Dave Peterson" wrote: If you're using data|Validation, I believe that was added in xl97. You may want to use a dropdown from the Forms toolbar. TP wrote: I am in process of creating an Excel template file that will be used by multiple users who may have multiple versions of MicroSoft Excel on their PC. The user will download the Excel file from my site, enter information in the file and then upload the data to my website. Most of the data in the Excel spreadsheet will be free form. There will be one colum where I'm creating a picklist that the user must select from. I am currently using MicroSoft Excel 2002. If I save this file as an older version like version 5.0/95 Workbook, will users who have this version on their PC support the picklist functionality I've created in the template file? Ted -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 5 and Excel 2000 question. | Excel Discussion (Misc queries) | |||
Question about Excel | Excel Discussion (Misc queries) | |||
INFORMATION ON FUNCTIONS IN EXCEL (EX. "IF", VALUE LOOKUP) | Excel Worksheet Functions | |||
Are there functions that perform robust statistics in Excel? | Excel Worksheet Functions | |||
Excel Pivot Table Refresh Question | Excel Discussion (Misc queries) |