excel - trucchi - rimuovi password protezione scheda/file

potrebbe capitare di aver messo una password in una scheda per bloccarla in modo da impedire la modifica, ma che ve la siete dimenticata
per sistemare il problema puoi copiare il contenuto della scheda in un'altra ma potrebbe essere un problema se ci sono formule e grafici complicati

oppure hai messo la protezione a tutte le schede con password dimenticata

esiste un trucco che funziona solo per i file non binari
quindi se il file é .xlsb convertilo in un formato non binario

procedura

fa una copia di backup del file

verifica quale scheda ha il blocco

VBA

.xml

modifica l'estensione del file in .zip

DOS

apri il file .zip con 7-zip

7-zip

.zip

protezione singola scheda Proteggi foglio

→xl

→worksheets

.xml

apri con Notepad++ il file .xml che credi sia quello con il blocco

Notepad++

cerca il tag sheetProtection

esempio
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships"
xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x14ac xr xr2 xr3" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac"
xmlns:xr="http://schemas.microsoft.com/office/spreadsheetml/2014/revision" xmlns:xr2="http://schemas.microsoft.com/office/spreadsheetml/2015/revision2"
xmlns:xr3="http://schemas.microsoft.com/office/spreadsheetml/2016/revision3" xr:uid="{8BDF9DB8-E81E-4670-B696-249A6464848B}"><dimension ref="A1"/><sheetViews><sheetView tabSelected="1"
workbookViewId="0"><selection activeCell="G16" sqref="G16"/></sheetView></sheetViews><sheetFormatPr defaultRowHeight="15" x14ac:dyDescent="0.25"/><sheetData><row r="1" spans="1:1" x14ac:dyDescent="0.25">
<c r="A1" t="s"><v>1</v></c></row></sheetData><sheetProtection algorithmName="SHA-512" hashValue="A7VJrjY2bC/DfeG9AqfX/ZArGmN63FYWDi2x1cF3HabYonSvs9ZWU1KgQU98GCeeFW/vt2kSIg382z0HahZDuQ=="
saltValue="Ej84qxoocPceewdVkkKRXQ==" spinCount="100000" sheet="1" objects="1" scenarios="1"/><pageMargins left="0.7" right="0.7" top="0.75" bottom="0.75" header="0.3" footer="0.3"/></worksheet>

cancella tutto il tag sheetProtection

da
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships"
xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x14ac xr xr2 xr3" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac"
xmlns:xr="http://schemas.microsoft.com/office/spreadsheetml/2014/revision" xmlns:xr2="http://schemas.microsoft.com/office/spreadsheetml/2015/revision2"
xmlns:xr3="http://schemas.microsoft.com/office/spreadsheetml/2016/revision3" xr:uid="{8BDF9DB8-E81E-4670-B696-249A6464848B}"><dimension ref="A1"/><sheetViews><sheetView tabSelected="1"
workbookViewId="0"><selection activeCell="G16" sqref="G16"/></sheetView></sheetViews><sheetFormatPr defaultRowHeight="15" x14ac:dyDescent="0.25"/><sheetData><row r="1" spans="1:1" x14ac:dyDescent="0.25">
<c r="A1" t="s"><v>1</v></c></row></sheetData><sheetProtection algorithmName="SHA-512" hashValue="A7VJrjY2bC/DfeG9AqfX/ZArGmN63FYWDi2x1cF3HabYonSvs9ZWU1KgQU98GCeeFW/vt2kSIg382z0HahZDuQ=="
saltValue="Ej84qxoocPceewdVkkKRXQ==" spinCount="100000" sheet="1" objects="1" scenarios="1"/><pageMargins left="0.7" right="0.7" top="0.75" bottom="0.75" header="0.3" footer="0.3"/></worksheet>

a
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships"
xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x14ac xr xr2 xr3" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac"
xmlns:xr="http://schemas.microsoft.com/office/spreadsheetml/2014/revision" xmlns:xr2="http://schemas.microsoft.com/office/spreadsheetml/2015/revision2"
xmlns:xr3="http://schemas.microsoft.com/office/spreadsheetml/2016/revision3" xr:uid="{8BDF9DB8-E81E-4670-B696-249A6464848B}"><dimension ref="A1"/><sheetViews><sheetView tabSelected="1"
workbookViewId="0"><selection activeCell="G16" sqref="G16"/></sheetView></sheetViews><sheetFormatPr defaultRowHeight="15" x14ac:dyDescent="0.25"/><sheetData><row r="1" spans="1:1" x14ac:dyDescent="0.25">
<c r="A1" t="s"><v>1</v></c></row></sheetData><pageMargins left="0.7" right="0.7" top="0.75" bottom="0.75" header="0.3" footer="0.3"/></worksheet>

salva il file .xml aperto con Notepad++

7-zip

protezione tutte le schede Proteggi cartella di lavoro

apri con Notepad++ il file workbook.xml

