why Excel2000 don't allow to write

L

ldiaz

hi all.

I have an 2003 excel sheet where I have protected to allow users to edit
ranges,
it works fine in all computer where are running excel 2003, but in computers
where are running excel2000, it does not allow to write even if the field is
available to write then
appear the message that say:
The cell or chart you are trying to change is protected and therefore
read-only.

but message don't appear in Excel 2003

I have asked MIS to upgrade to office 2003, but if you know another option
to correct this issue, I will appreciate so much.

Thanks
LD--
Lorenzo Díaz
Cad Technician
 
D

Dave Peterson

xl2002 was the first version of excel that allowed this range by range
protection. If you open the workbook in an earlier version, then this feature
doesn't exist.
 
G

Gord Dibben

I would say you have two options.

1. Get everyone upgraded.

2. Re-do the workbook in 2003 with features and functions that are available in
all versions.

The latter would mean doing away with the "Allow users to edit ranges" feature.


Gord Dibben MS Excel MVP
 
D

Dave Peterson

And one more recommendation that may mean more work.

Create a macro that asks the user what should be changed and do all the
validation and changes in that macro. This could be a lot of work.
 
Top