Create a dummy file in the same location.

Use that dummy file as the link.

Tell the users to edit|link|change source
(or edit|replace to modify the link)

after they've opened the workbook.



Larry M in NE wrote:

I want to include a formula with a link name in a file template that will be
used by others. The file name to be in the file name must vary each time a
new file is created and named from the template. Each file includes the
person's name and a month year indication i.e. larry082005.xls each file
must link the prior month. Suggestions?

--

Dave Peterson