i have a sheet which pickup values from another excel file. example of a value of cell ='d:\[old.xls]Sheet1'!B6
When I open the excel file the program prompt me:
the worksheet contains links to other data sources
do you want to update the values?

i want a macro to again update the values of cells just like the values are updated when i open the file