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

Click to Read Bob Phillips, Excel MVP, Writing About Cube Formulas in PowerPivot

Rob Collie

One of the founding engineers behind Power Pivot during his 14-year career at Microsoft, and creator of the world’s first cloud Power Pivot service, Rob is one of the foremost authorities on self-service business intelligence and next-generation spreadsheet technology.

This Post Has 3 Comments

  1. 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?

  2. 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 Comment or Question