Home |
Search |
Today's Posts |
#1
|
|||
|
|||
changing data in range of vlookup
I have created a spreadsheet using vlookup & I now need to amend some of the
information in the range of data, however, when I try to change this I get error message "The value you have entered is not valid. A user has restricted values that can be entered into this cell" Please can you advise how I can do this. Thanks |
#2
|
|||
|
|||
changing data in range of vlookup
That sounds like Data Validation. Select the cell, go into DataValidation
and either remove it or amend it. -- HTH RP (remove nothere from the email address if mailing direct) "Josie" wrote in message ... I have created a spreadsheet using vlookup & I now need to amend some of the information in the range of data, however, when I try to change this I get error message "The value you have entered is not valid. A user has restricted values that can be entered into this cell" Please can you advise how I can do this. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a chart based on a 2 dim data range dynamical in 1 d | Charts and Charting in Excel | |||
Extend a data range | New Users to Excel | |||
Data range properties | Excel Discussion (Misc queries) | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |