Made a contact database that I cannot share.

I have a list of subcontractors for my job and each contact has the Business name, Address, Phone and Trade. On Sheet 1 I made a query using external data so when I select a trade from the drop down menu, it shows all of the subcontractors in said trade. It works very well on my computer, but when I go to share the file it does not work. I get the error

directory name "is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides."

The data is being pulled from sheet 3 of the same workbook as sheet 1. My objective is for guys in the field to be able to pull this up on site and find the subs that are in their area. From what I can figure it has to do with the connection string (I may be very wrong).

This Connection String theory brings up a couple questions:

1) is there a way to make the connection string reference sheet 3 within the workbook?
2) is there a way to make a dynamic Connection String in Excel 2007?

Thanks,

Sam

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.