Re: Excel 2000 file when opened in Excel 2003 generates errors?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Dave Peterson (ec35720_at_netscapeXSPAM.com)
Date: 12/24/04 

Date: Fri, 24 Dec 2004 09:07:05 -0600

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

Relevant Pages

  • Re: How to map a shortcut key to a routine in COM AddIn for Excel 2007
    ... It is a bit of hassle, though could easly read the xml from say a text file. ... I use a COMAddin shell template as the starting point for each new app I'm working on. ... That also means the if the dll is to cater for the Ribbon it means having different versions of the dll for 2000/3 and 2007+ (otherewise could simply set the reference to the lowest Excel version). ...
    (microsoft.public.excel.programming)
  • Re: I want to load data from excel to access using xml
    ... Excel's built-in XML export feature has an 'append' option. ... to be incolved in the code from excel at all? ... "John Nurick" wrote: ... create a macro that launches the VBA function. ...
    (microsoft.public.access.externaldata)
  • Re: How to map a shortcut key to a routine in COM AddIn for Excel 2007
    ... my own little app to put the xml and anything else into a resource file. ... have a common entry point into the COMAddin. ... You must set the ref to MSO12 and XL12 LIBs. ... Excel will adjust any version refs to the running ...
    (microsoft.public.excel.programming)
  • Re: Value Metadata
    ... I added the two xml files but when opened in Excel it was all rejected. ... I suppose if you only need to know if the file contains metadata, ... box has no formula in it - the cell seems to be value only. ...
    (microsoft.public.excel.programming)
  • Re: Help Editing an XML File
    ... Joe Fawcett (MVP - XML) ... Spanish using MS Excel. ... Writing the transformation may not be easy, ... Change the design of your existing XML to allow for multiple, ...
    (microsoft.public.dotnet.xml)