Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 24th 04, 07:19 AM
Doug
 
Posts: n/a
Default Excel 2000 file when opened in Excel 2003 generates errors?

Ok - Im going crazy with this one.

When I open an Excel 2000 file in my Windows XP (sp2) Excel 2003 I get the
following....

"Microsoft Office Excel has encountered a problem and needs to close. We
are sorry for the inconvenience" which then generally butchers the file
(sometimes does almost ok in trying to "repair" it). I have tried this on
two separate computers with Excel 2003 - same results. NOTE: Excel 2000
opens it perfectly on third pc.

I have virus scanned, ad-awared, uninstalled Excel 2003 and reinstalled. No
luck. Sample file is available at
http://step.polymtl.ca/~ritz/charsheet/cs.htm then click download.

Suggestions??


--
..

  #2   Report Post  
Old December 24th 04, 08:53 AM
Frank Kabel
 
Posts: n/a
Default

Hi
does this happen with all files or only a single one. If the latter: sounds
like a corrupted file for me

--
Regards
Frank Kabel
Frankfurt, Germany

Doug wrote:
Ok - Im going crazy with this one.

When I open an Excel 2000 file in my Windows XP (sp2) Excel 2003 I
get the following....

"Microsoft Office Excel has encountered a problem and needs to close.
We are sorry for the inconvenience" which then generally butchers
the file (sometimes does almost ok in trying to "repair" it). I have
tried this on two separate computers with Excel 2003 - same results.
NOTE: Excel 2000 opens it perfectly on third pc.

I have virus scanned, ad-awared, uninstalled Excel 2003 and
reinstalled. No luck. Sample file is available at
http://step.polymtl.ca/~ritz/charsheet/cs.htm then click download.

Suggestions??



  #3   Report Post  
Old December 24th 04, 11:36 AM
Stephen Bullen
 
Posts: n/a
Default

Hi Doug,

When I open an Excel 2000 file in my Windows XP (sp2) Excel 2003 I get the
following....

"Microsoft Office Excel has encountered a problem and needs to close. We
are sorry for the inconvenience" which then generally butchers the file
(sometimes does almost ok in trying to "repair" it). I have tried this on
two separate computers with Excel 2003 - same results. NOTE: Excel 2000
opens it perfectly on third pc.

I have virus scanned, ad-awared, uninstalled Excel 2003 and reinstalled. No
luck. Sample file is available at
http://step.polymtl.ca/~ritz/charsheet/cs.htm then click download.


Sounds like a corrupted file. Try opening it in Excel 2002, saving as XML (with
a different name) and reopening it, then copy across the charts, VBProject etc
that saving as XML strips out.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk


  #4   Report Post  
Old December 24th 04, 02:01 PM
Doug
 
Posts: n/a
Default

I only have a cd of excel 2003 (ms office 2003). How do I obtain a copy of
excel 2002 to try that? I cant spend money on this.


"Stephen Bullen" wrote:

Hi Doug,

When I open an Excel 2000 file in my Windows XP (sp2) Excel 2003 I get the
following....

"Microsoft Office Excel has encountered a problem and needs to close. We
are sorry for the inconvenience" which then generally butchers the file
(sometimes does almost ok in trying to "repair" it). I have tried this on
two separate computers with Excel 2003 - same results. NOTE: Excel 2000
opens it perfectly on third pc.

I have virus scanned, ad-awared, uninstalled Excel 2003 and reinstalled. No
luck. Sample file is available at
http://step.polymtl.ca/~ritz/charsheet/cs.htm then click download.


Sounds like a corrupted file. Try opening it in Excel 2002, saving as XML (with
a different name) and reopening it, then copy across the charts, VBProject etc
that saving as XML strips out.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk



  #5   Report Post  
Old December 24th 04, 02:07 PM
Doug
 
Posts: n/a
Default


This file has seen many "versions" as its improved. the "old" ones can be
opened in 2000 and 2003 only lately the newer versions can still only be
opened in 2000, not 2003.

If it can still be opened in excel 2000 - how do we "find" this corruption?
Excel itself didnt really give a good clues....

"Damage to the file was so extensive that repairs were not possible. Excel
attempted to recover your formulas and values, but some data may have been
lost or corrupted."




"Frank Kabel" wrote:

Hi
does this happen with all files or only a single one. If the latter: sounds
like a corrupted file for me

--
Regards
Frank Kabel
Frankfurt, Germany

Doug wrote:
Ok - Im going crazy with this one.

When I open an Excel 2000 file in my Windows XP (sp2) Excel 2003 I
get the following....

"Microsoft Office Excel has encountered a problem and needs to close.
We are sorry for the inconvenience" which then generally butchers
the file (sometimes does almost ok in trying to "repair" it). I have
tried this on two separate computers with Excel 2003 - same results.
NOTE: Excel 2000 opens it perfectly on third pc.

I have virus scanned, ad-awared, uninstalled Excel 2003 and
reinstalled. No luck. Sample file is available at
http://step.polymtl.ca/~ritz/charsheet/cs.htm then click download.

Suggestions??






  #6   Report Post  
Old December 24th 04, 03:07 PM
Dave Peterson
 
Posts: n/a
Default

I don't own xl2003, but if you do File|saveas, do you see an option for "XML
Spreadsheet *.XML" in the save as type box at the bottom of the dialog?

