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.
3 people found this helpful
If someone else ends up here after googling this issue, here is a working solution:
- Copy the info from Excel (you may need to Include Shift to copy data correctly).
- Paste it in a text editor. The text should be pasted as raw text without formatting. (I use Textwrangler, I haven't tried anything else.)
- Copy all text from the editor.
- Paste it in InDesign (eg by selecting the entire table and then paste). All format etc is kept.
I have used this on ID CS6.