ID Artikel: 291288 - Melihat produk di mana artikel ini berlaku.
Perbesar semua | Perkecil semua

Pada Halaman ini

Ringkasan

Microsoft Excel menerima sejumlah saklar opsional yang dapat Anda gunakan untuk mengontrol bagaimana program dimulai. Artikel ini berisi daftar switch dan menyediakan penjelasan switch masing-masing.

Informasi lebih lanjut

Saklar opsional untuk Excel 2013 sedikit berbeda. Untuk mempelajari lebih banyak tentang mereka, silakan baca:Switch baris perintah untuk Excel

Switch

Daftar Tabel berikut mencantumkan switch yang dapat Anda gunakan untuk mengontrol bagaimana Excel dimulai. Switch tidak peka: /O adalah sama dengan /o. Dalam beberapa skenario, Anda dapat menggunakan switch lebih dari satu pada satu waktu. Jika Anda menggunakan lebih dari satu beralih pada suatu waktu, Anda harus memisahkan switch dengan Ruang--misalnya: /o/s
   Switch           Function
   ----------------------------------------------------------------------

   /e, /embedded    Forces Excel to start without displaying the 
                    startup screen and creating a new workbook 
                    (Book1.xls).

                    Example: /e or /embedded

   /m               Forces Excel to create a new workbook that
                    contains a single macro sheet.

                    Example: /m

   /o               Forces Excel to re-register itself. Specifically, 
                    the following key is rewritten in the registry:

                    Excel 97: HKEY_CURRENT_USER\Software\Microsoft\Office\8.0\Excel
 
                    Excel 2000: HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Excel

                    Excel 2002: HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Excel

                    Excel 2003: HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel

                    NOTE: If this key contains values that are not valid,
                    they are not corrected by using this switch. This 
                    switch only replaces missing values.

                    Example: /o

   /p <folder>      Forces Excel to use the path that you specify as the active
                    path instead of the default path. 

                    Example: /p "C:\Windows"

   /r <file name>    Forces Excel to open the specified file in
                    read-only mode.

                    Example: /r "C:\My Documents\Test.xls"

   /s, /safemode    Forces Excel to bypass all files in the Application Data\Microsoft\Xlstart folder,
                    the default XLStart folder located in the directory where Excel or Office is installed, 
                    and the alternate startup file location specified on the General tab of the Excel Options dialog box. 
                    It also forces Excel 
                    to bypass the toolbar file (Excel.xlb or 
                    <username>.xlb). You see "Safe Mode" in the 
                    Excel title bar. Use this switch when you want to 
                    start Excel in safe mode.

                    Example: /s or /safemode
				
   Switch           Function
   ----------------------------------------------------------------------

   /e, /embedded    Forces Excel to start without displaying the 
                    startup screen and creating a new workbook 
                    (Book1.xls).

                    Example: /e or /embedded

   /m               Forces Excel to create a new workbook that
                    contains a single macro sheet.

                    Example: /m

   /o               Forces Excel to re-register itself. Specifically, 
                    the following key is rewritten in the registry:

                    Excel 97: HKEY_CURRENT_USER\Software\Microsoft\Office\8.0\Excel
 
                    Excel 2000: HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Excel

                    Excel 2002: HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Excel

                    Excel 2003: HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel

                    NOTE: If this key contains values that are not valid,
                    they are not corrected by using this switch. This 
                    switch only replaces missing values.

                    Example: /o

   /p <folder>      Forces Excel to use the path that you specify as the active
                    path instead of the default path. 

                    Example: /p "C:\Windows"

   /r <file name>    Forces Excel to open the specified file in
                    read-only mode.

                    Example: /r "C:\My Documents\Test.xls"

   /s, /safemode    Forces Excel to bypass all files in the Application Data\Microsoft\Xlstart folder,
                    the default XLStart folder located in the directory where Excel or Office is installed, 
                    and the alternate startup file location specified on the General tab of the Excel Options dialog box. 
                    It also forces Excel 
                    to bypass the toolbar file (Excel.xlb or 
                    <username>.xlb). You see "Safe Mode" in the 
                    Excel title bar. Use this switch when you want to 
                    start Excel in safe mode.

                    Example: /s or /safemode
				   Switch           Function
   ----------------------------------------------------------------------

   /e, /embedded    Forces Excel to start without displaying the 
                    startup screen and creating a new workbook 
                    (Book1.xls).

                    Example: /e or /embedded

   /m               Forces Excel to create a new workbook that
                    contains a single macro sheet.

                    Example: /m

   /o               Forces Excel to re-register itself. Specifically, 
                    the following key is rewritten in the registry:

                    Excel 97: HKEY_CURRENT_USER\Software\Microsoft\Office\8.0\Excel
 
                    Excel 2000: HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Excel

                    Excel 2002: HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Excel

                    Excel 2003: HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel

                    NOTE: If this key contains values that are not valid,
                    they are not corrected by using this switch. This 
                    switch only replaces missing values.

                    Example: /o

   /p <folder>      Forces Excel to use the path that you specify as the active
                    path instead of the default path. 

                    Example: /p "C:\Windows"

   /r <file name>    Forces Excel to open the specified file in
                    read-only mode.

                    Example: /r "C:\My Documents\Test.xls"

   /s, /safemode    Forces Excel to bypass all files in the Application Data\Microsoft\Xlstart folder,
                    the default XLStart folder located in the directory where Excel or Office is installed, 
                    and the alternate startup file location specified on the General tab of the Excel Options dialog box. 
                    It also forces Excel 
                    to bypass the toolbar file (Excel.xlb or 
                    <username>.xlb). You see "Safe Mode" in the 
                    Excel title bar. Use this switch when you want to 
                    start Excel in safe mode.

                    Example: /s or /safemode
				   Switch           Function
   ----------------------------------------------------------------------

   /e, /embedded    Forces Excel to start without displaying the 
                    startup screen and creating a new workbook 
                    (Book1.xls).

                    Example: /e or /embedded

   /m               Forces Excel to create a new workbook that
                    contains a single macro sheet.

                    Example: /m

   /o               Forces Excel to re-register itself. Specifically, 
                    the following key is rewritten in the registry:

                    Excel 97: HKEY_CURRENT_USER\Software\Microsoft\Office\8.0\Excel
 
                    Excel 2000: HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Excel

                    Excel 2002: HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Excel

                    Excel 2003: HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel

                    NOTE: If this key contains values that are not valid,
                    they are not corrected by using this switch. This 
                    switch only replaces missing values.

                    Example: /o

   /p <folder>      Forces Excel to use the path that you specify as the active
                    path instead of the default path. 

                    Example: /p "C:\Windows"

   /r <file name>    Forces Excel to open the specified file in
                    read-only mode.

                    Example: /r "C:\My Documents\Test.xls"

   /s, /safemode    Forces Excel to bypass all files in the Application Data\Microsoft\Xlstart folder,
                    the default XLStart folder located in the directory where Excel or Office is installed, 
                    and the alternate startup file location specified on the General tab of the Excel Options dialog box. 
                    It also forces Excel 
                    to bypass the toolbar file (Excel.xlb or 
                    <username>.xlb). You see "Safe Mode" in the 
                    Excel title bar. Use this switch when you want to 
                    start Excel in safe mode.

                    Example: /s or /safemode
				   Switch           Function
   ----------------------------------------------------------------------

   /e, /embedded    Forces Excel to start without displaying the 
                    startup screen and creating a new workbook 
                    (Book1.xls).

                    Example: /e or /embedded

   /m               Forces Excel to create a new workbook that
                    contains a single macro sheet.

                    Example: /m

   /o               Forces Excel to re-register itself. Specifically, 
                    the following key is rewritten in the registry:

                    Excel 97: HKEY_CURRENT_USER\Software\Microsoft\Office\8.0\Excel
 
                    Excel 2000: HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Excel

                    Excel 2002: HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Excel

                    Excel 2003: HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel

                    NOTE: If this key contains values that are not vali Excel 2003: HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Exceld,
                    they are not corrected by using this switch. This 
                    switch only replaces missing values.

                    Example: /o

   /p <folder>      Forces Excel to use the path that you specify as the active
                    path instead of the default path. 

                    Example: /p "C:\Windows"

   /r <file name>    Forces Excel to open the specified file in
                    read-only mode.

                    Example: /r "C:\My Documents\Test.xls"

   /s, /safemode    Forces Excel to bypass all files in the Application Data\Microsoft\Xlstart folder,
                    the default XLStart folder located in the directory where Excel or Office is installed, 
                    and the alternate startup file location specified on the General tab of the Excel Options dialog box. 
                    It also forces Excel 
                    to bypass the toolbar file (Excel.xlb or 
                    <username>.xlb). You see "Safe Mode" in the 
                    Excel title bar. Use this switch when you want to 
                    start Excel in safe mode.

                    Example: /s or /safemode
				
     /t                Forces Excel to use the specified file as a
                    template for the default workbook. 

  /regserver        Forces Excel to register itself and then quit. Use this 
                    switch when you want Excel to rewrite all its 
                    registry keys and reassociate itself with Excel files, 
                    such as workbooks, charts, and others.(Applies only to versions before Excel 2010)

                    Example: /regserver


   /unregserver     Forces Excel to unregister itself and then quit.(Applies only to versions before Excel 2010)

                    Example: /unregserver
				

