In the past, I was able to copy blocks of rows and columns in Excel and then highlight my table cell blocks in InDesign and paste the new data right into the table. I tried to do this today, and the only thing that would paste was the first cell in InDesign (the other copied cells would not paste). I ended up pasting the Excel data in InDesign as a separate text block, then converting the copied table to text and pasting it into the formatted InDesign table.
This work-around is OK, but I'm curious what I'm doing wrong. I checked to see if there were contingent cells in either Excel or InDesign, and they weren't.
The range of copied cells is probaly larger than the number of cells available in the table that you are pasting into. So if you copy a 5 column by 4 row selection, you will not be able to paste this into a table that has only 4 columns by 3 rows.
No, I finally figured it out. I could not copy and paste because I upgraded my Excel program to version 14.1.4 (part of the Microsoft Office 2011 suite). When I re-saved the files from their default version to an Excel 97-2004 Workbook, everything copies and files re-link.
Europe, Middle East and Africa