I have Excel 2007 and am doing VBA code to access info in SQL Server on Windows 2000 machine.

I have many spreadsheets and they all ran fine. I used Enterprise Manager to update a table to exclude nulls from one field. After I did this all my Excel VBA programs timeout when they try to access that table. I changed the properties back so that it would include nulls and it still times out.

All the debug shows me is that it timed out and then it highlights this line in the code:
Set rs = con.Execute(sSql)

I am stumped. Any help you all can give me is greatly appreciated.

Thanks!