Enforcing Links In Excel
 

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

Enforcing Links In Excel
 

If you have established links and you have not changed the file name each
time, just go to

Edit / Links

The option Automatic should be marked

Click on the button that says "Startup Prompt" right below automatic

choose the option "don't display the alert and update links

All you are seeing is the alert that there are links in the spreadsheet and
it is giving you the option to update. If you turn this off, you won't see
that anymore unless the file you are linking to is changed or the link is
somehow broken, then Excel will show you the error and you can go into links
the same way (Edit / Links)

Hope that helps ;O


"Groovy_Kincaid" wrote:

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