Query Failure - Disable "Something went wrong" error message

%3CLINGO-SUB%20id%3D%22lingo-sub-1956546%22%20slang%3D%22en-US%22%3EQuery%20Failure%20-%20Disable%20%22Something%20went%20wrong%22%20error%20message%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1956546%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20excel%20file%20that%20contains%20a%20macro%20that%20runs%20a%20query%20every%20five%20minutes%2C%2024%2F7.%20Every%20month%20or%20so%2C%20there%20is%20an%20error%20and%20the%20query%20fails%2C%20causing%20an%20%22Error%2C%20Something%20went%20wrong%22%20dialog%20box%20to%20show%20up.%20I%20think%20it%20asks%20if%20I%20would%20like%20to%20%22send%20a%20frown%22%20to%20Office%20support%2C%20or%20if%20I%20would%20just%20like%20to%20continue.%20This%20pauses%20the%20macro%20until%20the%20error%20is%20acknowledged.%20once%20it%20is%20acknowledged%2C%20the%20query%20continues%20to%20run%2C%20but%20it%20requires%20logging%20into%20the%20machine%20and%20manually%20acknowledging%20the%20error.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20does%20not%20matter%20if%20a%20single%20instance%20of%20the%20data%20is%20missing.%20The%20problem%20is%20that%20there%20is%20no%20data%20pulled%20until%20the%20error%20gets%20acknowledged.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20to%20disable%20these%20error%20messages%20in%20excel%20from%20popping%20up%3F%20I%20did%20not%20screenshot%20the%20error%20message%20unfortunately.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1956546%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1957222%22%20slang%3D%22de-DE%22%3ESubject%3A%20Query%20Failure%20-%20Disable%20%22Something%20went%20wrong%22%20error%20message%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1957222%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F891217%22%20target%3D%22_blank%22%3E%40Brad_Malik%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EIf%20I%20can%20recommend%20you%20add%20an%20MS%20Excel%20file%20(without%20confidential%20data)%20or%20the%20VBA%20code%20to%20your%20question%2C%20please%20no%20Picture.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EIt%20is%20much%20easier%20for%20someone%20who%20wants%20to%20help%20understand%20the%20subject%2Cproblem%2Cissue.%3C%2FP%3E%3CP%3EA%20win-win%20situation%20for%20everyone.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have an excel file that contains a macro that runs a query every five minutes, 24/7. Every month or so, there is an error and the query fails, causing an "Error, Something went wrong" dialog box to show up. I think it asks if I would like to "send a frown" to Office support, or if I would just like to continue. This pauses the macro until the error is acknowledged. once it is acknowledged, the query continues to run, but it requires logging into the machine and manually acknowledging the error. 

 

It does not matter if a single instance of the data is missing. The problem is that there is no data pulled until the error gets acknowledged. 

 

Is there any way to disable these error messages in excel from popping up? I did not screenshot the error message unfortunately. 

1 Reply

@Brad_Malik 

If I can recommend you add an MS Excel file (without confidential data) or the VBA code to your question, please no Picture.

It is much easier for someone who wants to help to understand the subject,problem,issue.

A win-win situation for everyone.

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)