Prev: Auto Fill Text Box
Next: Assign faceid to image on userform
From: Chris on 17 Dec 2009 07:30
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
From: joel on 17 Dec 2009 09:55

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

[url="http://www.thecodecage.com"]Microsoft Office Help[/url]

From: Chris on 13 Jan 2010 06:07
On Dec 17 2009, 2:55 pm, joel <joel.43c...(a)thecodecage.com> wrote:
> 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
>
> [url=&quot;http://www.thecodecage.com"]Microsoft Office Help[/url]

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
 | 
Pages: 1
Prev: Auto Fill Text Box
Next: Assign faceid to image on userform