Try Edit, Links, Change Source.

--
Jim
"Jennifer" wrote in message
...
| I'm currently editing an excel file for my boss where I'm inserting a
bunch
| of VLookup functions in order for data to be automatically entered.
However,
| the file from which I'm getting the data is most likely in a different
spot
| on my computer than it is on my boss'.
|
| Will there be a way that I can change ALL of the VLookups at once to have
| the new file name once I transfer the file back to my boss?