Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Missing Cloumn data when importing external data
I got 1 master excel file with 6 or 7 worksheets
- Basically, each worksheet is linked to the excel file via "Import External Data" function. - Each worksheet contains a table (6 columns and xx rows). The data are formatted numerically. What happened: - Some worksheets works perfectly when refreshing the data (all data needed in columns 1 to 6 are being refreshed). Problem: - In some of the worksheets, only column 1 to 4 and 6 are being refreshed properly. The data on column 5 are still empty. However, if I checked the source file (data), column 5 have a value. What i tried: - I recreated all the links, etc.. It worked in some of the worksheets but didnt work for others - I tried on excel XP and 2003 and it has the same problem. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to determine the cause of missing data after I importing data | Excel Discussion (Misc queries) | |||
Importing External Data | Excel Discussion (Misc queries) | |||
Importing External Data | Excel Discussion (Misc queries) | |||
Importing External Data | Excel Discussion (Misc queries) | |||
Import External Data is missing some data | Excel Discussion (Misc queries) |