• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit Search
0

Linked Excel sheet replacing cell content with '-1'

Explorer ,
Feb 05, 2023 Feb 05, 2023

Copy link to clipboard

Copied

Dear friends,

I linked an excel file in my Indesign file, but some explicit cells don't import correctly. The selected cell gets replaced with a "-1" in my Indesign file.

lukr69412519_0-1675620900704.png

lukr69412519_1-1675620923613.png

I have no idea why this happens and how to solve it. However it is fixed when I import it as a formatted table, but I need to remove all the style to fit it to the corporate identity.

Thanks already,
Luk

 

 

TOPICS
Import and export , Publish online , Sync and storage

Views

329

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
Explorer ,
Feb 05, 2023 Feb 05, 2023

Copy link to clipboard

Copied

I did find out it has something to do with the '=CONCAT' Excel function.

Votes

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
Explorer ,
Feb 05, 2023 Feb 05, 2023

Copy link to clipboard

Copied

Votes

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 ,
Feb 05, 2023 Feb 05, 2023

Copy link to clipboard

Copied

Here is the reason, but not solution:

https://community.adobe.com/t5/indesign-discussions/imported-excel-unformatted-table-text-based-form...

David Creamer: Community Expert, Adobe Certified Instructor, and Adobe Certified Expert (since 1995)

Votes

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
Explorer ,
Feb 05, 2023 Feb 05, 2023

Copy link to clipboard

Copied

Doesn't seem to have a logical cause, thanks for the information though.

Votes

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 ,
Feb 05, 2023 Feb 05, 2023

Copy link to clipboard

Copied

A workaround would be to copy the data with the formulas to a new work sheet, pasting values only. 
If you need an update, you update the original worksheet with the formulas and repeat.

David Creamer: Community Expert, Adobe Certified Instructor, and Adobe Certified Expert (since 1995)

Votes

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
Explorer ,
Feb 05, 2023 Feb 05, 2023

Copy link to clipboard

Copied

Yea, I'm wondering if it's easier to create table and cell styles, import it as a 'formatted table'(because then it works properly). 

Votes

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 ,
Feb 05, 2023 Feb 05, 2023

Copy link to clipboard

Copied

Table and cell styles are designed to work with an unformatted table. A formatted table would bring in all of the Excel formatting.

Votes

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
Explorer ,
Feb 05, 2023 Feb 05, 2023

Copy link to clipboard

Copied

Right, makes sense.

Votes

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 ,
Feb 05, 2023 Feb 05, 2023

Copy link to clipboard

Copied

Certainly, maintaining the Excel formatting is an option. You might have to play with the table and column widths a little because in my experience, Microsoft measures things differently than InDesign does. 

If you plan on commercially printing your document, you can run it through Acrobat Pro to convert Microsoft's RGB black to percentages of black-only (K).

 

David Creamer: Community Expert, Adobe Certified Instructor, and Adobe Certified Expert (since 1995)

Votes

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
Explorer ,
Feb 05, 2023 Feb 05, 2023

Copy link to clipboard

Copied

I'm better of styling the Excel file then, it's intended to print it over branded briefpaper. I do wonder why they closed the bug as 'fixed' when it's actually not.

Votes

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
Explorer ,
Feb 05, 2023 Feb 05, 2023

Copy link to clipboard

Copied

According to the vote reactions it should be fixed. I'm running the latest version and it does not.
https://indesign.uservoice.com/forums/601180-adobe-indesign-bugs/suggestions/31903918-import-xlsx-sp...

Votes

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 ,
Feb 06, 2023 Feb 06, 2023

Copy link to clipboard

Copied

Not fixed on my end using the latest versions of both.

I was able to import a formatted table and quickly remove any style overrides--then I could apply a regular table style. (I did not test with a linked Excel file to see what would happen during updates.)

 

David Creamer: Community Expert, Adobe Certified Instructor, and Adobe Certified Expert (since 1995)

Votes

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
Explorer ,
Feb 07, 2023 Feb 07, 2023

Copy link to clipboard

Copied

LATEST

The best thing to do in my experience is to import it as a 'formatted table' and style as much as you can in Excel. Table styles over a formatted table causes strange behavior sometimes. Indesign tables are sloppy, that's for sure. 

Votes

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