Forum Discussion
Pivot not reading text data from external source
I have some data that contains text and numbers (marca column).
When showing marca in a pivot (file section) that is read from same file, all data is displayed.
When showing marca in a pivot (file section) that is read from an external file, only number data is diplayed; where text should be displayed, shows blank.
I am attaching 2 files:
File 1: has two tabs, one with data and the other one has a pivot that reads form data tab.
File 2: has one tab that reads from file 1 data.
2 Replies
Siegfried,
try changing the data in marca column to only one data type (either text or number).
Hi Detlef.
I changed format, first to number, and no changes on file 2.
Then I changed format to text and finnally I got all data, however, I cannot sort it as numbers.
