ole error

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » OLE error

OLE error

resolvedResolved · 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


 

Excel tip:

Do a fast scroll

In 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.

View all Excel hints and tips


Server loaded in 0.08 secs.