Hi All,

Again I have looked around the Discussion Groups and cannot find any topic
that may relate to what I am looking for.

I have a workbook for Bank Reconciliations. I have three reports that are
automatically drawn from our database and made into seperate Excel Workbooks.
These reports are detailed Local Currency Transactions, detailed Foreign
Currency Transactions and Exceptions between the GL and the Bank in both
currencies.

In the workbook in which my user does the reconciliations, I have created
macros that will do vlookups and index matches to the various reports. She
has a summary sheet that does vlookups to the Local Currency, she has a
summary sheet that also does the vlookups to the Foreign Currency and another
sheet that will do the Index.

When these reports are produced, they are always saved as:

Current Week Local Currency.xls
Current Week Foreign Currency.xls
Current Week Exception.xls

....and these reports are always saved to the same network location.

My question becomes this:

Everytime I open a reconciliation workbook, Excel asks me to update the
links. Is there a way to have Excel to automatically point to these files on
the network without having to "manually" (for a lack of a better term) point
to these files every time?

Thanks