Hi,
I am enclosing a file...which has extensive data. Now I am unable to open,, It gives irrepairable error message. can you help me in recovering this file ? I am not sure about the possible mistake I did while working on this...Please help..
Thanks
Shadmani
I had no trouble opening and saving it. Check out the attached file.
abousetta
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
Opened OK for me in Excel 2007 but crashed when I tried to save it as .xls file.
However, Excel recovered and recovered the file ... which is attached
See if this works for you.
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hi TMShucks,
I opened it fine in 2010, but it didn't update the links (probably a different file).
They seem to be improving the recovery system from version to version of office.
abousetta
When I opened the file, I had the option to (try to) update the links, which I didn't do as I don't have the linked file.
Other than that, one of the sheets had some filters which I cleared before saving the file and re-posting it.
Regards
It opens fine in 2010. Saving to 2003 seems to have probems with Data Validation Rules
Try opening with Open Office
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Ahhh ... just tried to open the file in 2003 and it won't/can't recover it.
I suppose we could just save it as .xlsx and hope the converter would cope?
No input from OP yet.
Regards
I don't have access to Excel '03, but no problems from my end opening in Excel '10 or open office.
abousetta
Sorry Guys...Could not access my internet..
Thank you for all your support & help.
I tried to download....but unable to open it..
Regards
mani
I've saved the file as an .xlsx type.
See if you can open it and if the converter can cope with it.
Regards
As all others have said the file opens in 2007+ versions and open office.
The problem seems to be with links to workbooks, are they shared over a network?
Try opening the related files before you open your workbook, leave them open and then open the corrupted file.
If that fails, and I suspect it will, and you don't have access to a higher level of excel, this file might be the best you will get.
(Formulae and links have been removed and cleaned.)
The formulae you had were rather random and the validation seemed irrelevant to the sheets.
I'm possibly wrong, but the application of any formula certainly needs revising.
Here are the named ranges that are missing in the attached workbook
Name:= Colour_Story
Refers to:=
Name:= Hub
Please Login or Register to view this content.
Refers to:=
Ask ChakrabartyR to help in restoring any essential missing linksPlease Login or Register to view this content.
This file opens on my 2003 and earlier machines.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks