Corrupt Excel Files which Say "Removed Feature: View from /xl/worksheets/sheet1.xml" after repair

Hi , I have multiple files which give the error which I mentioned on the title. Most of the time, Excel is able to fix the error but sometimes it can't. How I can I repair the file when it can't fix it itself. Is there a way to remove "View from /xl/worksheets/sheet1.xml" manually without using excel?

Thanks,
awesomejohn19Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
awesomejohn19Connect With a Mentor Author Commented:
Ok, I was able to solve this problem.

1. First Identify, which spreadsheets you need to save. I had lots of hidden worksheets from the past in the workbook. I only had 3 , i had to save.
2. In order to get the spreadsheet XML ids, you need to convert the file by renaming it .zip (so rename a.xlsm to a.zip). If you can't see the extension , go to organize ---> Folder and search options ---> view and untick "hide extensions for known file types.
3. After converting the file into .zip, you can see the xlm properties. go to file which is named xl. then double click on "workbook.xlm". From here you can get the ids for the worksheets you want to save.
4. Then go back and go to folder which is named worksheets. Delete all the spreadsheets and try to reopen it.
5. Excel might say the file needs repair but it can actually repair it this time.
0
 
Martin LissOlder than dirtCommented:
Here's an article from MS that at least talks about the cause.
0
 
awesomejohn19Author Commented:
Thanks but this doesn't help because I can't open the file.
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Martin LissOlder than dirtCommented:
Can you attach it here?
0
 
Martin LissOlder than dirtCommented:
I'm happy you figured it out.
0
 
awesomejohn19Author Commented:
Google Searching helped.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.