Use offline mode to get the data from the cache instead of the live source.

Syntax

Connect-ExcelOnline -Offline SwitchParameter

Data Type

bool

Default Value

false

Remarks

When Offline = true, all queries execute against the cache as opposed to the live data source. In this mode, certain queries like INSERT, UPDATE, DELETE, and CACHE are not allowed.