I have 4 named ranges that are used as sources for data validation lists. On
my worksheet, I have:
120 cells associated with a named range with 2 items,
60 cells associated with a named range that will have (on average) about 50
items
10 cells associated with a named range with about 20 items, and
60 cells associated with a named range containing about 4000 items

Does each data validation cell store a copy of the full list, as well as the
currently selected index value, or does the sheet (or entire workbook) share
one 'copy' of the named range, with each data validation cell only using as
much memory as it takes to store the index value for that cell?

I tried deleting sections of the data validation cells, but it didn't affect
the filesize, so either the file is storing undo information, or only the
index is stored and my lists are taking a lot more memory than I ever would
have expected.

I appreciate any information available on the use of memory by data
validation list cells based on named ranges.

Thanks!
Keith