View Single Post
  #1   Report Post  
GallanH
 
Posts: n/a
Default unlocked cells in excel 2000 now locked when opened in 2003 why?

An existing excel sheet prepared in excel 2000 is password protected, users
allowed to select entries from validated lists in unlocked cells. Users with
excel 2003 can see the validated lists but if they try to select an item,
they are told that the sheet is protected and data cannot be entered. Looking
at the settings, the unlocked cells in 2000 are now shown as locked in 2003.
Is there a work round?