NamedRange.AllocateChanges Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Performs a writeback operation for all edited cells in a named range based on an OLAP data source.
public:
void AllocateChanges();public void AllocateChanges ();abstract member AllocateChanges : unit -> unitPublic Sub AllocateChanges ()Exceptions
This method is used in an Excel 2007 project.
Remarks
The AllocateChanges method will execute an UPDATE CUBE statement for all changes made in the named 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.
Note
This method appears in IntelliSense in Excel 2007 projects that target the .NET Framework 4. However, this method cannot be used in Excel 2007 projects.