Do recepients of a PowerPivot Report need to have Excel 2010 and PowerPivot installed to view

wells146

New Member
Joined
Sep 5, 2008
Messages
30
Hello MrExcel community!

I have just discovered the Power of PowerPivot from MrExcel's You Tube pod casts and I have already downloaded and have begun using it. My question is... if I create a PowerPivot report and send to a user who does not have PowerPivot installed and is running a lower version of Excel, will they still be able to use the file and filter by the slicers etc...?

Thanks,
Greg
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,496
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
If they are running a version pre 2010, they can't use slicers; pre 2007 I don't think the pivot table will be a working pivot either.
 

wells146

New Member
Joined
Sep 5, 2008
Messages
30
Thanks Rory. Our company does have office 2010 available for upgrade but they do not force the upgrade on everyone. (they will eventually) Most employees will still be on Excel 2007. I will try a test with a couple of users and see what results I get. I appreciate your quick response.

Thanks,
Greg
 

powerpivotpro

Board Regular
Joined
Jan 18, 2012
Messages
242
The pivots won't work in 2007 - they won't be interactive at all.

If someone has 2010 but they don't have the addin, again, the pivots won't be interactive.

In order to be interactive, the user must have 2010 AND the addin.

More info here:

http://www.powerpivotpro.com/2010/12/powerpivot-for-excel-2007/

Of course, if you have a PowerPivot server or hosting service, the users only need a browser and they get interactivity :)
 

wells146

New Member
Joined
Sep 5, 2008
Messages
30

ADVERTISEMENT

Thanks for the confirmation Rob. I guess I will have to encourage our folks to download Office 2010 and PowerPivot add in.

Regards,
Greg Wells
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,496
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Thanks for the confirmation Rob. I guess I will have to encourage our folks to download Office 2010 and PowerPivot add in.

Regards,
Greg Wells

If they are having on 2007, it shouldn't take much urging to get them to move up to 2010. ;)
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,496
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS

ADVERTISEMENT

The pivots won't work in 2007 - they won't be interactive at all.

Thanks for the correction, Rob - good to know (well bad, but you know what I mean!)
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,496
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
I still suck at PowerPivot (for the moment, hopefully) though! :)
 

Watch MrExcel Video

Forum statistics

Threads
1,108,738
Messages
5,524,545
Members
409,583
Latest member
gkarthick

This Week's Hot Topics

Top