Is it true that in Excel 2007 you can't do list validation to a table on a different worksheet, only a named range that is not a table?
I enter a Source of
=Responses and it keeps complaining "The formula you typed contains an error."
On the worksheet where the table is, I click into the table, go to the Design ribbon, and in Table Name it says
Responses. If I open the Name Manager it says there is a named range called
Responses that refers to the proper range. What gives?