Notepad++

cerca il tag workbookProtection

esempio
<workbook xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x15 xr xr6 xr10 xr2" xmlns:x15="http://schemas.microsoft.com/office/spreadsheetml/2010/11/main" xmlns:xr="http://schemas.microsoft.com/office/spreadsheetml/2014/revision" xmlns:xr6="http://schemas.microsoft.com/office/spreadsheetml/2016/revision6" xmlns:xr10="http://schemas.microsoft.com/office/spreadsheetml/2016/revision10" xmlns:xr2="http://schemas.microsoft.com/office/spreadsheetml/2015/revision2"><fileVersion appName="xl" lastEdited="7" lowestEdited="7" rupBuild="27328"/><workbookPr codeName="Questa_cartella_di_lavoro" defaultThemeVersion="202300"/><mc:AlternateContent xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"><mc:Choice Requires="x15"><x15ac:absPath url="C:\Users\xxxx\Downloads\" xmlns:x15ac="http://schemas.microsoft.com/office/spreadsheetml/2010/11/ac"/></mc:Choice></mc:AlternateContent><xr:revisionPtr revIDLastSave="0" documentId="8_{78016FBA-20B9-4AA5-BD80-694ADD71229C}" xr6:coauthVersionLast="47" xr6:coauthVersionMax="47" xr10:uidLastSave="{00000000-0000-0000-0000-000000000000}"/><workbookProtection workbookAlgorithmName="SHA-512" workbookHashValue="kvmVlPjwZ+ZYe7Ml41c1P1TB0ZwKUErDX3ZQ3qx1NPKwcVfUids9xPREBCr5Z/jgRRvRAaR1Vmk1lnM2CuUIag==" workbookSaltValue="qd1YNoBdEI2Kr0tRZgvdbw==" workbookSpinCount="100000" lockStructure="1"/><bookViews><workbookView xWindow="-120" yWindow="-120" windowWidth="29040" windowHeight="15720" activeTab="1" xr2:uid="{87EE2EAC-F33C-4D03-BD4E-7A85B3F271DB}"/></bookViews><sheets><sheet name="Foglio1" sheetId="1" r:id="rId1"/><sheet name="Foglio2" sheetId="2" r:id="rId2"/><sheet name="Foglio3" sheetId="3" r:id="rId3"/></sheets><calcPr calcId="191029" concurrentCalc="0"/><extLst><ext uri="{140A7094-0E35-4892-8432-C4D2E57EDEB5}" xmlns:x15="http://schemas.microsoft.com/office/spreadsheetml/2010/11/main"><x15:workbookPr chartTrackingRefBase="1"/></ext><ext uri="{B58B0392-4F1F-4190-BB64-5DF3571DCE5F}" xmlns:xcalcf="http://schemas.microsoft.com/office/spreadsheetml/2018/calcfeatures"><xcalcf:calcFeatures><xcalcf:feature name="microsoft.com:RD"/><xcalcf:feature name="microsoft.com:Single"/><xcalcf:feature name="microsoft.com:FV"/><xcalcf:feature name="microsoft.com:CNMTM"/><xcalcf:feature name="microsoft.com:LET_WF"/><xcalcf:feature name="microsoft.com:LAMBDA_WF"/><xcalcf:feature name="microsoft.com:ARRAYTEXT_WF"/></xcalcf:calcFeatures></ext></extLst></workbook> </p>

cancella tutto il tag workbookProtection

