#1   Report Post  
JD
 
Posts: n/a
Default Corrupt Excell file

How do I un-corrupt an excel file?

I have tried removing some of the formatting, copy and pasted it into
another workbook to no avail.

JD
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Sometimes "roundtripping" it will work.

File|SaveAs
Choose "Web page (*.htm; *.html)

Then close that workbook and reopen the .htm(l) file and save it as normal
workbook.

Sometimes opening the file in OpenOffice and saving there will help:
http://www.openoffice.org, a 60-65 meg download or a CD

Sometimes opening in later versions and saving it there will help:

Sometimes copy|paste special|formulas to that new worksheet in the new workbook
would help.

But you may want to describe the corruption you're seeing--maybe it's just the
way excel works(???).


JD wrote:

How do I un-corrupt an excel file?

I have tried removing some of the formatting, copy and pasted it into
another workbook to no avail.

JD


--

Dave Peterson
  #3   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

JD,

Depending on your version of Excel, do File, and use the dropdown button in
the Open button, and click "open and repair." This is available in Excel
2002 (not sure about 2000).
--
Earl Kiosterud
www.smokeylake.com

"JD" wrote in message
...
How do I un-corrupt an excel file?

I have tried removing some of the formatting, copy and pasted it into
another workbook to no avail.

JD



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
Excel - Corrupt File / Urgent cpayne1757 Excel Discussion (Misc queries) 7 March 6th 07 03:20 AM
copy excell file to a CSV file and than to Notepad need to know bob Excel Discussion (Misc queries) 0 August 23rd 05 07:27 PM
Do I have a corrupt shared Excel 2003 File? sdsti Excel Worksheet Functions 0 August 23rd 05 05:25 PM
VBA for Excel 2000 file is corrupt nkamp Excel Discussion (Misc queries) 0 May 26th 05 03:37 PM
F7 in zip field when doing mail merge from excell file kshinn15 Excel Discussion (Misc queries) 0 April 16th 05 09:52 PM


All times are GMT +1. The time now is 10:19 AM.

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

About Us

"It's about Microsoft Excel"