Chris,

Thanks for resonding... When I test the data connections it works fabulous the problem is the next day when I open the spreadsheet it doesn't seem to work. Which is what I do not understand. How can it work one day but not the next?

"if you save an excel worksheet to XLSTART on the C drive microsoft office>office14>XLSTART files in that folder will start automatically with excel perhaps that may be a workaround for you."

I have to be honest here I am a newbie and I have no idea what you are talking about