Powerpivot - yeaaaaaaaaa. I use powerpivot where ever I can. If I had a report with pivot tables, and this report was driven from a table that contained loads of vlookups, I have now replaced all of these reports with power pivot and by removing all the vlookups and powerpivot its self, my files are all much smaller
RE: Finding Your Way around Power Pivot - An Orientation
You are viewing a single comment's thread from:
Finding Your Way around Power Pivot - An Orientation
Power Pivot does have the ability to compress files, which is really good, that with the ability to remove lookups rocks. Did you know that power pivot also removes the excel row limit ;-)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit