Excel workbook link problem with text data

Copper Contributor

Hi, maybe it is meant to be like that, but I create a link between two excel workbook and I'm missing some data. Anyone knows why?

Do I have to respect a specific format? or should know better which line and column can be text?

Capture.JPG

4 Replies

Hi,

 

I can't reproduce that. Since your connection is on the file

Connection.JPG

which doesn't exist in my environment, I changed it on downloaded second file, from Data->Existing connection opened it and import data into the new table, it looks like

Connection02.JPG

other words all data from the pivot table in second file is here.

 

You may try to re-create your table the same way from the existing connection.

You actually have the same "problem", the column title which start in row 2 aren't shown past column B.

 

You should see HNK18-001 - Hnk18-001 rap - ...

Okay, I see now, sorry for misunderstanding.

 

So far I don't see a way how to fix that - Pivot Table has 2 rows as headers and linked table only one, converting is not under our control. Perhaps some workaround exists, need to play with that bit more.

ok thanks as least I know the limit of the Linked table.

I should check with Query or else than.

I actually need to copy specific sheet with all its formating