When you create a data model and measures in PowerPivot with PRO versions, users can modify and edit both.
Users and customers that have no idea on how the model has been build can make a lot of damage and dysfunction.
As well as VBA has it would be very interesting that Power Pivot has the option to be able to protect data model and measures with a password.128 votes
Thank you for suggesting this feature, but this is not something we’re likely to implement anytime soon. The reality is that this sort of feature only helps to keep honest folks honest, and doesn’t provide true security, because anyone with permission to a workbook can modify that workbook. For scenarios where the database really needs to be securely maintained, a better answer is to deploy the data model to either an Analysis Services server or to Power BI. By doing that, the data model (an AS tabular database) will be maintained independently of the workbook, and users will be able to connect to the database and query it from their Excel PivotTables but will not be able to modify it.
At present you cannot send the output of a pivot table without the link to the underlying data - but often I want to do exactly that - share the results without sharing the base data.
Cutting and pasting the pivot table works but loses all the careful formatting (actually worked much better up to Excel 2010, now entirely broken).
So please can we have a method of preserving the output from pivot tables but delinking them from the source?34 votes
If we break the link to the data, the PivotTable will no longer be interactive and won’t support expand/collapse, filtering, or sorting. Copy/Paste into Paint or any other graphics program will preserve an exact picture of the PivotTable with all formatting. In any event, this item isn’t likely to be addressed soon.
Please bring Calculated Table feature from Power BI into the Excel Data Model. It is very useful to create intermediary tables from DAX calculations and link those tables into the data model.84 votes
We agree that this feature would be useful for many users. The difficulty is that adding this feature would break compatibility for existing Excel users, Data models with this feature would not run in Excel 2013, 2016, or 2019. At this time, we consider compatibility to be more important than this particular feature. At some point in the future we expect to find a way to deal with this compatibility issue, but we won’t be able to address this anytime soon.
In Excel 2016 you can only group by day, month, quarter or year. Please add the ability to group by weeks or re-add the capability to group by number of days for pivot table data.20 votes
The best way to accomplish this is to add a column to your data that specifies the week. By using a custom formula, you can organize the weeks any way you want, with any starting day of the week, and also name them any way you want, whether “Week of July 10” or “Week 34” or something else. Then you can use that column in a PivotTable to see data grouped by week.
- Don't see your idea?