Forum Discussion
no links/VBA/addons, but : Microsoft excel waiting for another application to complete an ole action
I suspect there is a hidden link that you're not able to see via normal "Built in" Excel tools like DATA --> EDIT LINKS.
Sometimes these are buried in things like charts, that have been copied from one file to another.
Download an Excel add-in tool from Microsoft called "INQUIRE". That add-in allows you to interrogate the whole spreadsheet and reports ALL links. Then you should be able to remove them.
N
Thanks for suggestion however I want to keep links and I think there should be an option to terminate an OLE instance if a referenced application is closed for any reason and excel still needs it. I use Thomson Reuters add-in as an example and if I close TR for any reason and my spreadsheet has not finished use of the add-in it will just keep popping up the OLE waiting message ... basically hanging forever without possible remedy except ctrl/alt/del and terminate excel with possible consequence of losing work I have not saved. Re-starting the application add-in by the way does not fix the issue until excel is terminated and re-started. Very frustrating.
I have a non Thomson Reuters add-in that I guess hangs in the same way you mention. Very frustrating as it only does it occasionally. In my case I have to remember to either complete what I'm doing with the section I've added in and then switch to the add-in's main menu - this ensures it's in a steady state before I analyse my results or alternatively, I have to go to Excel's Data menu and disable the add-in temporarily whilst I do other analysis. Afterwards, I re enable the add-in and close the workbook.
I don't know any other way around this.
I guess the OLE does some kind of polling to ensure connection otherwise you could end up with broken links or worse calculations that are changed to values.
So there is no fix for this OLE error? Excel is literally doing this to me every day multiple times a day and it hangs my computer for about 3 minutes every time. It is extremely annoying.
Usually but not always when I add a sheet into my master spreadsheet or open an excel file from my google filestream. There has to be a fix, this is like... SUPER CLUNKY and its been driving me nuts for a year. I have been using the same excel spreadsheet for my business for over 18 years now and this never used to happen
Try removing all add-ins to see if that helps. If so, add them back (one at a time) to see if that points you to the issue. Otherwise, the only other suggestion I have is Open a fresh Excel workbook. Copy and paste each sheet into the new workbook then, turn on your add-ins. Save the file as filename.xlsb
See if that helps.
