Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Import external data, data includes Excel function | Excel Worksheet Functions | |||
Excel External Data Selective Import. | Excel Discussion (Misc queries) | |||
Excel Row Limitation - Import External Data | Excel Worksheet Functions | |||
excel import external data wizard | Excel Discussion (Misc queries) | |||
How do i refresh external data import in excel in seconds | New Users to Excel |