I have a spreadsheet which gets data from an Access database. Both files were
created on a portable hard drive with drive letter H. I now have the files on
my local disk C and, of course, the spreadsheet can't find the data because
it is looking for drive H.

Is there an easy way to change the path to the target file so the
spreadsheet can find the Access file?