Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 388
  • 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 LissRetired ProgrammerCommented:
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 LissRetired ProgrammerCommented:
Can you attach it here?
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

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