Import external data into Excel

Y

Yurik

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Found few bugs in my daily routine of work in excel for MAC 0
Found few bugs in my daily routine of work in excel for MAC 0
Dealing with the error: unable to filter on excel hc home school 0
How to manage new data with external data in Excel? 1
How to import external data into excel? 2
Excel 2007 pivot table using analysis services cube as data source 0
Import External Data 3
External Data Toolbar permanently greyed out. 7

Top