| Write-back Using PowerPivot |
| Written by Ken Puls |
| Friday, 11 March 2011 19:09 |
|
In a discussion about PowerPivot yesterday, one of my friends stated that it wasn't really useful since you couldn't perform writeback using PowerPivot. To him this is a very important piece in the Excel budgeting process. Now, I agree that PowerPivot doesn't give you write-back to a database, but this got me thinking. we have linked tables, so why couldn't we create a write-back loop for a model that was built entirely in Excel? Well, we can! Read more... |
Comments (1)
1
Monday, 29 August 2011 08:07
Istvan Bartalos
Check out power-planner.com. They offer a complete PowerPivot Budgeting soulution for a low price.
Most Popular
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- List of PowerPivot DAX functions with description
- How to install PowerPivot for Excel and list of know issues
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- List of PowerPivot DAX functions (short)
- Learning PowerPivot and DAX
- PowerPivot's impact on BI pros?
