locked
Why can I only run PP for Excel (32bit) with admin creds ? RRS feed

  • Question

  • I have installed this for a team here at UW med, and it only opens correctly with admin credentials.

    All my customers get an error:

    So what would this indicate?

    I would think I have all the pre-req's satisfied as it does open with admin rights.

    (PP-32bit for Excel 2010 32-bit, XP SP3 32-bit, shared tools, .net 3.5+)

    Any help would be a huge help, as this team is pretty excited about getting to work.

    Thank you,

    ~ Mark

    Wednesday, November 2, 2011 8:41 PM

Answers

All replies

  • What's your data backend? Does it allow annoymous access?


    -- This posting is provided "AS IS" with no warranties, and confers no rights
    Friday, November 4, 2011 6:58 PM
  • This error is what they get just trying to open PP.

    To be clear, it when they click on the PP button, as a non-admin, this is the error they get.

    So they never get a chance to point it anywhere, no matter what they had hoped to use for the backend.

    For example, my team installs Office 2010 for them (workstation admins), and as normal users, they can open/use/save Excel.

    So my question is that basic.

    I installed this for them, and so far, they can't use it.

    <sarcasm>

    It did create some cute little buttons on the toolbar though, they were hoping for a little more.

    </sarcasm>

     


    Mark Woodward Senior Computer Specialist UW Medical Center IT Services Harborview Medical Center
    Friday, November 4, 2011 9:18 PM
  • Can you try to add environment variable VSTO_SUPPRESSDISPLAYALERTS with value 0? Then try the same scenario and see if there's an error dialog? Does this repro on a XP workstation not under domain (ie., not under IT control?)


    -- This posting is provided "AS IS" with no warranties, and confers no rights
    Friday, November 4, 2011 9:46 PM
  • Hi again,

    Well, I have re-imaged a new PC with a Vanilla XP SP3 image.

    Installed the Vanilla Office 2010 with ALL the shared tools.

    Installed .net 3.5 SP1

    I added the above environment variable, value 0

    On this PC, the PP tab won't appear at all.

    I get "An addin could not be found or could not be loaded"

    Reason: "the application domain could not be created"

     

    So I'm very surprised it loaded on our domain PCs at all.

    I'm feeling that this isn't ready for prime time with all of the errors, and tweaks I have read about on the net.

    I have over 20 hours of just trying to get it to open.

    So I wonder if I ever get past that, if it will ever even run.

    Not to mention, that if the staff ever need anything updated, it will surely break PP.

    .net 4 for example

     

    Unless I can get some straight answers, I'm done.


    Mark Woodward Senior Computer Specialist UW Medical Center IT Services Harborview Medical Center
    Thursday, November 10, 2011 12:36 AM
  • So this is the log from the last attempt:

    Customization could not be loaded because the application domain could not be created.


    ************** Exception Text **************
    Microsoft.VisualStudio.Tools.Applications.Runtime.CannotCreateCustomizationDomainException: Customization could not be loaded because the application domain could not be created. ---> System.BadImageFormatException: Could not load file or assembly 'Microsoft.AnalysisServices.XLHost.Addin, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. This assembly is built by a runtime newer than the currently loaded runtime and cannot be loaded.
    File name: 'Microsoft.AnalysisServices.XLHost.Addin, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'
       at System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)
       at System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)
       at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
       at System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
       at System.Reflection.Assembly.Load(String assemblyString)
       at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.DomainInitializer.ActivatePipeline(String addInAssembly, String addInClass, String[] pipelineInfo)
       at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.DomainInitializer.StartAddIn(IntPtr hostServiceProvider, String[] pipeline, String assemblyName, String[] entryPoints)
       at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.DomainInitializer.StartAddIn(IntPtr hostServiceProvider, String[] pipeline, String assemblyName, String[] entryPoints)
       at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.LoadMafPipeline(AppDomain newDomain, IntPtr hostServiceProvider, String fullAssemblyName, String[] entryPoints, OfficeApp officeApplication, OfficeVersion officeVersion, IntPtr& executor)
       at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.CreateCustomizationDomainInternal(String solutionLocation, String manifestName, String documentName, Boolean showUIDuringDeployment, IntPtr hostServiceProvider, Boolean useFastPath, IntPtr& executor)

    WRN: Assembly binding logging is turned OFF.
    To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
    Note: There is some performance penalty associated with assembly bind failure logging.
    To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

       --- End of inner exception stack trace ---


    ************** Loaded Assemblies **************
    mscorlib
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.3625 (GDR.050727-3600)
        CodeBase: file:///c:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
    ----------------------------------------
    Microsoft.VisualStudio.Tools.Office.Runtime.v10.0
        Assembly Version: 10.0.0.0
        Win32 Version: 10.0.31007.0
        CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.Runtime.v10.0/10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.Runtime.v10.0.dll
    ----------------------------------------
    Microsoft.VisualStudio.Tools.Applications.Hosting.v10.0
        Assembly Version: 10.0.0.0
        Win32 Version: 10.0.31007.0
        CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Hosting.v10.0/10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Hosting.v10.0.dll
    ----------------------------------------
    Microsoft.VisualStudio.Tools.Applications.ServerDocument.v10.0
        Assembly Version: 10.0.0.0
        Win32 Version: 10.0.31007.0
        CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.ServerDocument.v10.0/10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.ServerDocument.v10.0.dll
    ----------------------------------------
    Microsoft.VisualStudio.Tools.Applications.Runtime.v9.0
        Assembly Version: 9.0.0.0
        Win32 Version: 9.0.30729.4130
        CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Runtime.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Runtime.v9.0.dll
    ----------------------------------------
    System
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.3624 (GDR.050727-3600)
        CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll

    ----------------------------------------


    Is there a more exact version of the runtime to get this to work?

     


    Mark Woodward Senior Computer Specialist UW Medical Center IT Services Harborview Medical Center
    Tuesday, November 15, 2011 6:48 PM
  • Thanks Mark. We will do some investigation and get back to you soon.

     

    Chu


    -- This posting is provided "AS IS" with no warranties, and confers no rights
    Wednesday, November 16, 2011 5:49 AM
  • Based on your log information, looks like you installed the CTP version of Denali. For it to work, you need .net framework 4.0. Can you install .net framework 4.0 and try again?

     

    HTH,

    Chu


    -- This posting is provided "AS IS" with no warranties, and confers no rights
    Wednesday, November 16, 2011 5:38 PM
  • Also, you need VSTO Runtime 4.0. Links are below,

    ·         .NET 4: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=17851

    ·         VSTOR 2010: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=20479

     


    -- This posting is provided "AS IS" with no warranties, and confers no rights
    Wednesday, November 16, 2011 7:55 PM
  • Well in working with the vanilla image, the error still persists.

    But not for an admin of the PC, only for a limited user.

    This would be the same problem we have with our base image that is under IT control in the domain.

     

    NOTE: I did find that it works fine on a W7 PC, but we are still testing that with our many older medical applications, and are yet to roll that out.


    Mark Woodward Senior Computer Specialist UW Medical Center IT Services Harborview Medical Center
    Wednesday, November 16, 2011 11:54 PM
  • It sounds like you suspect a credentials issue. To confirm this can you make sure that you try with admin and normal user on the same machine?

    The stack trace you show in your later message below indicates you are using a pre-release version of the upcoming release of PowerPivot for Excel. In that case, the prerequisites are as Chu mentioned below: .NET 4 & VSTO 2010, not the prerequisites you mention in your initial post. Please confirm the prerequisites you installed and, on the PowerPivot ribbon tab in Excel click on the "Settings" button and note the PowerPivot version.

    The dialog you show in your initial post generally indicates a couple of possibilities:

    • Corrupted workbook
    • Mismatch between the MSOLAP provider/embedded Analysis Services engine and the add-in code. This could happen for a number of reasons but it could be affected by other products on the same machine that install the MSOLAP provider. One thing you could try is deleting the Program Files\Microsoft Analyis Services directory and re-installing PowerPivot.

    -Ron Pihlgren
     Microsoft Analysis Services Team

     


    Thursday, November 17, 2011 10:49 PM
  • Hi Ron, yes the results seem to point to a credential issue.

    PP opens with admin creds, but not with a limited user creds.

    I have tried everything you mentioned, and a variety of order, just in case that would make any difference.

    Nothing has made any difference what so ever.

    PP version = 11.0.1440.19

    Yes, I once again deleted the MAS folder, and re-installed PP.

    Still opens just fine with admin, fails with the original error in the first post with a limited user.

    I really hope it's not a corrupted workbook, as it's empty, and a blank vanilla PC.

    Is there ANYTHING else I could try ?


    Mark Woodward Senior Computer Specialist UW Medical Center IT Services Harborview Medical Center
    Tuesday, November 29, 2011 5:26 PM
  • Is this a dead issue ?

    So this isn't ready for W-XP SP3 as advertised?

    I think this works fine for W7, but is there no fix for XP?

     

     

     


    Mark Woodward Senior Computer Specialist UW Medical Center IT Services Harborview Medical Center
    Monday, December 12, 2011 4:34 PM
  • I hope this isn't a dead issue. I'm experiencing the same admin credential issue with PP 2012 RC0. We are running XP SP3 with the correct VSTO and .NET 4 framework. Even with a new blank file I get the "Embedded Analysis Services Engine: Could not open embedded PowerPivot data" when trying to launch the PowerPivot window. Works fine if I'm in admin.

    Any correction for this?

    Tuesday, January 24, 2012 8:32 PM
  • Drew and Mark,

    After a long long delay, this has finally been figured out:

    http://blogs.msdn.com/b/as_emea/archive/2012/04/27/non-admin-users-not-able-to-use-powerpivot-for-excel-2012-on-windows-xp.aspx


    -- This posting is provided "AS IS" with no warranties, and confers no rights

    Wednesday, May 23, 2012 8:30 PM
  • My problem was the Power Pivot Tab would not display in Excel.  It was working then after uninstalling and reinstalling power piviot I couldn't get the tab to come back.   After multiple tweaks, hacks, regedits, installs, uninstalls, and kicking a chair, this is finally what worked for me:

    Reinstall the full .net 4 client found here:    

    http://www.microsoft.com/en-us/download/confirmation.aspx?id=17851

    Immediately fixed my problem

    Monday, September 17, 2012 10:35 PM