Use the =cell function to add the
filename and path to a cell in your
worksheet.
If you use =cell("filename"), then
Excel will automatically insert the
full path (where it's been saved) and
the filename in that cell. For
more Excel tips, come to our
Excel 2007: Tips and tricks
session.