Hi Guys,

The scenario is i have a AccessDatabase with my information in, and i need to display the data in Excel to use as validation lists, so i Get External Data from the Access Database and then name the range (this data is refreshed each time i open the Excel file).

However both are Network files... and so if i open the file (excel) from another computer, the error i get is:

"Initialization of Data Source failed." It then attempts to refresh all but fails all....

Any ideas or help, i realise that i need the data connections in a similar location to the files but don't know how to go about doing this....

Thanks heaps in advance.
Happy new year.

Kaite