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 which line and column can be text?
Hi,
I can't reproduce that. Since your connection is on the file
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
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.
