View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default restricted values error message

I do suggest that you feedback to/discuss with the source party for the
spreadsheet, rather than mess around with the restrictions/controls imposed
on your own.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"Recordhop" wrote:
I was given a spreadsheet to fill in. All cells are unprotected, but when I
try to enter a number in the data cells, it says that I can't because the
cell has "restricted values". The values for the cells are noted as 1-5.
Entering those numbers, I get the error message, when I don't think I should.

How can I "unrestrict" the restricted values?