Paul has attended:
Excel Advanced course
Access Intermediate course
Access Advanced course
OLE error
I've created a spreadsheet for around six colleagues to use, which contains a large number of hyperlinks to documents (Word and pdfs) held in a related folder structure. There is one copy of the spreadsheet only (as it is being frequently updated by me) and its opens as 'read-only' for the other users. However, there is a recurring problem in that it freezes sometimes when a user clicks a hypoerlink, and a message appears that 'another OLE process is running and not completed'. At this point the Excel seesion needs to be killed by our IT support. Any idea, please why, this problem is occuring, and how it can be resolved?
RE: OLE error
Hi Paul
Thanks for your question. If your colleague opens the file and it is not open elsewhere do you find it behaves as expected. In other words the error occurs when more than one instance of the document is open?
It may be that Excel is waiting for the other instance to be closed.
Let me know if this describes the situation.
Kind regards,
Andrew
RE: OLE error
Hi Andrew,
I did wonder if that might be the case, however all the linked documents are saved as 'read only' to edit. Should I save them as 'read-only' to open, would that solve the problem?
RE: OLE error
Hi Paul
That may solve the problem. Perhaps you can set up a small test with two documents and see if they behave correctly.
Let me know how you get on.
Kind regards,
Andrew
RE: OLE error
Hello Paul,
I am writing to check if the issue you mentioned on the Best STL forum was resolved.
If it was, great. If it wasn't, we can (continue to) help if you let us know by responding to this message.
Kind regards
Cindy
Microsoft Office Trainer
