Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
OLE Problem on Opening
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
OLE Problem on Opening
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/sh...d.php?t=163305 Microsoft Office Help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
OLE Problem on Opening
On Dec 17 2009, 2:55*pm, joel 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/sh...d.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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem opening a file | Excel Discussion (Misc queries) | |||
Serious problem when opening a file | Excel Programming | |||
Opening problem! | Excel Discussion (Misc queries) | |||
Problem opening a file | Excel Programming | |||
excel VBA problem - setting workbook as variable & opening/re-opening | Excel Programming |