Datalink Table Headers and titles

[Anonymous]

I am trying to create a table using the annotate table data link method. It works fine except I can not get the formatting for the color correct. If you are linking to an existing xls spreadsheet, the option to choose and define the order for the data, title, and headers is greyed out and unavailable. My first row comes in and i can manipulate the data color to change it (even though it's actually the theaders) but i can change the other 2 types (header and title) and nothing happens. My assumption is that it's using the premapped settings and they're wrong. My actual data stays grey/default color and I  can not change it. But again my headers are actually premapped to the data cell style and i cant not change it. Thoughts? TIA.

TLDR; All data in linked table is using data cell style. How do i define the header row?

[pendean]

Can you share some actual files?

[Anonymous]

Sure see attached. Also included a screenshot so you can see the style vs table.

[vinodkl]

Hi,

When Linking the table make sure that you have the option "Use excel formatting" is unchecked, doing so the linked table would follow the table style.

This option would be hidden, and you might have not seen this and proceeded when data linking the excel.