Online/Offline
When you are not connected to your Central Point, Online/Offline keeps your reports accessible as a static snapshot of your data. While offline, you can open and review existing reports, but live features such as prompts and data extractions are unavailable until you reconnect.
note
The button label updates automatically to reflect your current state.
When to go offline
- Reduce server load by reviewing reports without triggering data refreshes or server calls.
- Work without a connection when traveling or in a low-connectivity environment.
- Share a fixed snapshot with recipients who do not have access to the Central Point.
Switch to offline mode
- In the Add-ins tab, select Online.
- The button switches to Offline, confirming you are now disconnected.
- All
NecAccessformulas are disabled while offline. - Selecting Refresh Formulas while offline displays #Offline in those cells.
- All
Return to online mode
- In the Add-ins tab, select Offline.
- The button switches to Online and all formulas in the Excel file refresh automatically.