Feb 14 2018
06:36 AM
- last edited on
Jul 25 2018
11:03 AM
by
TechCommunityAP
Feb 14 2018
06:36 AM
- last edited on
Jul 25 2018
11:03 AM
by
TechCommunityAP
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?
Feb 14 2018 07:21 AM
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.
Feb 14 2018 07:46 AM
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 - ...
Feb 14 2018 09:07 AM
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.
Feb 15 2018 06:07 AM
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