Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Excel 2010 Crashing on password protected spreadsheets

Posted on 2014-04-03
3
Medium Priority
?
939 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
[X]
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
  • 2
3 Comments
 
LVL 15

Accepted Solution

by:
colly92002 earned 1050 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
: 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…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

688 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