Excel is waiting for another application to complete an OLE Action . . . No it isn't . . . Or is it

%3CLINGO-SUB%20id%3D%22lingo-sub-2890402%22%20slang%3D%22en-US%22%3EExcel%20is%20waiting%20for%20another%20application%20to%20complete%20an%20OLE%20Action%20.%20.%20.%20No%20it%20isn't%20.%20.%20.%20Or%20is%20it%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2890402%22%20slang%3D%22en-US%22%3E%3CP%20class%3D%22%22%3E%3CSTRONG%3EKit%3A%3C%2FSTRONG%3E%20Surface%20Laptop%204%2C%20Windows%2010%2C%20Excel%20365%20(No%20Add-Ins%20are%20enabled%2C%20%22Ignore%20other%20applications%20that%20use%20DDE%22%20is%20ticked).%3C%2FP%3E%3CP%20class%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3E%3CSTRONG%3EStorage%20location%3A%3C%2FSTRONG%3E%20Local%2C%20Network%20shares%20both%20NetApp%20and%20Windows.%3C%2FP%3E%3CP%20class%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3EI've%20created%20a%20blank%20excel%20file%20(no%20links%2C%20formulas%20or%20macros)%2C%20and%20populated%20millions%20of%20cells%20with%20the%20word%20%22Testing%22%20to%20create%20a%20simple%20file%20(test.xlsx)%20that%20is%2050MB.%3C%2FP%3E%3CP%20class%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3EStored%20locally%20on%20the%20C%3A%5C%20Drive%20-%20it%20opens%20fine.%20Stored%20on%20a%20network%20drive%2C%20I%20need%20to%20click%20OK%20to%20%22Excel%20is%20waiting%20for%20another%20application%20to%20complete%20an%20OLE%20Action%22%20several%20times%20before%20it%20eventually%20downloads%20and%20opens.%3C%2FP%3E%3CP%20class%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3EI%20understand%20it%20takes%20longer%20top%20open%20a%20file%20from%20the%20network%2C%20but%20%3CU%3E%3CSTRONG%3Ewhat%3C%2FSTRONG%3E%3C%2FU%3E%20is%20this%20message%20for%20and%20what%20is%20it%20really%20waiting%20for%3F%20The%20file%20only%20contains%20cells%20with%20the%20word%20%22testing%22.%20If%20I%20delete%20some%20cells%20to%20make%20the%20file%20smaller%2C%20eventually%20it%20doesn't%20happen.%20It's%20just%20something%20that%20happens%20when%20the%20file%20is%20saved%20on%20the%20network%20and%20is%20over%20a%20certain%20size.%3C%2FP%3E%3CP%20class%3D%22%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3EThe%20problem%20is%20that%20users%20often%20click%20%22OK%22%20a%20couple%20of%20times%2C%20then%20click%20%22CANCEL%22%2C%20assuming%20the%20file%20is%20corrupt%20or%20broken%20-%20and%20then%20get%20angry.%26nbsp%3B%20Telling%20users%20to%20sit%20there%20constantly%20clicking%20%22OK%22%20until%20the%20file%20eventually%20opens%20is%20surely%20not%20the%20way%20forward.%20Can%20this%20message%20be%20suppressed%20perhaps%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2890402%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Kit: Surface Laptop 4, Windows 10, Excel 365 (No Add-Ins are enabled, "Ignore other applications that use DDE" is ticked).

 

Storage location: Local, Network shares both NetApp and Windows.

 

I've created a blank excel file (no links, formulas or macros), and populated millions of cells with the word "Testing" to create a simple file (test.xlsx) that is 50MB.

 

Stored locally on the C:\ Drive - it opens fine. Stored on a network drive, I need to click OK to "Excel is waiting for another application to complete an OLE Action" several times before it eventually downloads and opens.

 

I understand it takes longer top open a file from the network, but what is this message for and what is it really waiting for? The file only contains cells with the word "testing". If I delete some cells to make the file smaller, eventually it doesn't happen. It's just something that happens when the file is saved on the network and is over a certain size.

 

The problem is that users often click "OK" a couple of times, then click "CANCEL", assuming the file is corrupt or broken - and then get angry.  Telling users to sit there constantly clicking "OK" until the file eventually opens is surely not the way forward. Can this message be suppressed perhaps?

0 Replies