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.