Export (0) Print
Expand All
Expand Minimize

2.4.217 RefreshAll

Office

The RefreshAll record specifies whether external data ranges, PivotTables and XML maps will be refreshed on workbook load.


0

1

2

3

4

5

6

7

8

9
1
0

1

2

3

4

5

6

7

8

9
2
0

1

2

3

4

5

6

7

8

9
3
0

1

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.

Show:
© 2014 Microsoft