Excel Update Error

Community Beginner ,
Jul 07, 2022 Jul 07, 2022

Copy link to clipboard

Copied

"please place the document again to reset the link"Screen Shot 2022-07-07 at 7.36.10 PM.png

 

First of all there are only 5 results in google! 

 

I just spent all day linking imported tables to indesign from excel so that it would be easier for me to make multi-ligual tags for products for different countries.

 

However, now I am adding new data to the excel sheet and I get this error....

 

 

Screen Shot 2022-07-07 at 7.39.03 PM.png

 

If I delete the new data that i typed into the excel and save this error goes away.

 

In the original file I was using A1:Y5

 

I want to add Z1:Z5 and it seems that I cannot without getting thi crazy error! What is this error? Why is it happening?

TOPICS
Bug , Feature request

Views

73

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Community Expert , Jul 08, 2022 Jul 08, 2022

Creative, but why do you not use Data Merge for this?? This is not what tables are intended for...

Anyway, as this is one table used over and over, the cell range changes for all instances where the table is used, hence the warning it seems.

You definitely should use Data Merge, not tables.

Likes

Translate

Translate
Community Expert ,
Jul 07, 2022 Jul 07, 2022

Copy link to clipboard

Copied

Looks like InDesign can not find the original file. Did you move it? Renamed it? Was it in a USB stick maybe etc.?

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Jul 08, 2022 Jul 08, 2022

Copy link to clipboard

Copied

The file was not moved or renamed. 

 

I made a 3 minute video of the issue. I appolgise there is no voice over. Please see link to YouTube below.

 

My goal with this whole file is that I will be able to update the excel sheet with various future language options to quickly and precisely made new tags for this product. 

 

I am not a master at making tables in InDesign so I made each page on indesign reference 5 seperate cells from the Excel Sheet. Here is a diagram.

 

InDesign Cell Ref Layout.png

 

I am just baffled by this error and it seems that the whole file is now "broken". 125 links is a tall order for time considering this was supposed to save time. This didn't happen until I added Z Column Data on the excel sheet. This video will quickly show you the workflow that lead to this issue. 

 

https://youtu.be/eOBTQClXfs0

 

Thank you to anyone for your time and help.

 

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Jul 08, 2022 Jul 08, 2022

Copy link to clipboard

Copied

LATEST

Creative, but why do you not use Data Merge for this?? This is not what tables are intended for...

Anyway, as this is one table used over and over, the cell range changes for all instances where the table is used, hence the warning it seems.

You definitely should use Data Merge, not tables.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines