Finding Data Tables

[bourke123]

Hi All,

I've got a workbook that I've never (intentionally!) created a data table in, however it keeps trying to calculate' Data Table 1' (in the little calculating are at the bottom right). I've searched forums, and the only answers i've come across to finding data tables in workbooks are to search via name manager. I've done this, but can't find any table names. I've also searched the workbook for formulas with "table" included, however still can't find anything.

Is there another way to find data tables in a file?

Thanks so much!

 

[Anthony47]

If there is a structured table then there is a Named range with is name; if you press F5 (for "Go to") you should see a list of the available names, so you should see a "Data Table 1": click on the name and its area should get selected, and at that point you surely will realize what it is (maybe a query table)