Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Excel 2010 Crashing on password protected spreadsheets

Posted on 2014-04-03
3
839 Views
Last Modified: 2014-04-09
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
Comment
Question by:nologytech
  • 2
3 Comments
 
LVL 15

Accepted Solution

by:
colly92002 earned 350 total points
ID: 39982866
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
 

Author Comment

by:nologytech
ID: 39986318
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
 
LVL 15

Expert Comment

by:colly92002
ID: 39989121
Glad they sorted it for you :)
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micr…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This video Micro Tutorial is the first in a two-part series that shows how to create and use custom scanning profiles in Nuance's PaperPort 14.5 (http://www.experts-exchange.com/articles/17490/). But the ability to create custom scanning profiles al…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

792 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