Removed records: Protection error

Veezee · #1 02-28-2019, 04:39 AM

I continue to get an error when opening my excel file. I can restore to previous versions and the error will go away for an arbitrary amount of time before returning. The message reads as follows:

We found a problem with some content in ‘D2B- GRIDDLE UPLOAD.XLSX’. Do you want us to try and recover as much as we can? If you trust the source of this workbook, click yes.

After repair I get the following message:

Excel was able to open the file by repairing or removing the unreadable content
Removed Records: Protection from /xl/worksheets/sheet10.xml part

Repair log file reads as such:
<?xml version="1.0" encoding="UTF-8" standalone="true"?>
<recoveryLogxmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error063640_01.xml</logFileName><summary>Errors were detected in file 'S:\ATR Pull Files\D2B- GRIDDLE UPLOAD.xlsx'</summary><removedRecords><removedRecord>Removed Records: Protection from /xl/worksheets/sheet10.xml part</removedRecord></removedRecords></recoveryLog>

This file is located on a shared drive. I have recreated the file several times and the error returns. I can save a copy of the file renaming it but the error soon returns. Any thoughts on how to solve this error would be appreciated.

Kenneth Hobson · #2 02-28-2019, 02:21 PM

Welcome to the forum!

A search shows one simple solution might be:

Quote:

try to save file as XLSB (binary macro file) and either use XLSB file or save it back to XLSM

Veezee · #3 02-28-2019, 06:47 PM

Thanks,I will give it try.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
i have removed mathtype from my laptop but when open power point i get error ppt cannot find mathtyp	vaskel	PowerPoint	1	05-20-2018 07:47 AM
Quick Parts-Need to be removed from TOC	Isaac	Word	3	05-11-2017 04:43 AM
When using a 'Master' template, if number of records change, subsequent records will not be read	MailMergeConfused	Mail Merge	5	07-28-2016 05:07 PM
When I email a document that has been designed with forms the protection is removed	Kiminator321	Word	2	07-12-2016 10:22 AM
PowerPoint removed unreadable content	Ray331	PowerPoint	3	08-23-2014 07:06 AM