I've a requirement to get the dependency list of columns from one sheet to other. We have developed few workbooks and during the development phase lot of columns have been added. However in higher levels we are not using all those columns. Can I get this information thru DAP DB SQL to see which columns are used and which are not. That way I can drop those columns safely.
Can someone have this in SQL format?
Please sign in to leave a comment.