Microsoft Excel

[James]

We are having the following problem with an Excel Spreadsheet.

One of the columns has a list box in it. So the only information that
can be selected is the items in the list box.

We now need to add information to the list box but can't see how the
data gets into the list box.

There are no hidden columns or rows from where the data can be called
from.

This works standalone and on the network.

Has anyone got any ideas?


Thank you

Kind Regards

James

 

[Bernie Deitrick]

James,

You may be using Data Validation's List feature, where the values
could have been entered directly into the list by the person
developing the spreadsheet.

HTH,
Bernie
MS Excel MVP