Hello,
I'm working with an Excel 2003 file in Excel 2007 (at the moment, end use will be with 2003). I have a dynamic named range setup that looks like this:
='List Data'!$I$3:INDEX('List Data'!$I$3:$I$53, COUNTA('List Data'!$I$3:$I$53))
Right now there are maybe... 12 values in that column. Problem is, Excel is only recognizing 11 of them. It seemed to be working originally, when I just used $I:$I for the cell references... the existing values showed up in the other cells that use this list for in-cell validation. When I looked at the named range in the Name Manager, it showed a dashed line around the cells that it referenced. Then I added a value to the list... and that value didn't show up in the in-cell validation list. Checked in Name Manager - still outlined the same area, *not* including the new entry (much less the entire section from I3 to I53). I tried a few things, including F9 to recalculate and exiting and restarting Excel. No joy.
Then, at some point it just started working like it is supposed to... until I added another value to the list. Then it didn't show the newest addition again. I poked around on the 'Net and changed to the absolute cell reference ($I$3:$I$53) shown above, and it worked again. Until I added another value to the list. Now it doesn't show *that* new entry.
Any ideas as to what is going on here?
TIA,
Monte
I'm working with an Excel 2003 file in Excel 2007 (at the moment, end use will be with 2003). I have a dynamic named range setup that looks like this:
='List Data'!$I$3:INDEX('List Data'!$I$3:$I$53, COUNTA('List Data'!$I$3:$I$53))
Right now there are maybe... 12 values in that column. Problem is, Excel is only recognizing 11 of them. It seemed to be working originally, when I just used $I:$I for the cell references... the existing values showed up in the other cells that use this list for in-cell validation. When I looked at the named range in the Name Manager, it showed a dashed line around the cells that it referenced. Then I added a value to the list... and that value didn't show up in the in-cell validation list. Checked in Name Manager - still outlined the same area, *not* including the new entry (much less the entire section from I3 to I53). I tried a few things, including F9 to recalculate and exiting and restarting Excel. No joy.
Then, at some point it just started working like it is supposed to... until I added another value to the list. Then it didn't show the newest addition again. I poked around on the 'Net and changed to the absolute cell reference ($I$3:$I$53) shown above, and it worked again. Until I added another value to the list. Now it doesn't show *that* new entry.
Any ideas as to what is going on here?
TIA,
Monte