Solved

Damaged Excel File

Posted on 2011-09-24
2
290 Views
Last Modified: 2012-06-27
Dear Experts,

Desparate ! Kindly pull me out of here.

The attached file has stopped opening after my system suddenly hung a few days back. Prepared in Excel 2003, Password is 123456.
The last time file was opened properly before getting corrupted, my system got hung for some time and I had to shut the system directly, as it became non-responsive. After restarting when I opened the file, there was a strange thing I noticed about it. In the sheet named "FML" whenever I click on a cell containing validated Lists, the dropdown didn't contained the actual "Validation List". Instead it contained the options we see in the Filter Drop-down like "Sort Ascending, Sort Descending, (All), Top Ten, Custom, and the other items. It seemed as if the Filter Dropdown has overtaken the validation drop-down. To get rid of that I closed the file and restarted it but it started to gave me "read only" message. I closed Excel and then restarted it, but then the problem started. That is all I can tell you about it. Hope you can make something out of it
200102.xls
0
Comment
Question by:Kanwal_No2
2 Comments
 
LVL 38

Expert Comment

by:puppydogbuddy
Comment Utility
0
 
LVL 11

Accepted Solution

by:
jkpieterse earned 500 total points
Comment Utility
I'm sorry, but I think this file is really beyond repair. I tried:

- Open Office
- Direct cell link to the file
- Open and repair from 2003 and 2010
- A special tool that can open BIFF files (the fileformat of Excel 2003) and scan the content
None of these were succesful.
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now