OLE Problem on Opening

[Chris]

Hi All,

I have searched everywhere but cannot find a solution to this.

I have a c.6mb .xlsb file (c.60mb in .xls) which I am trying to open
in xl 2003. However everytime I try to open it it starts to convert
the file then just gives me the following warning "microsft Excel is
waiting for another application to complete an OLE action"

I have no other programs open when I try this, any help would be
greatly apprecaited.

Thanks.

Chris

 

[joel]

Are there macros in the workbook? First try to open the workbook with
macros disabled (using medium security mode) and see if the problem is
the workbook or the macros. If the macros are the problem you can put a
STOP in the Workbook open Function so you can debug the problem. After
you reach the Stop you can either single step or run to help find the
problem.

 

[Chris]

Are there macros in the workbook? First try to open the workbook with
macros disabled (using medium security mode) and see if the problem is
the workbook or the macros.  If the macros are the problem you can put a
STOP in the Workbook open Function so you can debug the problem.  After
you reach the Stop you can either single step or run to help find the
problem.

--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread:http://www.thecodecage.com/forumz/showthread.php?t=163305

Microsoft Office Help

Thanks Joel,

Sorry for the late reply, It ended up being a combination of both the
macro and number of formula. I have now sorted the macro and split the
workbook.

Thanks Again