I have two SQL database tables that are linked up together in Excel Power Pivot and work great just as expected. Filter, sort, etc... Everything works. I want to use Power Pivot to manage the actual data within the database. I want to be able to change the data from within the Pivot Table view and have it save back to the database. How can I set up excel to allow me to read/write/save data from within Power Pivot? If it is not possible what Excel addin can I get that will allow me to manage my SQL data? I would prefer a product that would give me Pivot Table like capabilities, but allow me to edit the data and save it to the data source. Thanks!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How do I modify/edit Pivot Table data
- Thread starter tbucki1
- Start date