If that didn't help, maybe opening the workbook in OpenOffice and saving there
would clean it up enough for excel to accept it.

http://www.openoffice.org, a 60-65 meg download or a CD

If the file is really important, there are commercial recovery services (costs
money!). I've never used it, but you might want to check into:
http://www.officerecovery.com

Doug wrote:

I only have a cd of excel 2003 (ms office 2003). How do I obtain a copy of
excel 2002 to try that? I cant spend money on this.

"Stephen Bullen" wrote:

Hi Doug,

When I open an Excel 2000 file in my Windows XP (sp2) Excel 2003 I get the
following....

"Microsoft Office Excel has encountered a problem and needs to close. We
are sorry for the inconvenience" which then generally butchers the file
(sometimes does almost ok in trying to "repair" it). I have tried this on
two separate computers with Excel 2003 - same results. NOTE: Excel 2000
opens it perfectly on third pc.

I have virus scanned, ad-awared, uninstalled Excel 2003 and reinstalled. No
luck. Sample file is available at
http://step.polymtl.ca/~ritz/charsheet/cs.htm then click download.


Sounds like a corrupted file. Try opening it in Excel 2002, saving as XML (with
a different name) and reopening it, then copy across the charts, VBProject etc
that saving as XML strips out.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk




--

Dave Peterson
  #7   Report Post  
Old December 24th 04, 05:57 PM
Doug
 
Posts: n/a
Default

Hmm Tried OpenOffice - it can open it. I then saved it, and tried to open
THAT file in excel 2003 - no luck.

sigh.


"Dave Peterson" wrote:

I don't own xl2003, but if you do File|saveas, do you see an option for "XML
Spreadsheet *.XML" in the save as type box at the bottom of the dialog?

If that didn't help, maybe opening the workbook in OpenOffice and saving there
would clean it up enough for excel to accept it.

http://www.openoffice.org, a 60-65 meg download or a CD

If the file is really important, there are commercial recovery services (costs
money!). I've never used it, but you might want to check into:
http://www.officerecovery.com

Doug wrote:

I only have a cd of excel 2003 (ms office 2003). How do I obtain a copy of
excel 2002 to try that? I cant spend money on this.

"Stephen Bullen" wrote:

Hi Doug,

When I open an Excel 2000 file in my Windows XP (sp2) Excel 2003 I get the
following....

"Microsoft Office Excel has encountered a problem and needs to close. We
are sorry for the inconvenience" which then generally butchers the file
(sometimes does almost ok in trying to "repair" it). I have tried this on
two separate computers with Excel 2003 - same results. NOTE: Excel 2000
opens it perfectly on third pc.

I have virus scanned, ad-awared, uninstalled Excel 2003 and reinstalled. No
luck. Sample file is available at
http://step.polymtl.ca/~ritz/charsheet/cs.htm then click download.

Sounds like a corrupted file. Try opening it in Excel 2002, saving as XML (with
a different name) and reopening it, then copy across the charts, VBProject etc
that saving as XML strips out.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk




--

Dave Peterson

  #8   Report Post  
Old December 24th 04, 08:03 PM
Richard
 
Posts: n/a
Default


If I may add some information to track this problem:
- The Excel file does not use VBA (No Macros at all !)
- I know for a fact that others can open it - not sure of their Excel
version though. I'll try to find out.

Most intriguing problem.
Is there a "compatibility" mode for Excel 2003 that can open "older" excel
files ?

Richard Taillon

"Frank Kabel" wrote:

Hi
does this happen with all files or only a single one. If the latter: sounds
like a corrupted file for me

--
Regards
Frank Kabel
Frankfurt, Germany


  #9   Report Post  
Old December 25th 04, 05:27 AM
Doug
 
Posts: n/a
Default


Quick update. on second pc - completely wiped away all MS office, rebooted,
full reinstall of 2003 office - (it asked for license key again) - reboot -
BEFORE even appliing office service patch - i tried and failed to open that
file.


"Doug" wrote:

Ok - Im going crazy with this one.

When I open an Excel 2000 file in my Windows XP (sp2) Excel 2003 I get the
following....

"Microsoft Office Excel has encountered a problem and needs to close. We
are sorry for the inconvenience" which then generally butchers the file
(sometimes does almost ok in trying to "repair" it). I have tried this on
two separate computers with Excel 2003 - same results. NOTE: Excel 2000
opens it perfectly on third pc.

I have virus scanned, ad-awared, uninstalled Excel 2003 and reinstalled. No
luck. Sample file is available at
http://step.polymtl.ca/~ritz/charsheet/cs.htm then click download.

Suggestions??


--
.

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
Trying to convert excel 2003 to pdf file? HELP abbroadus Excel Discussion (Misc queries) 1 December 15th 04 07:50 AM
Saving a Excel 97 file into Excel 2003 file Wil Excel Discussion (Misc queries) 1 December 13th 04 11:51 PM
Opening and saving Excel 2003 file from Excel 97. Rodrigo Excel Discussion (Misc queries) 2 December 12th 04 02:17 PM
Excel 97 chart opened in Excel 2003 - Source Data problem DHunt Charts and Charting in Excel 0 December 6th 04 08:05 PM
Excel 2003 "File Open": how keep folders at top with sort by Date. Aging Analyst Excel Discussion (Misc queries) 1 December 3rd 04 03:26 AM


All times are GMT +1. The time now is 02:59 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017