NamedRange.AllocateChanges Method
Visual Studio 2012
Performs a writeback operation for all edited cells in a named range based on an OLAP data source.
Assembly: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
| Exception | Condition |
|---|---|
| MissingMemberException | This method is used in an Excel 2007 project. |
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. |
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.
