Hi All,
I am pretty amateur at Excel VBA, so please bare with.
I have an excel workbook, this contains lots of worksheets with live data in SQL.
The issue I have, is each worksheet is set to data refresh every 5 minutes, independently.
Sometimes when it refreshes, it will give an error about data, or a SQL deadlock etc, however, when you click ok, the excel is fine.
My question is, is there a way to suppress all error pops via VBA, without going through each worksheet and changing what I have done?
Ideally, there would be a script or setting I can use, that just suppresses all error messages/notifications, that I can slot into the workbook and it applies to all worksheets.
Please let me know if anyone requires further explanation.
Thank you in advance!
I am pretty amateur at Excel VBA, so please bare with.
I have an excel workbook, this contains lots of worksheets with live data in SQL.
The issue I have, is each worksheet is set to data refresh every 5 minutes, independently.
Sometimes when it refreshes, it will give an error about data, or a SQL deadlock etc, however, when you click ok, the excel is fine.
My question is, is there a way to suppress all error pops via VBA, without going through each worksheet and changing what I have done?
Ideally, there would be a script or setting I can use, that just suppresses all error messages/notifications, that I can slot into the workbook and it applies to all worksheets.
Please let me know if anyone requires further explanation.
Thank you in advance!
