Welcome Dialog

Welcome to the Community!

We have a brand new look! Take a tour with us and explore the latest updates on Adobe Support Community.


indesign changes with Microsoft excel values

New Here ,
Mar 21, 2021 Mar 21, 2021

Copy link to clipboard

Copied

Hi, please,

I need to automatically update the product price change in the indesign business catalog based on the value change in the Excel spreadsheet. When I change the price in Excel, I automatically want a change in the indesign.
Is it possible please and how?

 

Thank you, 

Jan Maghreb

TOPICS
Feature request, How to, Sync and storage

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

Adobe Community Professional , Mar 21, 2021 Mar 21, 2021
Indesign Preference > File Handling > Tick the box for ...Create links when placing text and spreadsheet files This links the excel file to your indesign page. When you update excel it auto updates indesign - just be sure to place in the excel file and click show import options to choose the fields you need placed at different places in indesign OR A data merge from an excel file (saved as a TXT file) works great for this - when you update the excel file simply save it out as a txt file and upda...

Likes

Translate

Translate
Adobe Community Professional ,
Mar 21, 2021 Mar 21, 2021

Copy link to clipboard

Copied

Indesign Preference > File Handling > Tick the box for ...Create links when placing text and spreadsheet files

This links the excel file to your indesign page. When you update excel it auto updates indesign - just be sure to place in the excel file and click show import options to choose the fields you need placed at different places in indesign

OR

A data merge from an excel file (saved as a TXT file) works great for this - when you update the excel file simply save it out as a txt file and update the previous file in indesign. This then updates the data you have placed into your indesign file

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
Enthusiast ,
Mar 21, 2021 Mar 21, 2021

Copy link to clipboard

Copied

One thing to note when linking an Excel spreadsheet—when updates are made in the spreadsheet, any formatting applied to the table in InDesign will be lost, so you'll want to create table and cell styles in the InDesign document so you can quickly reformat.

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
Adobe Community Professional ,
Mar 22, 2021 Mar 22, 2021

Copy link to clipboard

Copied

LATEST

And: The placed and linked table should sit in its own text frame ( story ).

Why? Because updating the linked Excel file will update the whole story.

That means: All added text before and after the placed Excel table will be erased with an update.

 

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