Updating path in defined name
 

I save my file to flashdrive via a macro. I notice when I try to restore the
file that various fields display #N/A results because the defined name has
changed. Is there a way to stop this from happening?

For example:
In my original document I have a defined name referring to another workbook
"Export Requests".
=OFFSET(Export_Requests.csv!$A$1,0,0,COUNTA(Export _Requests.csv!$A:$A),COUNTA(Export_Requests.csv!$1 :$1))
After I've saved to flash drive and copied to back to it's original location
the defined name refers to
=OFFSET('E:\Work\Export_Requests.csv'!$A$1,0,0,COU NTA('E:\Work\Export_Requests.csv'!$A:$A),COUNTA(Ex port_Requests.csv!$1:$1))