Solved

Excel 2010 Crashing on password protected spreadsheets

Posted on 2014-04-03
3
800 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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
In a previous article here at Experts Exchange (http://www.experts-exchange.com/articles/18414/Create-a-PDF-file-with-Contact-Sheets-montage-of-thumbnails-for-all-JPG-files-in-a-folder-and-each-of-its-subfolders-using-an-automated-batch-method.html)…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

708 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

19 Experts available now in Live!

Get 1:1 Help Now