Error message when updating linked excel file import

[jesse63]

I was really looking forward to linking excel files to an annual report containing tons of tables. But all the preparations and good thoughts put into the project have been shattered, and I can't seem to figure out if it's a random thing or not:

Apparently, when I add or delete a row in the linked excel file, an error message appears when I update the link in Indesign stating "Cannot update link for xxxxxxx ... Please place the document again to reset the link". I don't get the message if I just edit the text or the figures.

The weird thing is, that when I opened another INDD document where the same linked spreadsheet also appeared (with modified number of rows), it updated fine, and the changes were reflected in the Indesign doc.

I use latest version of CC and Excel (Mac).

Hope to hear some thoughts from you knowledgeable people. It's frustrating. It's raining. It's monday.

Kind regards, Jes

[KNunnsey]

Disappointing this wasn't addressed. I'm having the same problem relinking a duplicate excel with new data. Exact same error.

[mikeklepacz]

I am having the same troubles right now. I just made 25 dog tags and used Excel to import the words and now I am getting this error and I want to pull my hair out.