98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » OLE error
OLE error
Resolved · Urgent Priority · Version 2007
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Do a fast scrollIn big Excel databases with many records, you can move down thousands of rows super-fast as follows: hold down Shift then click on the scrollbar somewhere below the scrollbar handle. This will move you way down the sheet without your having to use the scrollbar up/down arrows or drag on the scrollbar handle. |