Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 975
  • Last Modified:

Excel 2010 Crashing on password protected spreadsheets

I have a client who's Excel has been crashing on him regularly.  He is running Excel 2010 on a Windows 2008 R2 terminal server.  I was able to narrow the issue down to opening password encrypted spreadsheets while a particular add-in was active.    There are 10 other users who have not experienced this issue.  The clients use LaserFiche document management software which has Outlook, Word, and Excel add-ins for saving documents into it's database.

What I found was that disabling two of the LaserFiche add-ins allow Excel to work correctly. There are separate add-ins for Excel 2010, 2007, and 2003.  Disabling the 2003 and 2007 add-ins allows everything to work correctly.  If they are enabled, normal spreadsheets work fine.  Password protected spreadsheets will load Excel, prompt for a password, then after that is submitted, immediately shows "This program has stopping working".

Since the client is using 2010, I have no issue with leaving the other add-ins disabled (I don't know why they are enabled in the first place).  The problem is that every time Excel is closed, they are enabled again.  Does anyone know how to keep disabled add-ins disabled?  I'm hesitant to completely remove them as I would have to do it for all users and I hate to open that can of worms since no one else is complaining.

Are there any other routes I should be taking to address this?  I tried to reach out to LaserFiche support, but they hadn't heard of this issue.
0
nologytech
Asked:
nologytech
  • 2
1 Solution
 
colly92002Commented:
This is really really an issues for your suppliers to resolve through their support contract, however if this is not going to happen then you can attempt to disable the add-ins directly using the registry.

Have a look here and you should be able to figure out how to set the registry
http://support.microsoft.com/kb/291392

Once you know where to look in the registry using regedit then it might be easier to  set it up using the Excel COM add-ins interface and watch to see what changes in the registry.  You can then  use this to write a script that can automatically set up the registry (http://support.microsoft.com/kb/310516).

How you then deploy that script to users is dependant on your network capabilities, but you might want tit to run automatically on logon.
0
 
nologytechAuthor Commented:
Strangely, there are no registry entries for the 2003 and 2007 add-ins, which are the ones I want to disable.  Only the 2010 version shows up.

I pushed harder with the supplier (per your suggestion) and they acknowledged that the problematic add-ins aren't necessary.  They gave me instructions on how to remove them (and add them back in in case of unforseen issues).

Thanks for your response!
0
 
colly92002Commented:
Glad they sorted it for you :)
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now