Dear All,
I've been troubleshooting this problem for 2 weeks now and still can't find the root cause. Anybody's help is much appreciated. Thanks in advanced!
Setup:
- I got 1 master excel file with 13 worksheets representing 13 cities
- Each city have it's own excel file which is updated by the person responsible on that city.
- The excel files are located in 1 server where I do the consolidation on my master excel file.
- Basically, each worksheet is linked to the excel file of one city 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. (I used "define name" function to identify the range of data i need)
What i tried:
- I recreated all the links, etc.. It worked in some of the worksheets but didnt work for others
- I made sure that all formats and queries of working worksheets are identical with the non-working ones.
- I search this forum, google and MS KB but no solution found.
- I tried on excel 2000, XP and 2003 and it has the same problem.
- I also tried to switch the query of working sheets and the non-working and the result seems to suggest that the problem is not on the query but on the data source.
Please help. Thanks!
I've been troubleshooting this problem for 2 weeks now and still can't find the root cause. Anybody's help is much appreciated. Thanks in advanced!
Setup:
- I got 1 master excel file with 13 worksheets representing 13 cities
- Each city have it's own excel file which is updated by the person responsible on that city.
- The excel files are located in 1 server where I do the consolidation on my master excel file.
- Basically, each worksheet is linked to the excel file of one city 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. (I used "define name" function to identify the range of data i need)
What i tried:
- I recreated all the links, etc.. It worked in some of the worksheets but didnt work for others
- I made sure that all formats and queries of working worksheets are identical with the non-working ones.
- I search this forum, google and MS KB but no solution found.
- I tried on excel 2000, XP and 2003 and it has the same problem.
- I also tried to switch the query of working sheets and the non-working and the result seems to suggest that the problem is not on the query but on the data source.
Please help. Thanks!