Pivot not reading text data from external source

[Siegfried Casar]

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]

Siegfried,

try changing the data in marca column to only one data type (either text or number).

[#3]

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.