Compartir a través de

2.4.217 RefreshAll

  • Artículo

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.