Configure How Workbooks Open By Default

All workbooks open in Viewer mode by default, but as a workbook author, you can configure workbooks to open in Edit mode or in Viewer mode by default.

Topics:

• Configure All of Your Workbooks to Open in Edit Mode by Default

• Configure a Workbook to Open in Edit Mode

Configure All of Your Workbooks to Open in Edit Mode by Default

This task is for workbook authors. All of your workbooks open in Viewer mode by default, but you can change this behavior so that all of your workbooks open in Edit mode by default.

1. On the Home page, click your user profile icon, then select Profile from the menu.
   
   

   
   Description of the illustration dv_user_profile.png

   
   
2. Click Advanced, and then click the Open Workbooks as a Viewer toggle.
   • Open Workbooks as a Viewer toggle ON (green circle) - All of your workbooks open in Viewer mode by default.

     
     
     Description of the illustration dv_chg_wkbk_default_green.png
     

   • Open Workbooks as a Viewer toggle OFF (white circle) - All of your workbooks open in Edit mode by default.

     
     
     Description of the illustration dv_chg_wkbk_default_white.png
     

3. Click Close.

Configure a Workbook to Open in Edit Mode

As a workbook author, you can make workbooks that you create open in Edit mode as the default behavior. If workbooks that you don't own are editable, you can make those workbooks open in Edit mode as well.

1. On the Home page, click a workbook to open it.
2. Click Edit to open the workbook in edit mode and enable the display of workbook properties.
   
   

   
   Description of the illustration dv_edit_workbk.png

   
   
3. Click the workbook Menu and select Workbook Properties.
4. In the Open as a Viewer field, click Off for the workbook to open in edit mode by default.
5. Click OK.
6. Click Go back, then click Save.