This example shows an input template that can be achieved using XL3DoWriteback.
While this template has a single column, and writes back for 5 members on 3 dimensions, the same concept could be applied to many members. To use it:
- Enter the new values in column C. These could be entered by:
- Directly typing the values
- Copy and paste from another document
- Formula calculations based on other values
- XL3Lookup formulas
- Select the XL3Link in cell A1, which updates B1 to be TRUE.
The XL3DoWriteback formulas in column E are triggered. The writeback speed can vary depending on your cube
- When the writeback is complete, cell B1 is automatically reset to FALSE.
The finished input template:
The finished input table:
