Skip to main content
A
Anonymous
March 8, 2017
Answered

Maintaining Color Formatting in a Table Linked from Excel

  • March 8, 2017
  • 1 reply
  • 2650 views

Experts: I am formatting multiple files with many tables that must be pulled directly from Excel in order to ensure updated and accurate numbers. I used the file -> place command and then selected "formatted table". The initial placement worked well, but now I am having major troubles with the table formats. After updating, the shade of grey that was used in the tables has changed in some places, resulting in a mess of mis-matched tables and shades of grey. The Excel files are still properly formatted with all of the correct colors that InDesign should be pulling but is not. Does anyone know why this is happening?! I need a solution that does not include manually going through and changing the colors in InDesign or re-placing the files given that I have an extremely tight deadline.

This topic has been closed for replies.
Correct answer Eric Dumas

Will I then need to update the colors in each individual table or should adding the swatch as RGB automatically update the issues with the tables?


If you double-click on a swatch colour, you should be able to change each of them to RGB which will update your document.

Otherwise, you can create the additional swatches, then delete the 'old' one from the swatch palette confirming the replacement with the new one. This is a slightly longer process.

1 reply

BobLevine
BobLevine
Community Expert
March 8, 2017

Version of ID? Version of Excel? Operating system? Before and after screen shots.

M
MargaretClark808
New Participant
March 8, 2017

InDesign CC 2017, Excel 2013, and Windows Operating System. Here are the before (lighter grey) and after (dark grey) issues (with purposely data removed/crossed out). Additionally, some of the tables have dark grey in spots where there was no fill at all before. There doesn't seem to be a rhyme or reason to the ones that are changing.

BobLevine
BobLevine
Community Expert
March 8, 2017

Here's a quick test. Enable separations preview and run your cursor over the grays. What are the percentages before and after?

Another test would be to add the colors to the swatches panel and see what they are.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices