Forum Discussion
Excel Official Tables
Hi All, Is it possible to get list of all the table names in an excel column without a macro? I am using macros currently, But need morer better thing if exists. Thanks
yugal40 You could consider PowerQuery. A very simple example in the attached file. Add a table anywhere in the workbook (or delete one). Press Refresh all on the Data ribbon,and the list of table names (the green one) is updated instantly.
putting a code of power query takes a lot of space in a workbook?
yugal40 Not really!
- Thanks