Jun 10 2019 09:01 AM - edited Jun 10 2019 09:03 AM
Hello!
I would like to provide a workbook to several team members with some data validation and vlookups that depend on data on a table. However, I do not want people to have access to the full table information. Is that possible at all?
I tried putting the table on very hidden sheet. That prevents the table from showing when trying to use Power Query from another file to extract the data from this file. However, the table name still shows on the dropdown list in the Names box on the left of the formula bar.
By knowing that the table exists and what its name is, I can use an array formula to extract the whole table to another book. I can also use VBA to list all the table names on the workbook.
Any help with this would be very much appreciated.
Thank you,
Celia Alves
Jun 11 2019 10:33 PM