Default file format: kayıt defteri değeri defaultformat (excel\options)KullanıcıHKCU\software\policies\microsoft\office\16.0\excel\options

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

İlke Kimliği
L_SaveExcelfilesas
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 › Save

Kayıt defteri

defaultformat

REG_DWORDKullanıcı
Etkin değeri
Seçenek değerine bağlıdır
Öğe
Save Excel files as
Seçenekler
MaddeSaklanan değer
Excel Workbook (*.xlsx)51
Excel Macro-Enabled Workbook (*.xlsm)52
Excel Binary Workbook (*.xlsb)50
Web Page (*.htm; *.html)44
Excel 97-2003 Workbook (*.xls)56
Excel 5.0/95 Workbook (*.xls)39
OpenDocument Spreadsheet (*.ods)60
.reg · CMD · PowerShell ile uygula
.reg
Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\options]

; Seçenekler (yalnızca birini kullanın)
; Excel Workbook (*.xlsx)
"defaultformat"=dword:00000033
; Excel Macro-Enabled Workbook (*.xlsm)
"defaultformat"=dword:00000034
; Excel Binary Workbook (*.xlsb)
"defaultformat"=dword:00000032
; Web Page (*.htm; *.html)
"defaultformat"=dword:0000002c
; Excel 97-2003 Workbook (*.xls)
"defaultformat"=dword:00000038
; Excel 5.0/95 Workbook (*.xls)
"defaultformat"=dword:00000027
; OpenDocument Spreadsheet (*.ods)
"defaultformat"=dword:0000003c
CMD
:: Seçenekler (yalnızca birini kullanın)

:: Excel Workbook (*.xlsx)
reg add "HKCU\software\policies\microsoft\office\16.0\excel\options" /v "defaultformat" /t REG_DWORD /d 51 /f
:: Excel Macro-Enabled Workbook (*.xlsm)
reg add "HKCU\software\policies\microsoft\office\16.0\excel\options" /v "defaultformat" /t REG_DWORD /d 52 /f
:: Excel Binary Workbook (*.xlsb)
reg add "HKCU\software\policies\microsoft\office\16.0\excel\options" /v "defaultformat" /t REG_DWORD /d 50 /f
:: Web Page (*.htm; *.html)
reg add "HKCU\software\policies\microsoft\office\16.0\excel\options" /v "defaultformat" /t REG_DWORD /d 44 /f
:: Excel 97-2003 Workbook (*.xls)
reg add "HKCU\software\policies\microsoft\office\16.0\excel\options" /v "defaultformat" /t REG_DWORD /d 56 /f
:: Excel 5.0/95 Workbook (*.xls)
reg add "HKCU\software\policies\microsoft\office\16.0\excel\options" /v "defaultformat" /t REG_DWORD /d 39 /f
:: OpenDocument Spreadsheet (*.ods)
reg add "HKCU\software\policies\microsoft\office\16.0\excel\options" /v "defaultformat" /t REG_DWORD /d 60 /f
PowerShell
# Ortak: anahtarı oluştur
New-Item -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\options' -Force | Out-Null

# Seçenekler (yalnızca birini kullanın)
# Excel Workbook (*.xlsx)
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\options' -Name 'defaultformat' -PropertyType DWord -Value 51 -Force | Out-Null
# Excel Macro-Enabled Workbook (*.xlsm)
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\options' -Name 'defaultformat' -PropertyType DWord -Value 52 -Force | Out-Null
# Excel Binary Workbook (*.xlsb)
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\options' -Name 'defaultformat' -PropertyType DWord -Value 50 -Force | Out-Null
# Web Page (*.htm; *.html)
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\options' -Name 'defaultformat' -PropertyType DWord -Value 44 -Force | Out-Null
# Excel 97-2003 Workbook (*.xls)
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\options' -Name 'defaultformat' -PropertyType DWord -Value 56 -Force | Out-Null
# Excel 5.0/95 Workbook (*.xls)
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\options' -Name 'defaultformat' -PropertyType DWord -Value 39 -Force | Out-Null
# OpenDocument Spreadsheet (*.ods)
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\options' -Name 'defaultformat' -PropertyType DWord -Value 60 -Force | Out-Null