Run the Linked Table Manager and refresh the path to the Excel file. It's probably still looking for the old link. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Bhupinder Sent: Tuesday, July 31, 2007 9:42 AM To: [email protected] Subject: [Access VBA Central] Excel sheet Refresh Problem
hi All, i am having some external data in excel sheet from MS Access. once i changed the path of the DB and updated the same in excel sheet. but its giving me problem when i press "Refresh All" button. it shows me the old path that it was referring earlier but i am not referring it any more. and if i click on "Refresh" it does not give me any problem. i am having multiple external data across sheets. pls give me some solution. Bhupinder [Non-text portions of this message have been removed]
