Office Excel 2007 - Server 2008 Automation Permission problem

Posted on 2009-12-23
Last Modified: 2012-08-14

I know server automation is not supported by microsoft, and that is also why I'm asking this here. So I have this excel automation going on in Server 2003 and everything works fine. Excel starts up on the server, does something and it'll close down.

Different story on Server 2008. Seems to have way more security issues. Word and PowerPoint worked fine,  but when Excel starts up, it gets stuck. The process is running but just hangs. This is when I run a webpart on sharepoint on my laptop. Now if I log onto the server and run the webpart on the server's browser, everything works fine again. So this must have something to do with permissions.

I opened up dcomcnfg and changed launch/access permissions on the Office Excel component but still no dice. Something I found interesting is when I changed the registry (HLM\software\microsoft\windows nt\currentversion\profilelist\s-1-5-18\profileimagepath) to point to C:\Users\-Myself- instead of the default %systemroot%\system32\config\systemprofile, it works for me! and noone else. That is probably the user profile is only accessible for me.

I've probably tried more stuff but don't remember what. Anything else I can try?

Question by:SOS_Helpdesk
    LVL 12

    Expert Comment

    Im confused why are you running server 2008 and using office on it?  I would say try to uninstall excel 07 and reinstall it.  you could also try another login and see if its just the profile acting up.  

    Author Comment

    Thanks for your reply.

    I need to use office on the server to build word, excel, and powerpoint files. The whole process is automated and microsoft explicitly said they do not support this and have a support page explaining why. We got this to work perfectly in Server 2003 so it should be the same in Server 2008. I think it's just some permissions 2008 have that we need to grant specific users/groups and we are good to go. I was hoping someone here can point me in the right direction of what permissions I'm overlooking.

    I tried reinstalling office but no luck. I also tried using several accounts with different permissions, no luck.

    Please help!

    Accepted Solution

    Solution I've found is to go into DCOMCNFG's COM Security and give Access Permission and Launch and Activation Permissions to the user or group that uses Excel. Done!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
    You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
    The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
    This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now