Excel 2016 Tables do not "copy down"

Ever since Excel 2007, I've been able to copy content into the first cell of a blank table, and ALL of the content became part of the table. Now in 2016, this no longer happens. When you copy content into the first cell of a table, only the first row of the content is included in the table. The rest of the content is copied UNDER the table and is not part of the table.

This new "feature" has broken a lot of legacy code. I found a "work around" (it's a quality product when you have to work around the way it is designed to function) : you have to "seed" a value in the blank table, then you can copy content into the table and it will be accepted.

A coworker of mine is having the same issue also since "upgrading" to Excel 2016. Are any others seeing this behavior? Is there a more sophisticated "work around?" or do we wait until 2019 for a fix?

Run the test macro. For 2013 and below, do you get a full table on the current sheet? For 2016 do you get a full table or a table with just one row and the rest of the content underneath? Now uncomment the line in red and run it again.

Please Login or Register  to view this content.

Hmm, it works for me either way. Excel 2016 (x64), Windows 7.

I assume you've done all the usual trouble shooting?

1. Repair Office installation.
2. Fully uninstall Office, perform registry clean up along with any local folders. Then do clean install of Office.

Not sure if it will do anything, but test below as well.

Please Login or Register  to view this content.

Oh one more thing.

Have you checked Options->Proofing->AutoFormat As You Type ?

0.JPG

On the one more thing: yes, I did check that (very intuitive place that it is hidden). However, there is also this. If those were not checked then tables with data in them would not expand either.

As for the re-install. I have a coworker with the same issue. Both of us have recent installs of Office 2016. In my case, it's on a new computer - a couple weeks old.

I tried copying to cell(1) with the same results.

I've cross posted this to the Microsoft Community - I wonder how many "me toos" I'll get. https://answers.microsoft.com/en-us/...7-c7eb49550e7b. This seems like the kind of issue they deal with.

I suspect that this issue has something to do with the way I clear the tables. I found that if I select all rows and Delete->Table Rows, I get the problem. (This is what my ClearTable code does). If I select all the rows and delete the sheet rows, I don't get the problem. However, that's still not a good solution as it does not fix legacy code, and I may have tables to the left and right of the table I am trying to clear (I can only think of one application where I did that).

I also have to try this at home. I have a 365 subscription and it might work differently since I've "heard" that 365 Office 2016 is nearly Office 2019.