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.
North America
Europe, Middle East and Africa
Asia Pacific