You are viewing a single comment's thread from:

RE: Finding Your Way around Power Pivot - An Orientation

in #excel5 years ago

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

Sort:  

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 ;-)