[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 657
  • Last Modified:

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,
0
awesomejohn19
Asked:
awesomejohn19
  • 3
  • 3
1 Solution
 
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
 
Martin LissOlder than dirtCommented:
Can you attach it here?
0
2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

 
awesomejohn19Author 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:
I'm happy you figured it out.
0
 
awesomejohn19Author Commented:
Google Searching helped.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now