mysterious sheet reference

[benalt]

Hello,

I was sent an Excel file and was curious as to how it worked. One of the cells has a pull down menu and when you make a selection, all the figures in a separate column change and the cells there all reference the 'Tables' table. E.g. =Tables!F3, but only one sheet is in the file and it isn't called 'Tables'. When I right click the sheet tab, the "unhide" option is greyed out so I don't think there are any hidden sheets called 'Tables' there. Where could this mysterious sheet be located?

Thanks,
Ben

[Andy Pope]

Sheet is probably very hidden

http://office.microsoft.com/en-gb/ex...010287459.aspx