Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Jun 2011
    Location
    Nebraska
    Posts
    82
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Question Power-Pivot and Excel 2010

    We are installing the new Power-Pivot on 4-5 PC's in the company. One of the first we did is presenting an error. Not much out there with a Bing search, so I'm hoping for some ideas here.

    Client OS: WinXP Pro SP3
    Office 2007 Pro Plus
    Excel 2010 (side-by-side with Excel 2007) - version: 14.0.6029.1000
    MS SQL Server 2012 Power-Pivot for Excel (32-bit) - version: 11.0.2100.60
    Prerequisites: .NET Framework 4 & Visual Studio 2010 Tools for Office Runtime x86 - version: 10.0.31119

    The error is:
    Embedded Analysis Services Engine: Could not open Embedded PowerPivot Data

    Note: It works fine on the developer's PC (running WinXP Pro SP3).
    Mike W.
    Location: A Great Plains State

  2. #2
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts

    I had a simular problem years ago.

    I have the French interface so this is just a good guess. Years ago I had a similar problem, nonetheless check with the developer, have the developer open the pivot table, then go to the options tab, and under pivot table options there is a data options tab and make sure the third box is checked. In 2010, it should say something close to Ğrefresh the data on opening" and then save, then try and open it. I do not have the English interface to quote the correct label. I hope this helps. Richard

  3. #3
    Star Lounger
    Join Date
    Jun 2011
    Location
    Nebraska
    Posts
    82
    Thanks
    9
    Thanked 0 Times in 0 Posts
    Thanks, I'll pass that on!
    Mike W.
    Location: A Great Plains State

  4. #4
    Star Lounger
    Join Date
    Jun 2011
    Location
    Nebraska
    Posts
    82
    Thanks
    9
    Thanked 0 Times in 0 Posts
    After much troubleshooting this morning, we found that it's a permissions issue of some sort. When we add the user to the local Administrators security group, the problem goes away. Not an ideal option, but it'll work until we find a way to move them back to the preferred Users group.
    Any ideas on what to check?
    Mike W.
    Location: A Great Plains State

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •