Linking multiple tables (ranges) from one Excel sheet

New Here ,
Feb 09, 2021 Feb 09, 2021

Copy link to clipboard

Copied

Hi.

I've been searching both forums and youtube etc. for an answer but still can't figure this out. I have an Excel sheet containing a lot of small tables in confined ranges inside the same sheet. I am trying to link to the tables in a way that make InDesign detect (and add) rows and columns that are added to the tables in Excel. I cant figure out how to set this up. InDesign doesn't detect the new rows and columns, it only detects edits in text and numbers within excisting rows and columns. (I also cannot define an empty range or name a range in Excel and find that range when I place tables in InDesign.

Hope someone can help me with this. I am an InDesign novice.

Thanks.

Sep

TOPICS
How to

Views

115

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

Adobe Community Professional , Feb 09, 2021 Feb 09, 2021
Hi Sep, as far as I can tell there is no way of doing this. Perhaps others know a clever workaround? If this is an essential part of a workflow you should look into scripting the feature. Or hire a person who can do this. Also the Excel part: Detecting "single tables" in one Excel sheet without placing all the cells of a sheet. Regards, Uwe Laubender ( ACP )

Likes

Translate

Translate
Adobe Community Professional ,
Feb 09, 2021 Feb 09, 2021

Copy link to clipboard

Copied

Hi Sep,

as far as I can tell there is no way of doing this.

Perhaps others know a clever workaround?

 

If this is an essential part of a workflow you should look into scripting the feature.

Or hire a person who can do this. Also the Excel part: Detecting "single tables" in one Excel sheet without placing all the cells of a sheet.

 

Regards,
Uwe Laubender

( ACP )

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
New Here ,
Feb 17, 2021 Feb 17, 2021

Copy link to clipboard

Copied

LATEST

Thanks for your reply, Uwe.

Guess I just have to change my excel workflow then...

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