Cara menggunakan switch saat memulai Excel

Bagaimana cara menambahkan sebuah saklar untuk cara pintas Microsoft Excel

Untuk menambahkan sebuah saklar untuk cara pintas Microsoft Excel:
  1. Klik kanan-atas Start, klik buka, dan kemudian klik ganda Program folder.
  2. Klik-kanan jalan pintas untuk Microsoft Excel, klik properti, dan kemudian klik Shortcut tab.
  3. Dalam kotak Target , ketik switch yang Anda inginkan setelah perintah yang berjalan Excel.exe. sebagai contoh, jika Anda ingin Excel untuk memulai tanpa membuat baru buku kerja, dan Excel.exe file terinstal di lokasi asali, ketik berikut di kotak Target :
    "C:\Program program Office\Office\Excel.exe" e
  4. Klik OK.

    Catatan Jika tidak tersedia pilihan pada tab Shortcut di kotak dialog Properties , cara pintas Anda adalah jendela Pintas installer.Untuk informasi lebih lanjut tentang cara mengubah cara pintas ini, klik nomor artikel berikut ini untuk melihat artikel di dalam Pangkalan Pengetahuan Microsoft:
    290379Kantor pintasan tab tidak tersedia

Bagaimana untuk menjalankan Excel satu kali dengan beralih dengan menggunakan perintah baris

