My office 2010 does not have some of the function of Powerpivot (EVALUATE, SUMMARIZE Etc.). Is this not available to office 2010?
Asked
Active
Viewed 32 times
1 Answers
0
EVALUATE is not a function. SUMMARIZE() is available in the most recent version of Power Pivot for Excel 2010.
It sounds like you've got the SQL Server 2008R2 version of Power Pivot installed. You want the SQL Server 2012 SP1 version, available here.
greggyb
- 3,728
- 1
- 11
- 32
-
Thanks...I've been searching for this answer but can't find – Loku Jan 29 '16 at 04:18