ODBC Pivots error handling

**rudekid** · 06-16-2009, 02:06 PM

Hello all, I have searched and searched but cannot find an answer to the following.

I have a number of pivots connecting to an Oracle db to perform some queries. These work fine. The problem comes when I get a "would you like to replace the contents of cell......etc." message. Basically I always want to do that but can't figure out how to avoid the prompt which is an irritating one as it affects about 10 spreadsheets.

If I application.ScreenUpdating = False, it simply doesn't prompt me for the ODBC connection password and if I pass it in after the refresh it doesn't seem to do anything.

In addition I've tried clearing the contents and deleting of any alien formatting from the offending spaces but to no avail.

Ideally, I'd like to trap that specific error message but since I don't actually think it is an error message, (and I've searched for it too but can't find it) I can't figure out how to do it.

Is it possible and if so, how?

thanks in advance

**DonkeyOte** · 06-16-2009, 02:15 PM

What about disabling Alerts ?

Application.DisplayAlerts = False
...code...
Application.DisplayAlerts = True

(technically does not require reset but good habit to reset)

**rudekid** · 06-17-2009, 11:29 AM

I realise that my English was incomprehensible now so I guess you missed it but...basically I can't do that because if I do, the ODBC prompt doesn't appear which means I can't connect to the database which means the refresh doesn't happen and I'm back to square 1, (unfortunately).

My hope is - though this is a slim one - that that specific message is trappable but I haven't a clue as to what the name of it is, or indeed, whether it has one.