Share via

Determine if Table/Query is a source

Anonymous
2022-12-22T12:50:34+00:00

I'm in the process of cleaning up, what I believe, are queries/tables that are no longer needed, but how do I determine if they are being used as a source to a table or query in another workbook?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-12-22T14:00:54+00:00

    Dear Mike,

    Good day! Thank you for posting your query in our community.

    Per your description, you want to check if the Table/Query is a source in other workbooks.

    Based on my research, currently, there is no built-in feature could meet your requirement(we can only open the workbook to check the existing source in this file now).

    And I will keep this thread open, so that other members in our community could share their ideas in this thread.

    Thanks for understanding.

    Sincerely,

    Jazlyn | Microsoft Community Moderator

    Was this answer helpful?

    0 comments
  2. Rory Archibald 18,965 Reputation points Volunteer Moderator
    2022-12-22T13:42:47+00:00

    Short of examining every other workbook, you can't.

    Was this answer helpful?

    0 comments