Share via

Why is "get external data" grayed out within a table?

Anonymous
2012-04-04T04:16:29+00:00

I copied a table that was live linked to a web site and pasted only the values in a new worksheet.  The values pasted as a table.  I spent hours  trying to find the problem and cannot find a solution.  There are no connections in this new spreadsheet, which I transferred to a new book to be sure to isolate it from the original worksheet.

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

Answer accepted by question author

Anonymous
2012-04-04T17:40:54+00:00

You would not be able to insert any data inside a table.

You may have to convert the columns to range using the option ‘Convert to Range’ under ‘Design’ ribbon.

When you upload the data from a website and put it onto the table do you receive the below mentioned message

‘Your selection overlaps one or more external data ranges. Do you want to convert the selection to a table and remove all external connections?’

Was this answer helpful?

1 person found this answer helpful.
0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest