Excel 2007 crash on open

  • Thread starter Thread starter Kathy
  • Start date Start date
K

Kathy

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.
 
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,
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?





- Show quoted text -
Click to expand...

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.)
 
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?
 
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 said:
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 said:
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.
Click to expand...
Click to expand...
 
Does anyone know if Microsoft has acknowledged this as a bug and is there a
fix for it?
 
Back
Top