have a look in the help index for INDIRECT which does not work on closed
workbooks.

--
Don Guillett
SalesAid Software

"dav135" wrote in message
oups.com...
Hi, I've created a spreadsheet which looks at another on the network to
distinguish if the open file is the latest version. (ie. a report is
sent as V1 and saved on the local computer of the recipient, meanwhile
the report on the network is udated to V1.1 - when the user then opens
the original V1 report, the spreadsheet simply advises that there is a
newer verion).

This works fine for me, until the email with the report is actually
sent. Before the email is sent, the formula looks like this:

=VLOOKUP(F11,'J:\Marketing_New\Management
Information\[Index.xls]Management Information Index'!$B:$G,3,0)

However, when the email is sent, this formula then changes to this:

=VLOOKUP(F11,'C:\Marketing_New\Management
Information\[Index.xls]Management Information Index'!$B:$G,3,0)

Only a very slight change, but the J drive changes to the C drive??
Any ideas how to get around this?

Many Thanks!!