When you create a table in Excel (I'm using Excel 2007) you can give it a name that shows up in the Name Manager dialog. However, the name has workbook scope. I'd like to have a table with a name scoped only to the worksheet if possible (just like named formulas/ranges can be). Is it possible?
For example, I'd like to have a table named 'Notes' on several different worksheets. Any given table would only be referenced from the worksheet it is actually on, and I'd rather not have to have each worksheet have a table with a different name. I'd also rather be able to see the table name grouped with other named formulas scoped to that worksheet when I sort by scope in the Name Manager dialog.
Best Answer
For completeness, I'm pretty sure the answer to my question is "no".
Of course I'll un-accept this and accept an answer that shows that this is wrong, or one that explains why it's right.