Share via

Connection properties grayed out

Anonymous
2022-09-07T20:17:12+00:00

Hi I have this grayed out in a workbook that i inherited.

How do i enable this?

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-09-08T01:50:12+00:00

    Dear Maya,

    Good day! Thank you for posting to Microsoft Community. We are happy to help you.

    Per the description shared, I understand the problem facing at your end where the query properties are grayed out, and I would like to confirm some scenarios which will help us to better understand the situation and move further:

    1. If you click on the Queries & Connections, does it shows any error at the Queries tab or Connections tab?
    2. Can I know the Data Source used to get data into the Excel workbook?
    3. Screenshot of the Excel app Account page. Open the Excel app> Account> Take a screenshot of the Product Information and Version.
    4. Since you mentioned the workbook is inherited, can I know whether you are have access to the data source connected to the Excel workbook?

    We look forward to your response. Thanks for your cooperation.

    Sincerely,

    Mia | Microsoft Community Moderator

    Was this answer helpful?

    0 comments