In the process of using U disk in peacetime, I always encounter various problems. Among them, the Excel file in U disk cannot be opened. It is also a phenomenon that is often encountered. At this time, we exclude the hardware of U disk and the cause of poisoning. Can you take a fix to save these important Excel files? Today, Xiaobian will share five ways to make it easy for you to solve such problems. 1. Conversion format method: Select the saved Excel XP workbook save format as SYLK. If you can open a damaged file and just can't do various editing and printing operations, then it is recommended to try this method first. 2. Direct repair method: The latest version of Excel XP in the "Open" window "Open" button has a direct repair of damaged files "Open and repair" function, this method is not suitable for conventional methods Open the damaged file. 3. Stealing the column: If you can't open the damaged Excel XP file, you can also try to open it with Word. The operation is as follows: (1) Run the Word program and select the Excel file to be opened; (2) If you use the Word program to open the Excel XP file for the first time, there may be “Microsoft Word cannot import the specified format. This function is not currently installed, is it now installed? & rdquo; prompt information, you can insert the Microsoft Office installation disk to install; (3) according to the prompts of the Word program to choose to repair the entire workbook or a worksheet; (4) First delete the corrupted data in the file, then move the mouse to the table, and then execute the “table →convert →table to text" command in the menu bar, and select the tab as the text separator. Convert the contents of the form to text and save it as a plain text file; (5) Run the Excel XP program to open the text file you just saved; (6) Then open the file according to the prompts of the "Text Import Wizard" The file is gone. The repaired worksheet is basically the same as the original worksheet. The difference is that all the formulas in the table need to be reset, and some texts are missing. The number format is lost. 4. Automatic repair method: This method is applicable to Excel XP program running faulty shutdown program or file damage caused by power failure. Re-run Excel XP, it will automatically pop up the "Document Recovery" window, and list all files that have been automatically restored in this window. Use the mouse to select the file you want to keep and click the arrow next to the specified file name and select “Open”.“Save as ”.“Show Fix” as needed. By default, Excel XP does not enable automatic repair, so preset: first click the <quo;tool →options" command in the menu bar, click “Save” tab in the settings box. Click the "Disable automatic recovery" checkbox to cancel, then select "Save automatic recovery information every X minutes" and enter the specified interval frequency, and finally click "OK" to complete the settings. If you have not automatically popped up the “Document Recovery” window, you can try to open the automatically recovered file manually: execute the “File → Open” command in sequence, and use the “Find Range” box to locate and open Excel XP. Save the folder of the auto-recovery file. If you don't know the location of the folder, you can view the path in the “Automatically restore file save location” box, then in the “File Type” dialog box, select “All” File (*.*)”options, and select the files to be restored, and finally click the “open” button to open the file for automatic repair. Summary: The above is the method that Xiaobian shares today. It can be analyzed according to several different situations, and then the specific solution is selected. Therefore, if you encounter the problem that the U disk Excel document cannot be opened later, you must analyze the problem. The reason is solved according to the specific plan, so that you can easily deal with the things you have encountered. This article comes from [System Home] www.xp85.com