Share via

Table: Table Tools->External Table Data->Properties [grayed out???]

Anonymous
2016-05-04T17:08:05+00:00

Hello Everyone,

I have a dilemma that I have been trying to resolve. I have a few tables in my xl worksheet. I am trying to make sure every time the tables are updated they don't re-size. So I go to Design->External Table Data -> Properties. But 'Properties' is grayed out. I tried opening a new workbook and creating a table there and it is the same thing. Please help.

Thanks in advance.

1M

Microsoft 365 and Office | Excel | For home | 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
    2016-05-05T13:26:12+00:00

    Sure will. Thanks.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-05-05T08:13:38+00:00

    Hello,

    Welcome to Microsoft Community and thank you for posting your query.

    Since your issue is related to the Excel file using external table data, you may post your query in Excel IT Pro using the forum link below for better suggestion.

    https://social.technet.microsoft.com/Forums/office/en-us/home?forum=excel

    Hope this information is helpful. Please feel free to reply in case you face any other issues with Office in future.

    Thank you.

    Was this answer helpful?

    0 comments