Hello, I appreciate the response and the work that you put into this. I’m having problems with this though and I don’t know if I’m doing something wrong. Should I be able to add data in column A and in column B right click and refresh? When I do this I get an error that says “Initialization of data source failed. Check the database server or contact your database administrator. Make sure the external database is available, and then try the operation again. You see this message again a, create a new data source to correct the database.” I have tried to research this but I can’t figure this out. I am using Excel 2010 if that matters. Thanks