Allow copying of tables from Word into Excel tables (you can't do that to a merged cell)
Because of Excel's abysmal text processing functions, I frequently copy large tables from Excel sheets into Word flies. After translating the text, I copy them back to Excel. I'd like to copy entire tables into the original Excel cells, but I get two really stupid messages.
"The data you're pasting isn't the same size as your selection. Do you want to paste anyway?"
After clicking OK:
"We can't do that to a merged a cell."
This happens despite the fact that the content was copied out of those exact same cells.
Make it so that I can copy a table from Excel to Word and back again, regardless of whether cells are merged.
If you can't do that, fix the error messages to say so from the start. Or is the second message the punch line in some puerile programmer joke?
Think this is probably more to do with how Word treats tables... by the time you paste it back into Excel it is no longer the same shape you started with.