Office 2003 (Excel)
I have a worksheet where I have 3 columns and 40 rows unlocked, the rest are
locked as far as security goes. The 3rd col has validation for text up to 74 chars with a warning of the error and to delete the xtra chars. Then I protect the sheet, the book and then I share it. It does not work in other computers. I guess other poeple have office 2000 or whatever. So with that in mind I save my sheet to Excel 97 & 95 (or something to that effect). It does not work in other computers. I'm desperate now. Or rather exasperated. :-) Please help. TIA Hernan |
Office 2003 (Excel)
Hi Hernan,
Alt+down arrow for the drop down, then down arrow to choose then Enter. (And of course, if you went too far use the up arrow) Ken Johnson (Using Office 2000) |
Office 2003 (Excel)
Sorry, wrong thread!
Ken Johnson |
Office 2003 (Excel)
I think that Data|Validation was added in xl97.
So if you have other users who are still using xl95, then your cells with data|validation won't help them. If all your users are at xl97 or higher, you should be able to save the workbook as a normal workbook--the fileformat changed in xl97 and hasn't changed since. When I applied data|validation to a cell in a worksheet and shared & saved the workbook as a normal workbook (I also use xl2003), then I could open it and the data|validation rules still worked fine. But I don't have earlier versions of excel to test. Hernan wrote: I have a worksheet where I have 3 columns and 40 rows unlocked, the rest are locked as far as security goes. The 3rd col has validation for text up to 74 chars with a warning of the error and to delete the xtra chars. Then I protect the sheet, the book and then I share it. It does not work in other computers. I guess other poeple have office 2000 or whatever. So with that in mind I save my sheet to Excel 97 & 95 (or something to that effect). It does not work in other computers. I'm desperate now. Or rather exasperated. :-) Please help. TIA Hernan -- Dave Peterson |
Office 2003 (Excel)
In any event, it did not work in either case...the other users have Office
2000, and I saved this in both regular 2003 and 97. Hernan "Dave Peterson" wrote: I think that Data|Validation was added in xl97. So if you have other users who are still using xl95, then your cells with data|validation won't help them. If all your users are at xl97 or higher, you should be able to save the workbook as a normal workbook--the fileformat changed in xl97 and hasn't changed since. When I applied data|validation to a cell in a worksheet and shared & saved the workbook as a normal workbook (I also use xl2003), then I could open it and the data|validation rules still worked fine. But I don't have earlier versions of excel to test. Hernan wrote: I have a worksheet where I have 3 columns and 40 rows unlocked, the rest are locked as far as security goes. The 3rd col has validation for text up to 74 chars with a warning of the error and to delete the xtra chars. Then I protect the sheet, the book and then I share it. It does not work in other computers. I guess other poeple have office 2000 or whatever. So with that in mind I save my sheet to Excel 97 & 95 (or something to that effect). It does not work in other computers. I'm desperate now. Or rather exasperated. :-) Please help. TIA Hernan -- Dave Peterson |
Office 2003 (Excel)
Sorry, I don't have another guess.
Hernan wrote: In any event, it did not work in either case...the other users have Office 2000, and I saved this in both regular 2003 and 97. Hernan "Dave Peterson" wrote: I think that Data|Validation was added in xl97. So if you have other users who are still using xl95, then your cells with data|validation won't help them. If all your users are at xl97 or higher, you should be able to save the workbook as a normal workbook--the fileformat changed in xl97 and hasn't changed since. When I applied data|validation to a cell in a worksheet and shared & saved the workbook as a normal workbook (I also use xl2003), then I could open it and the data|validation rules still worked fine. But I don't have earlier versions of excel to test. Hernan wrote: I have a worksheet where I have 3 columns and 40 rows unlocked, the rest are locked as far as security goes. The 3rd col has validation for text up to 74 chars with a warning of the error and to delete the xtra chars. Then I protect the sheet, the book and then I share it. It does not work in other computers. I guess other poeple have office 2000 or whatever. So with that in mind I save my sheet to Excel 97 & 95 (or something to that effect). It does not work in other computers. I'm desperate now. Or rather exasperated. :-) Please help. TIA Hernan -- Dave Peterson -- Dave Peterson |
All times are GMT +1. The time now is 03:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com