2.4.217 RefreshAll
The RefreshAll record specifies whether external data ranges, PivotTables and XML maps will be refreshed on workbook load.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
refreshAll |
|||||||||||||||||||||||||||||||
refreshAll (2 bytes): A Boolean (section 2.5.14) that specifies whether to force refresh of external data ranges, PivotTables and XML maps on workbook load. MUST be a value from the following table:
-
Value
Meaning
0x0001
Force refresh of external data ranges, PivotTables and XML maps on workbook load.
0x0000
Do not force refresh of external data ranges, PivotTables and XML maps on workbook load.
-
MUST be 0x0000 if workbook is not a template.