Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-28-2019, 04:39 AM
Veezee Veezee is offline Removed records: Protection error Windows 7 64bit Removed records: Protection error Office 2016
Novice
Removed records: Protection error
 
Join Date: Feb 2019
Posts: 2
Veezee is on a distinguished road
Default Removed records: Protection error

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.
Reply With Quote
  #2  
Old 02-28-2019, 02:21 PM
Kenneth Hobson Kenneth Hobson is offline Removed records: Protection error Windows 10 Removed records: Protection error Office 2016
Advanced Beginner
 
Join Date: Jun 2018
Posts: 37
Kenneth Hobson is on a distinguished road
Default

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
Reply With Quote
  #3  
Old 02-28-2019, 06:47 PM
Veezee Veezee is offline Removed records: Protection error Windows 7 64bit Removed records: Protection error Office 2016
Novice
Removed records: Protection error
 
Join Date: Feb 2019
Posts: 2
Veezee is on a distinguished road
Default

Thanks,I will give it try.
Reply With Quote
Reply

Tags
error, protection, record

Thread Tools
Display Modes


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
Removed records: Protection error Quick Parts-Need to be removed from TOC Isaac Word 3 05-11-2017 04:43 AM
Removed records: Protection error 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
Removed records: Protection error 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:36 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft