Import external data into Excel
 

Trying to import data from excel file using query. Some columns returned
empty, while data exists in source, some return numbers in text format, thus
cannot be used for pivot tables. I checed "Preserve cell formatting" in
External data range properties, but it does not help.