Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem opening a file Dave Excel Discussion (Misc queries) 3 September 28th 07 06:37 PM
Serious problem when opening a file Dave Peterson Excel Programming 2 December 13th 06 08:13 PM
Opening problem! fmkugur Excel Discussion (Misc queries) 1 August 16th 05 04:43 PM
Problem opening a file AmyTaylor[_22_] Excel Programming 4 August 16th 05 12:36 PM
excel VBA problem - setting workbook as variable & opening/re-opening safe Excel Programming 1 August 20th 04 12:22 AM


All times are GMT +1. The time now is 08:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"