Range.AllocateChanges Method (Excel)
Performs a writeback operation for all edited cells in a range based on an OLAP data source.
Version Added: Excel 2010
expression A variable that represents a Range object.
The AllocateChanges method will execute an UPDATE CUBE statement for all changes made in the range since the last apply changes operation was committed. This method generates a run-time error if it is executed on a range based on a non-OLAP data source.