SOLVED

Excel workbook remains corrupted after trying all repair options

%3CLINGO-SUB%20id%3D%22lingo-sub-2809749%22%20slang%3D%22en-US%22%3EExcel%20workbook%20remains%20corrupted%20after%20trying%20all%20repair%20options%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2809749%22%20slang%3D%22en-US%22%3E%3CP%3EIdeapad%20Laptop%2FWindows%2010%20Home%20version%2020H2%3C%2FP%3E%3CP%3EMicrosoft%C2%AE%20Excel%C2%AE%202016%20MSO%20(Version%202109%20Build%2016.0.14430.20154)%2032-bit%3C%2FP%3E%3CP%3EExcel%20tab%20accidentally%20closed%20by%20action%20on%20another%20tab.%20Have%20tried%20all%20repair%20options%20I%20could%20Google.%20Online%20free%20repair%20options%20all%20seem%20to%20lead%20to%20payment%20requests-%20as%20a%20pensioner%20trying%20to%20avoid%20payments!!!%20-%20could%20I%20trouble%20someone%20who%20can%20repair%20for%20me%20please%3F%20I%20would%20be%20so%20grateful.%20Many%20thanks%20-%20Roger%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2812120%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20workbook%20remains%20corrupted%20after%20trying%20all%20repair%20options%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2812120%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1174574%22%20target%3D%22_blank%22%3E%40RogWyer%3C%2FA%3E%26nbsp%3BHi.%20I%20downloaded%20the%20file%20(as%20it%20was%20an%20xlsX)%20and%20opened%20it%20using%20Data%3A%20From%20Text%2FCSV.%3C%2FP%3E%3CP%3ECopy%20and%20paste%20data%20to%20a%20new%20file%20to%20disconnect.%3C%2FP%3E%3CP%3EFormatted%20as%20table%3B%20Insert%3A%20Table%20for%20your%20convenince%20in%20managing%20the%20data.%3C%2FP%3E%3CP%3EIn%20case%20your%20version%20of%20Excel%20do%20not%20like%20Tables%2C%20it%20is%20also%20attached%20vith%20the%20data%20%22as%20a%20Range%22.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2812333%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20workbook%20remains%20corrupted%20after%20trying%20all%20repair%20options%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2812333%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1159986%22%20target%3D%22_blank%22%3E%40bosinander%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20much%20for%20your%20speedy%20response-%20very%20grateful%20and%20much%20appreciated.%20I%20do%20have%20one%20problem%20though%20probably%20due%20to%20my%20lack%20of%20skills%20but%20I%20tried%20to%20copy%20data%20from%20files%20you%20sent.%20When%20I%20pasted%20into%20a%20virgin%26nbsp%3B%20worksheet%2C%20whichever%20paste%20method%20I%20used%2C%20text%20came%20out%20concatenated%20in%20four%20rows.%20Is%20it%20me%20being%20silly%3F%20Roger%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Ideapad Laptop/Windows 10 Home version 20H2

Microsoft® Excel® 2016 MSO (Version 2109 Build 16.0.14430.20154) 32-bit

Excel tab accidentally closed by action on another tab. Have tried all repair options I could Google. Online free repair options all seem to lead to payment requests- as a pensioner trying to avoid payments!!! - could I trouble someone who can repair for me please? I would be so grateful. Many thanks - Roger

5 Replies

@RogWyer Hi. I downloaded the file (as it was an xlsX) and opened it using Data: From Text/CSV.

Copy and paste data to a new file to disconnect.

Formatted as table; Insert: Table for your convenince in managing the data.

In case your version of Excel do not like Tables, it is also attached vith the data "as a Range".

@bosinander 

 

Thank you so much for your speedy response- very grateful and much appreciated. I do have one problem though probably due to my lack of skills but I tried to copy data from files you sent. When I pasted into a virgin  worksheet, whichever paste method I used, text came out concatenated in four rows. Is it me being silly? Roger

@RogWyer Hi Roger. I wrote a longer answer before but it seems lost in cyberspace so I just attach two text files that should be possible to use. Open from inside Excel or copy and paste from notepad or similar text program.

One is csv and one is tab separated text.

best response confirmed by RogWyer (New Contributor)
Solution
Brilliant - thank you so much. To still have the data after all the time spent researching is a relief. You are so kind doing what you do to help people - thank you - Roger