Last year, while working on my GASB report I was able to import the fonts and "styles" applied by my accounting department directly into the InDesign file. This year when importing I am back to all "styles" being eliminated (color changes to gray, and fonts to default.) I have tried formatted, unformatted, and formated once, Tabbed will not work.
I have attached a portion of the files. Here along with a PDF version of the file. I used the "color" to verify that everything was brought in with the correct formats. When I open the file from 2019 today it works correctly in Indesign 16.1. However, when I tried to bring in files for the 2020 report the format and colors did not import. I could not see a difference in the excel file from last year to this year.
/t5/indesign/importing-excel-into-indesign/m-p/11972051#M42232920m ago20m ago
Copy link to clipboard
thank you for the files!
I had success to place all the Excel files formatted, that are stored in the 2020 folder.
2020 - e Pension Expenses-Outflows & Inflows.xlsx for example. I loaded your table and cell styles to a new document, selected your custom table style in the Table Style panel before placing, checked the option to see the Import Options and went this way: Formatted Table, Table Style: Your custom table style was auto-selected:
Hit OK and the result was this:
Another table, a larger one in file size, required a second step. This was 2020 - b GASB 68 Employer Allocations NO DECIMALS97-2003.xlsx. InDesign suddenly asked me if I want to speed up placing by changing "Formatted Table" to "Unformatted Table":
This dialog popped up. Where the default butten is set to "Yes". That means: The table will be placed unformatted!
Maybe you or someone else checked [x] Do not show again and hit the "Yes" button before?
That would mean that tables will be ALWAYS placed unformatted if a certain file size or complexity will provoke the message you disabled with the "Do not show again" checkbox.
So this is my assumption what went wrong on your side. If I deny this offer and press "No" the table is placed formatted:
So how can one bring back this dialog so that there is a chance to say "No"?
Go to your InDesign Preferences > General and press this button that says "Reset All Warning Dialogs":
All tests done with my German InDesign 18.104.22.168 on Windows 10.