Forum Discussion
Excel workbook link problem with text data
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 whic...
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