da
<workbook xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x15 xr xr6 xr10 xr2" xmlns:x15="http://schemas.microsoft.com/office/spreadsheetml/2010/11/main" xmlns:xr="http://schemas.microsoft.com/office/spreadsheetml/2014/revision" xmlns:xr6="http://schemas.microsoft.com/office/spreadsheetml/2016/revision6" xmlns:xr10="http://schemas.microsoft.com/office/spreadsheetml/2016/revision10" xmlns:xr2="http://schemas.microsoft.com/office/spreadsheetml/2015/revision2"><fileVersion appName="xl" lastEdited="7" lowestEdited="7" rupBuild="27328"/><workbookPr codeName="Questa_cartella_di_lavoro" defaultThemeVersion="202300"/><mc:AlternateContent xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"><mc:Choice Requires="x15"><x15ac:absPath url="C:\Users\xxxx\Downloads\" xmlns:x15ac="http://schemas.microsoft.com/office/spreadsheetml/2010/11/ac"/></mc:Choice></mc:AlternateContent><xr:revisionPtr revIDLastSave="0" documentId="8_{78016FBA-20B9-4AA5-BD80-694ADD71229C}" xr6:coauthVersionLast="47" xr6:coauthVersionMax="47" xr10:uidLastSave="{00000000-0000-0000-0000-000000000000}"/><workbookProtection workbookAlgorithmName="SHA-512" workbookHashValue="kvmVlPjwZ+ZYe7Ml41c1P1TB0ZwKUErDX3ZQ3qx1NPKwcVfUids9xPREBCr5Z/jgRRvRAaR1Vmk1lnM2CuUIag==" workbookSaltValue="qd1YNoBdEI2Kr0tRZgvdbw==" workbookSpinCount="100000" lockStructure="1"/><bookViews><workbookView xWindow="-120" yWindow="-120" windowWidth="29040" windowHeight="15720" activeTab="1" xr2:uid="{87EE2EAC-F33C-4D03-BD4E-7A85B3F271DB}"/></bookViews><sheets><sheet name="Foglio1" sheetId="1" r:id="rId1"/><sheet name="Foglio2" sheetId="2" r:id="rId2"/><sheet name="Foglio3" sheetId="3" r:id="rId3"/></sheets><calcPr calcId="191029" concurrentCalc="0"/><extLst><ext uri="{140A7094-0E35-4892-8432-C4D2E57EDEB5}" xmlns:x15="http://schemas.microsoft.com/office/spreadsheetml/2010/11/main"><x15:workbookPr chartTrackingRefBase="1"/></ext><ext uri="{B58B0392-4F1F-4190-BB64-5DF3571DCE5F}" xmlns:xcalcf="http://schemas.microsoft.com/office/spreadsheetml/2018/calcfeatures"><xcalcf:calcFeatures><xcalcf:feature name="microsoft.com:RD"/><xcalcf:feature name="microsoft.com:Single"/><xcalcf:feature name="microsoft.com:FV"/><xcalcf:feature name="microsoft.com:CNMTM"/><xcalcf:feature name="microsoft.com:LET_WF"/><xcalcf:feature name="microsoft.com:LAMBDA_WF"/><xcalcf:feature name="microsoft.com:ARRAYTEXT_WF"/></xcalcf:calcFeatures></ext></extLst></workbook> </p>

a
<workbook xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x15 xr xr6 xr10 xr2" xmlns:x15="http://schemas.microsoft.com/office/spreadsheetml/2010/11/main" xmlns:xr="http://schemas.microsoft.com/office/spreadsheetml/2014/revision" xmlns:xr6="http://schemas.microsoft.com/office/spreadsheetml/2016/revision6" xmlns:xr10="http://schemas.microsoft.com/office/spreadsheetml/2016/revision10" xmlns:xr2="http://schemas.microsoft.com/office/spreadsheetml/2015/revision2"><fileVersion appName="xl" lastEdited="7" lowestEdited="7" rupBuild="27328"/><workbookPr codeName="Questa_cartella_di_lavoro" defaultThemeVersion="202300"/><mc:AlternateContent xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"><mc:Choice Requires="x15"><x15ac:absPath url="C:\Users\xxxx\Downloads\" xmlns:x15ac="http://schemas.microsoft.com/office/spreadsheetml/2010/11/ac"/></mc:Choice></mc:AlternateContent><xr:revisionPtr revIDLastSave="0" documentId="8_{78016FBA-20B9-4AA5-BD80-694ADD71229C}" xr6:coauthVersionLast="47" xr6:coauthVersionMax="47" xr10:uidLastSave="{00000000-0000-0000-0000-000000000000}"/><bookViews><workbookView xWindow="-120" yWindow="-120" windowWidth="29040" windowHeight="15720" activeTab="1" xr2:uid="{87EE2EAC-F33C-4D03-BD4E-7A85B3F271DB}"/></bookViews><sheets><sheet name="Foglio1" sheetId="1" r:id="rId1"/><sheet name="Foglio2" sheetId="2" r:id="rId2"/><sheet name="Foglio3" sheetId="3" r:id="rId3"/></sheets><calcPr calcId="191029" concurrentCalc="0"/><extLst><ext uri="{140A7094-0E35-4892-8432-C4D2E57EDEB5}" xmlns:x15="http://schemas.microsoft.com/office/spreadsheetml/2010/11/main"><x15:workbookPr chartTrackingRefBase="1"/></ext><ext uri="{B58B0392-4F1F-4190-BB64-5DF3571DCE5F}" xmlns:xcalcf="http://schemas.microsoft.com/office/spreadsheetml/2018/calcfeatures"><xcalcf:calcFeatures><xcalcf:feature name="microsoft.com:RD"/><xcalcf:feature name="microsoft.com:Single"/><xcalcf:feature name="microsoft.com:FV"/><xcalcf:feature name="microsoft.com:CNMTM"/><xcalcf:feature name="microsoft.com:LET_WF"/><xcalcf:feature name="microsoft.com:LAMBDA_WF"/><xcalcf:feature name="microsoft.com:ARRAYTEXT_WF"/></xcalcf:calcFeatures></ext></extLst></workbook> </p>

ripristina l'estensione Excel originale

Excel

document.write(document.title.substr(0,document.title.indexOf("-")).trim().toUpperCase() + " - " + document.title.substr(document.title.indexOf("-")+1).trim().toLowerCase())