Importing Excel data after Excel file location changes in SAS EG

[TashaChapman14]

I'm still having some trouble getting used to the EG interface.

I have a project where I'm importing data from an Excel spreadsheet.  I recently moved some folders around on my LAN, so the Excel file is now in a new location.  Nothing else about the Excel data has changed.  However, when I try to open the "Modify Import Data" task so I can point it to the new location, EG freaks out, says that it can't find the data, and ends the process.

Are there any other solutions besides starting from scratch (and hoping that I remember all the settings from the last time I imported the data)?

[ChrisHemedinger · Accepted solution]

Right-click on the Excel file icon, select Properties.  Then select Change... to change the Excel file location to its new home.

[TashaChapman14]

Thank you, Chris!   Worked like a charm.