Maybe you could just train them to use edit|links--
or use a macro to show that dialog:

Application.Dialogs(xlDialogOpenLinks).Show

Bobak wrote:

I have an Excel based reporting pack that is linked to an Excel file
containing the data for my reports. The name of the Excel data file is
changed at least twice a week and saved as a new version with a date suffix.

When i open my report file I want make the user select the most recent
version of the data file by changing links to this file and updating them. Is
there a way to do this?

--

Dave Peterson