I have one Excel workbook (Import.xls) with several sheets. It has about 50 links to other workbooks. Nearly all of the workbooks are .DBF files.
I use a macro (that was offered on this site) to update all links in the workbook, and it worked perfectly until last month. Now the links will not update. Although the macro seems to run fine.
If I open the excel file (Import.xls) first, then manually open ALL the linked files, it still will not update the linked data. However, if I manually open ALL the linked files first, then open the excel file (Import.xls) it WILL update all the linked data.
Is there something I'm missing? Do I need to change some settings somewhere?
I'm using Excel 2002
Thanks in advance
I use a macro (that was offered on this site) to update all links in the workbook, and it worked perfectly until last month. Now the links will not update. Although the macro seems to run fine.
If I open the excel file (Import.xls) first, then manually open ALL the linked files, it still will not update the linked data. However, if I manually open ALL the linked files first, then open the excel file (Import.xls) it WILL update all the linked data.
Is there something I'm missing? Do I need to change some settings somewhere?
I'm using Excel 2002
Thanks in advance