Excel Automation: This action will cancel a pending refresh data command. Continue?

If you’re automating Excel via the ActiveX/COM objects, you may notice an annoying msgbox saying

This action will cancel a pending refresh data command. Continue?

you can disable it via

Application.DisplayAlerts = False

Or if you’re actually instantiating an object from outside of Excel VBA (e.g. from a C# console app), try

Excel.Application ExcelObj = new Excel.Application();

ExcelObj.DisplayAlerts = false;
0

Written by Ben Strackany -- January 25, 2005

Ben worked for a variety of tech startups in Chicago before moving to Portland and starting DevelopmentNow in 2005. When he's not herding cats, stirring pots, and taking names, he enjoys drinking coffee while irritating the studio audience with bad puns.