Enabling Writeback to SSAS in Excel 2010

With Excel 2010 it is finally possible to modify data in a SSAS cube, without using any macros or third party add-ins, and it works like a charm. This opens for a lot of common business scenarios like budgeting and planning directly from Excel 2010.

Setup is very easy. Here some few guidelines on how to enable Writeback to Adventure Works.