Specialty Forums
Security and Virus
General Hardware
CPUs/Overclocking
Networking
Digital Photo/Video
Office Software
PC Gaming
Console Gaming
Programming
Database
Web Development
Digital Home

General Forums
Windows XP
Windows Vista
Windows 95/98
Windows Me
Windows NT
Windows 2000
Win Server 2008
Win Server 2003
Windows 3.1
Linux
PDAs
BeOS
Novell Netware
OpenVMS
Solaris
Disk Op. System
Unix
Mac
OS/2

Drivers
Driver Scan
Driver Forum

Software
Automatic Updates

BIOS Updates

My Computing.Net

Solution Center

Free IT eBook

Howtos

Site Search

Message Find

RSS Feeds

Install Guides

Data Recovery

About

Home
Reply to Message Icon Go to Main Page Icon

Excel 2003

Original Message
Name: Mike Finamore
Date: May 7, 2008 at 08:33:24 Pacific
Subject: Excel 2003
OS: Win XP SP2
CPU/Ram: P4-550 / 2 gb
Model/Manufacturer: 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


Report Offensive Message For Removal


Response Number 1
Name: DerbyDad03
Date: May 7, 2008 at 11:42:09 Pacific
Subject: Excel 2003
Reply: (edit)
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.


Report Offensive Follow Up For Removal




Use following form to reply to current message:

   Name: From My Computing.Net Settings
 E-Mail: From My Computing.Net Settings

Subject: Excel 2003

Comments:

 
  Homepage URL (*): 
Homepage Title (*): 
         Image URL: 
 


Data Recovery Software




Slow boot time

Trasnferring Documents from old HD

My k8T Neo-v usb's aren't working!

Date Modified = Date Created Time

system files on removable harddrive


The information on Computing.Net is the opinions of its users. Such opinions may not be accurate and they are to be used at your own risk. Computing.Net cannot verify the validity of the statements made on this site. Computing.Net and Computing.Net, LLC hereby disclaim all responsibility and liability for the content of Computing.Net and its accuracy.
PLEASE READ THE FULL DISCLAIMER AND LEGAL TERMS BY CLICKING HERE

All content ©1996-2007 Computing.Net, LLC