M
M Imran Buhary
Hi All,
I am trying to use the Import External Data function from the Data Menu.
I have one workbook which will import data from several source files in
different locations updated at different times. The objective is to bring
together all of those workbooks (or worksheets) in different folder locations
inside one workbook for easy reference. So I have created several worksheets
for each of the source file and use the External Data Import Function to
Bring them together to the reference file.
I have no problem in Doing the 1st Time Import, But it seems that the
function for the Refresh of Data (when any changes were made to the source
file) does not give results in all the cells. It refreshes data only in cells
where data existed at the time of initial import. The import function also
doesn't give me results in cells where there is a "funtion" in the source
file.
Can anyone tell me how to refresh the whole worksheet. So that i can see
actually a copy of the source file worksheets, in my reference file.
I am trying to use the Import External Data function from the Data Menu.
I have one workbook which will import data from several source files in
different locations updated at different times. The objective is to bring
together all of those workbooks (or worksheets) in different folder locations
inside one workbook for easy reference. So I have created several worksheets
for each of the source file and use the External Data Import Function to
Bring them together to the reference file.
I have no problem in Doing the 1st Time Import, But it seems that the
function for the Refresh of Data (when any changes were made to the source
file) does not give results in all the cells. It refreshes data only in cells
where data existed at the time of initial import. The import function also
doesn't give me results in cells where there is a "funtion" in the source
file.
Can anyone tell me how to refresh the whole worksheet. So that i can see
actually a copy of the source file worksheets, in my reference file.