Write-back Using PowerPivot

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active
 

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...

Tags: excel, design, writeback

 

2007-2015 VidasSoft Systems Inc.