Some things you can try: 1. Try opening you file in Office Web Apps. http://skydrive.live.com/
2. Install open-source LibreOffice and try opening your file in that. http://www.libreoffice.org/ 3. Try opening your spreadsheet using a database connection (See below) 4. Try renaming your file to a ZIP extension. The workbook is stored as various files in a ZIP archive; most with binary data, though some things in XML format. Maybe if you create a new blank workbook saved as XLSB as a template (extension then changed to ZIP) you will have luck moving essential files (parts) of your source workbook to the new file's ZIP archive. Database connection elaborated: --------------------------------------------- Try creating QueryTables to retrieve data. You can independently access each worksheet, Excel Table and named range as if it were a database table. Text may get truncated in length, and the database drivers treat each column as if they were a fixed data type-- guessing at the type based on the first several rows. You can either use the ODBC driver (an older driver) or the Microsoft Access Database Engine OLEDB provider, which is a newer driver/framework. The ODBC method uses older drivers, at least in part. It has a tool, Microsoft Query, that allows you to visually design a database query against your Excel file, but for basic data recovery offers nothing special. It has an easy-to-use wizard called the "Query Wizard". The OLEDB/Microsoft Access Database Engine method is not difficult to utilize, but it is a little more technical. For this, you use the "Data Connection Wizard". As an aside, the version of SQL supported via OLEDB is enhanced and more standard compared to that provided via ODBC. Steps for using the newer OLEDB/Microsoft Access Database Engine method of creating a Query Table: 1. Install Microsoft Access 2007+ or the Microsoft Access Database Engine Redistributable (https://www.microsoft.com/en-us/download/details.aspx?id=13255). 2. Go to Ribbon, Data tab. 3. Click [Get External Data]. (Remainder of instructions in shorthand but detailed.) 4. From Other Sources > From Data Connection Wizard 5. DATA CONNECTION WIZARD 6. Other/Advanced 7. [NEXT] 8. DATA LINK PROPERTIES 9. Provider tab 10. Microsoft Office 12.0 Access Database Engine OLE DB Provider 11. [NEXT] 12. Connection tab appears 13. Data Source. Enter full path to file (C:\Path\To\File\Filename.xlsb) 14. [All tab] 15. Extended Properties. For XLSB file, type "Excel 12.0" without quotes. (It would be "Excel 12.0 Xml" for XLSX, "Excel 12.0 Macro" for XLSM, or "Excel 8.0" for XLS.) 16. [Connection tab] 17. [Test Connection] 18. if success [OK] 19. DATA CONNECTION WIZARD 20. Select a worksheet, table, or named range from the list. Worksheet names will include a $ at the end. It's possible to uncheck "Connect to a specific table" if you want to write an SQL query manually instead. 21. [Next] 22. if prompted to replace data connection file [YES] 23. [Finish] 24. IMPORT DATA 25. [OK] 26. Right click in the resulting query table. 27. Table > Unlink from data source (or Table > Convert to Range) To use ODBC/Microsoft Query: 1. Go to Ribbon, Data tab. 2. [Get External Data] 3. From Other Sources > From Microsoft Query 4. CHOOSE DATA SOURCE 5. Excel Files 6. Check "Use the Query Wizard to create/edit queries" if necessary 7. [OK] 8. SELECT WORKBOOK 9. select your file 10. [OK] 11. QUERY WIZARD - Choose Columns 12. If your worksheets do not appear in the list of "Available tables and columns". a. [OPTIONS] b. TABLE OPTIONS c. Check all options in the "Show" box. d. [OK] 13. Select a worksheet, table, or named range from the list. 14. [ > ] column headings should appear in "Columns in your query" box 15. note: do not continue to select other tables for your need. 16. [Next>] 17. QUERY WIZARD - Filter Data 18. [Next>] 19. QUERY WIZARD - Sort Order 20. [Next>] 21. QUERY WIZARD - Finish 22. What would you like to do next? prompt 23. Return Data to Microsoft Excel 24. [Finish] 25. IMPORT DATA 26. [OK] 27. Right click in the resulting query table. 28. 29. Table > Unlink from data source (or Table > Convert to Range) Good luck! It goes without saying, but backup valuable data frequently! - Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of B Sharma Sent: Wednesday, October 03, 2012 8:27 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ How to repair corrupted Excel file Dear Friends & Excel Experts, I have a Excel 2007 file of around 5 MB (which I saved in binary format. Last week it suddenly got corrupted and I am now unable to open it , While opening it says "The work book cannot be opened or repaired by MS Excel because it is corrupt" Please help me in this, its one of the important file of mine. Secondly, please also tell me what are the risks of keeping excel files in binary format. I save some file to reduce the file size.. I have tried, "Open & Repair" option. I have also downloaded some application which says that they can repair the excel file, but didn;t. Thanks in advance. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
