Show TOC

Offline ModeLocate this document in the navigation structure

You can make the current workbook an offline workbook so that any user can access it, even users who do not have the EPM plug-in installed. An offline workbook behaves like a standard Microsoft Office Excel workbook.

To switch to offline mode, select Start of the navigation path EPM Next navigation step Offline Mode End of the navigation path. The context bar and the pane are automatically hidden. You can make your workbook available to any user.

There are two types of offline modes.

Note The offline feature is used in an automatic way when distributing reports.
Note Specific case: a workbook that contains EPM functions is automatically switched to offline via the distribution process. When switching back the workbook to online mode, you need to perform a refresh to update the EPM functions.
Offline Mode with Worksheet Protection
Note This offline mode can be used for data input purposes.

By default, all the worksheets of an offline workbook are automatically protected. This is to prevent important elements of the reports from being changed, moved or deleted. For more information about worksheet protection, see Worksheet Protection.

You can choose to protect only the worksheets that contain EPM reports. To do so, select the option Protect only Sheets Containing EPM Reports in the Others tab of the User Options before switching to offline mode.

Static Offline Mode without Worksheet Protection
Caution This offline mode cannot be used for data input purposes.

If you do not want the worksheets to be protected, select the Static Offline without Protection option in the Others tab of the User Options before switching to offline mode. The option Static Offline without Protection is available for selection provided that the option Protect only Sheets Containing EPM Reports is selected.

A copy of each worksheet is automatically performed and only the copied worksheets are displayed in the workbook. In the copied worksheets, all the EPM member formulas appear as text. The reports can be modified in the copied worksheets by using standard Microsoft Excel features. When switching back to online mode, the modifications are not kept and the initial EPM reports are displayed because the copied worksheets are deleted and only the initial worksheets are switched to online mode.

Note The worksheets considered as "very hidden" by Microsoft Excel are not copied.