ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Links and Linking in Excel (https://www.excelbanter.com/links-linking-excel/)
-   -   Hyperlink selection generates error message (https://www.excelbanter.com/links-linking-excel/205669-hyperlink-selection-generates-error-message.html)

cwpauline

Hyperlink selection generates error message
 
I have an Excel spreadsheet with multiple tabs and hundreds of hyperlinks on
each tab. Randomly, when a user selects one of these links, an error is
generated; "Microsoft Excel is waiting for another application to complete an
OLE action."

Bill Manville

Hyperlink selection generates error message
 
I guess whatever application is required to open the document to which
the hyperlink points is held up while trying to open it. It might, for
example, be displaying a dialogbox which needs a response?

Which application is involved?
Does it always happen on the first invocation of that application
during a session?
Any other clues about when it happens?

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup


ShaneDevenshire

Hyperlink selection generates error message
 
Hi,

Try this it might work: Choose Tools, Options, General tab, check Ignore
other applications.

--
Thanks,
Shane Devenshire


"cwpauline" wrote:

I have an Excel spreadsheet with multiple tabs and hundreds of hyperlinks on
each tab. Randomly, when a user selects one of these links, an error is
generated; "Microsoft Excel is waiting for another application to complete an
OLE action."



All times are GMT +1. The time now is 10:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com