Excel 2007 crash on open

On Apr 1, 7:50 pm, PeeZed <Pee....TakeThisOut@discussions.microsoft.com> wrote:
> Kathy,
> You're not alone. I have a similar problem in Excel 2007. Two Excel 2003
> spreadsheets one with links to the other. When I open the destination file
> before the source file, Excel crashes as you described. When I open the
> source file first, Excel never crashes. I had a look at the links (data /
> edit links in the robbon). Nothing untoward there. It all worked perfectly
> well in Excel 2003.
> I don't have charts in my spreadsheets so that's probably a red herring. But
> both of mine have macros - and that's probably a red herring as well.
> Like you, I haven't worked out a solution yet (apart from opening both
> spreadsheets in the correct order.)
> Anyone out there who can help or is it a genuine bug that will need to await
> a Microsoft fix?
>
>
>
> "Kathy" wrote:
> > Using Excel 2007 but saving all files as 2003.  When I open a file with links
> > to other files and multiple charts, Excel crashes during the open
> > ("encountered unepected error and needs to close" error).  If I first open
> > the sheet I am linking to, sometimes it won't crash.  This is a big problem,
> > as I can't open the file to see what the problem really is (and what links I
> > have in there).  Anyone else experiencing something similar?
> > Thanks.- Hide quoted text -
>
> - Show quoted text -

Hi,

There is a tool called Advanced Excel Repair. I have used it to repair
many corrupt Excel xls files on my damaged disks successfully. Its
homepage is http://www.datanumen.com/aer/

Maybe you can have a try.

Alan

I am experiencing the same crash/error message when opening any file, and
even when just opening excel 2007 on its own. Office diagnostics can't find
anything wrong, and I've tried repair, as well as uninstall/re-install.

(Alan, please do not use my post as a chance to plug that program you've
been advertising in reponse to so many posts.)

"Kathy" wrote:

> Using Excel 2007 but saving all files as 2003. When I open a file with links
> to other files and multiple charts, Excel crashes during the open
> ("encountered unepected error and needs to close" error). If I first open
> the sheet I am linking to, sometimes it won't crash. This is a big problem,
> as I can't open the file to see what the problem really is (and what links I
> have in there). Anyone else experiencing something similar?
> Thanks.

Well, I've worked out my problem and not a particularly satisfactory
workaround - it does appear to be a bug in Excel.

What I did first was to upgrade all my spreadsheets to Excel 2007 format
with macros enabled (xlsm) to ensure I didn't have a 2003 / 2007
compatibileity issue. That didn't solve my problem.

I use the NETWORKDAYS worksheet function with the Holidays option in my
destination spreadsheet and the Holidays are set up in a separate source
spreadsheet (and displayed in ddd dd/mm/yyyy format).

Example of a statement causing the crash if my Public Holdays spreadsheet
"Public Holidays.xlsm" isn't opened first:
=NETWORKDAYS(A2,B2,'[Public Holidays.xlsm]SA Public Holidays'!$B$4:$O$104)

My current workaround:
Open a new worksheet in my destination spreadsheet, name it "SA Public
Holidays" and define links in every cell in that worksheet to equivalent
cells in "Public Holidays.xlsm". i.e. cell B4 is set as ='[Public
Holidays.xlsm]SA Public Holidays'!B4
etc. through to O104.

The following statement then works perfectly without Excel 2007 crashing
regardless of whether "Public Holidays.xlsm" is opened first or not:
=NETWORKDAYS(A2,B2,'SA Public Holidays'!$B$4:$O$104)

So, how do we alert Microsoft and have them fix the bug?

"Kathy" wrote:

> Using Excel 2007 but saving all files as 2003. When I open a file with links
> to other files and multiple charts, Excel crashes during the open
> ("encountered unepected error and needs to close" error). If I first open
> the sheet I am linking to, sometimes it won't crash. This is a big problem,
> as I can't open the file to see what the problem really is (and what links I
> have in there). Anyone else experiencing something similar?
> Thanks.

I have exactly the same problem...!

MS should provide a fix soon...

"Kathy" wrote:

> Using Excel 2007 but saving all files as 2003. When I open a file with links
> to other files and multiple charts, Excel crashes during the open
> ("encountered unepected error and needs to close" error). If I first open
> the sheet I am linking to, sometimes it won't crash. This is a big problem,
> as I can't open the file to see what the problem really is (and what links I
> have in there). Anyone else experiencing something similar?
> Thanks.

We have the same problem, not just individually but many people in my company
are experiencing the same issue. We've discovered that it's easiest to open
the files you are linking to first, then open your file. This prevents the
crash on MOST occasions, but not all. Most of our issues occur when we've
linked to a .xlsm file.

I agree... MS needs to fix this. We've all upgraded to 2007 and been
instructed to convert our files to 2007, but with this problem, I believe
it's easier to leave them all in the previous versions.

We are having the same problem and wonder if MS is working on fixing it...
One strange thing is that our System Admin has no problems with the same
files that crash our Excel sessions...

"PeeZed" wrote:

> Well, I've worked out my problem and not a particularly satisfactory
> workaround - it does appear to be a bug in Excel.
>
> What I did first was to upgrade all my spreadsheets to Excel 2007 format
> with macros enabled (xlsm) to ensure I didn't have a 2003 / 2007
> compatibileity issue. That didn't solve my problem.
>
> I use the NETWORKDAYS worksheet function with the Holidays option in my
> destination spreadsheet and the Holidays are set up in a separate source
> spreadsheet (and displayed in ddd dd/mm/yyyy format).
>
> Example of a statement causing the crash if my Public Holdays spreadsheet
> "Public Holidays.xlsm" isn't opened first:
> =NETWORKDAYS(A2,B2,'[Public Holidays.xlsm]SA Public Holidays'!$B$4:$O$104)
>
> My current workaround:
> Open a new worksheet in my destination spreadsheet, name it "SA Public
> Holidays" and define links in every cell in that worksheet to equivalent
> cells in "Public Holidays.xlsm". i.e. cell B4 is set as ='[Public
> Holidays.xlsm]SA Public Holidays'!B4
> etc. through to O104.
>
> The following statement then works perfectly without Excel 2007 crashing
> regardless of whether "Public Holidays.xlsm" is opened first or not:
> =NETWORKDAYS(A2,B2,'SA Public Holidays'!$B$4:$O$104)
>
> So, how do we alert Microsoft and have them fix the bug?
>
> "Kathy" wrote:
>
> > Using Excel 2007 but saving all files as 2003. When I open a file with links
> > to other files and multiple charts, Excel crashes during the open
> > ("encountered unepected error and needs to close" error). If I first open
> > the sheet I am linking to, sometimes it won't crash. This is a big problem,
> > as I can't open the file to see what the problem really is (and what links I
> > have in there). Anyone else experiencing something similar?
> > Thanks.