Jika Anda ingin menjalankan Excel dengan sebuah saklar kadang-kadang, Anda dapat menambahkan beralih ke baris perintah. Untuk melakukan hal ini:
  1. Klik mulai, dan kemudian klik menjalankan.
  2. Di kotak buka , ketik path ke Excel.exe, dan kemudian menambahkan tombol tekan yang Anda ingin menggunakan pada akhir baris perintah. Sebagai contoh, jika Anda ingin memotong Semua file dalam folder startup dan Excel.exe file terinstal di lokasi asali, Anda ketik perintah berikut:
    "C:\Program program Office\Office\Excel.exe" / s
  3. Klik OK.

Properti

ID Artikel: 291288 - Kajian Terakhir: 15 Maret 2013 - Revisi: 5.0
Berlaku bagi:
  • Microsoft Excel 2010
  • Microsoft Office Excel 2007
  • Microsoft Office Excel 2003
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 97 Standard Edition
Kata kunci: 
kbinfo kbmt KB291288 KbMtid
Penerjemahan Mesin
PENTING: Artikel ini diterjemahkan menggunakan perangkat lunak mesin penerjemah Microsoft dan bukan oleh seorang penerjemah. Microsoft menawarkan artikel yang diterjemahkan oleh seorang penerjemah maupun artikel yang diterjemahkan menggunakan mesin sehingga Anda akan memiliki akses ke seluruh artikel baru yang diterbitkan di Pangkalan Pengetahuan (Knowledge Base) dalam bahasa yang Anda gunakan. Namun, artikel yang diterjemahkan menggunakan mesin tidak selalu sempurna. Artikel tersebut mungkin memiliki kesalahan kosa kata, sintaksis, atau tata bahasa, hampir sama seperti orang asing yang berbicara dalam bahasa Anda. Microsoft tidak bertanggung jawab terhadap akurasi, kesalahan atau kerusakan yang disebabkan karena kesalahan penerjemahan konten atau penggunaannya oleh para pelanggan. Microsoft juga sering memperbarui perangkat lunak mesin penerjemah.
Klik disini untuk melihat versi Inggris dari artikel ini: 291288

Berikan Masukan

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com