Computing.Net > Forums > Office Software > Excel 2003

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Excel 2003

Reply to Message Icon

Name: Mike Finamore
Date: May 7, 2008 at 08:33:24 Pacific
OS: Win XP SP2
CPU/Ram: P4-550 / 2 gb
Product: HP dc7100
Comment:

Faulting application EXCEL.EXE, version 11.0.5612.0, faulting module EXCEL.EXE, version 11.0.5612.0, fault address 0x000a9df2.


We have a client with a spreadsheet that crashes on Save / Save as or when
trying to break a link to another spreadsheet - both spreadsheets were
created with Excel 2003 SP2.

I f you copy each individual sheet (5 sheets) from Spreadsheet 1 to a blank
spreadsheet - new spreadsheet 1 (5 sheets) it's fine - Save / Save as.

The linked spreadsheet - Spreadsheet 2 works fine all the time when it's
linked to Spreadsheet 1 or not linked - Save / Save as.

As soon as the two are (new spreadsheet 1 and spreadsheet 2 ) linked and you
open the new spreadsheet 1 you get the message that "This workbook links to
other data sourses"

Update / Don't update / Help

Even if you don't Update the links when you Save / Save as / or try breaking
the link and Save MS Excel Crashes:

Microsoft Office Excel has encountered a problem and needs to close. We are
sorry for the incovenience. Debug does nothing - Send report - sends MS a
report -

I have tried different PCs and different versions of Excel 2000 /2003 - Same issue.

Mike



Sponsored Link
Ads by Google

Response Number 1
Name: DerbyDad03
Date: May 7, 2008 at 11:42:09 Pacific
Reply:

First, I assume that when you say "copy each individual sheet (5 sheets) from Spreadsheet 1 to a blank spreadsheet" you actually mean "copy each individual sheet (5 sheets) from Workbook 1 to a blank Workbook".

A workbook is a collection of worksheets.

With that assumption made, how are you copying the sheets - with a right-click of the sheet tab and choosing Move or Copy... or by copying the data by selecting all cells and doing a Copy/Paste?

Whichever method you're using, try the other. It sounds like you are copying the corruption from one workbook to the other workbook, so maybe switching to the other method won't.

Another thing to try is to copy the sheets one at time and then doing the Save. You might be able to narrow it down to the sheet that's causing the problem. Once you've done that, start copying the corrupted sheet in sections. If you are lucky, after a few tries you'll be able to narrow it down to the single cell that's causing the problem.

Been there...done that.


0
Reply to Message Icon

Related Posts

See More


excel error Excel 04: match column en...



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: Excel 2003

Excel 2007 data bars for Excel 2003 www.computing.net/answers/office/excel-2007-data-bars-for-excel-2003/9304.html

saving the 2003 excel file into excel1997 www.computing.net/answers/office/saving-the-2003-excel-file-into-excel1997/9804.html

Remove excel addin error www.computing.net/answers/office/remove-excel-addin-error/9132.html