Question Locked

Upgarde to 2007 - Original data connections between excel and access

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have just upgraded from excel 2003 and access 2000 to excel and access 2007 where I had automatic data connections including parametres setup to import data from access to excel. These data connections are no longer working since the upgrade to 2007 and on opening file with the data connections, it gets stuck on 'waiting for query to execute'. Does anyone have a solution please?

4 replies

by scott_heath

If the data import is kicked off by macros, which it probably is, then you need to change your macro security. It should be under Options, Security, Macro Security or something close to that. It is the one feature with Office 2007 I am least happy with. There is no more Enable and Warn, just Disable and Warn. You will have to set macro security to Enable for all macros.

Cheers,
Scott

Visit my blog @
http://scottisageek.spaces.live.com

by shaun_hawking

Thanks Scott, but I am actually not using a macro. I am using a miscrosoft query and odbc connection. I am slowly working around the problem by relinking the connection to the database. It is frustrating to say the least, as well as the macro problem you have menioned above.
Our IT department have informed me that there is no way around it.

Cheers

This discussion is closed to new replies.