BTW, if you want to read that post Ken was tweeting about (the one written by Bob Phillips, another Excel MVP), here it is:
Click to Read Bob Phillips, Excel MVP, Writing About Cube Formulas in PowerPivot
Rob Collie
One of the original engineering leaders behind Power BI and Power Pivot during his 13-year career at Microsoft, Rob Collie founded a consulting company in 2013 that is 100% devoted to “the new way forward” made possible by Power BI and its related technologies. Since 2013, P3 Adaptive has rapidly grown to become the leading firm in the industry, pioneering an agile, results-first methodology never before seen in the Business Intelligence space. A sought-after public speaker and author of the #1-selling Power BI book, Rob and his team would like to help you revolutionize your business and your career.
Comments (3)
-
I’m only a nerd-in-the-making and hv a simple Q for the powerpivot wizards out there: I have HUGE xcel file(s) already processed in powerpivot, to my total fascination. Less evolved peers, however, still want to use the traditional HUGE excel spreadsheets (the way they were before linking to powerpivot). Is there a way to add “Automatic calculated columns” from powerpivot back into the excel table? Tried copy and paste but it did not complete successfully. I guess I’m looking for a reverse ‘refresh’ function. There! Anybody home?
-
I am not sure if this is what you are looking for, but check this article out. Note that this is Excel 2013 only though:
https://www.sqlbi.com/articles/linkback-tables-in-powerpivot-for-excel-2013/
-
PPPro, you rock. That is exactly what I need, though 2013 is definitely not a possibility just now. Glad to see the ‘powers’ thought it was an interesting enough feature to introduce it in Excel 2013. This so validates my ‘nerd-in-the-making’ persona. HA!
Leave a reply
Your email address will not be published.