Excel 2 worksheets: kayıt defteri değeri xl2worksheetsKullanıcıHKCU\software\policies\microsoft\office\16.0\excel\security\fileblock

Bu dilde resmi metin yok (İngilizce özgün metin gösteriliyor)

İlke Kimliği
L_Excel2Worksheets
Kapsam
Kullanıcı Yapılandırması
Desteklenen işletim sistemleri
En az Windows Server 2008 R2 veya Windows 7
Kaynak
Microsoft 365 Apps / Office Administrative Templates (sürüm 5568.1000)
Kategori
Microsoft Excel 2016 › Excel Options › Security › Trust Center › File Block Settings

Kayıt defteri

xl2worksheets

REG_DWORDKullanıcı
Etkin değeri
Seçenek değerine bağlıdır
Öğe
File block setting:
Seçenekler
MaddeSaklanan değer
Do not block0
Open/Save blocked, use open policy2
Block3
Open in Protected View4
Allow editing and open in Protected View5
.reg · CMD · PowerShell ile uygula
.reg
Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\security\fileblock]

; Seçenekler (yalnızca birini kullanın)
; Do not block
"xl2worksheets"=dword:00000000
; Open/Save blocked, use open policy
"xl2worksheets"=dword:00000002
; Block
"xl2worksheets"=dword:00000003
; Open in Protected View
"xl2worksheets"=dword:00000004
; Allow editing and open in Protected View
"xl2worksheets"=dword:00000005
CMD
:: Seçenekler (yalnızca birini kullanın)

:: Do not block
reg add "HKCU\software\policies\microsoft\office\16.0\excel\security\fileblock" /v "xl2worksheets" /t REG_DWORD /d 0 /f
:: Open/Save blocked, use open policy
reg add "HKCU\software\policies\microsoft\office\16.0\excel\security\fileblock" /v "xl2worksheets" /t REG_DWORD /d 2 /f
:: Block
reg add "HKCU\software\policies\microsoft\office\16.0\excel\security\fileblock" /v "xl2worksheets" /t REG_DWORD /d 3 /f
:: Open in Protected View
reg add "HKCU\software\policies\microsoft\office\16.0\excel\security\fileblock" /v "xl2worksheets" /t REG_DWORD /d 4 /f
:: Allow editing and open in Protected View
reg add "HKCU\software\policies\microsoft\office\16.0\excel\security\fileblock" /v "xl2worksheets" /t REG_DWORD /d 5 /f
PowerShell
# Ortak: anahtarı oluştur
New-Item -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\security\fileblock' -Force | Out-Null

# Seçenekler (yalnızca birini kullanın)
# Do not block
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\security\fileblock' -Name 'xl2worksheets' -PropertyType DWord -Value 0 -Force | Out-Null
# Open/Save blocked, use open policy
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\security\fileblock' -Name 'xl2worksheets' -PropertyType DWord -Value 2 -Force | Out-Null
# Block
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\security\fileblock' -Name 'xl2worksheets' -PropertyType DWord -Value 3 -Force | Out-Null
# Open in Protected View
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\security\fileblock' -Name 'xl2worksheets' -PropertyType DWord -Value 4 -Force | Out-Null
# Allow editing and open in Protected View
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\security\fileblock' -Name 'xl2worksheets' -PropertyType DWord -Value 5 -Force | Out-Null