Updating linked workbooks

rfinnegan

Board Regular
Joined
Mar 15, 2005
Messages
172
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
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Watch MrExcel Video

Forum statistics

Threads
1,118,536
Messages
5,572,774
Members
412,482
Latest member
arooshrana2
Top