ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

ChemDrawExcel12.xla could not be found

Updated on November 20, 2014
The software in question, which has faulty uninstallation
The software in question, which has faulty uninstallation

If you have used ChemOffice2010, and then proceeded to uninstall the whole thing and get error when you use Windows Excel or preview an excel file, you've come to the right place.

Every time I click a excel file, in the file previewer in Windows folder I get this error with a pop-up message saying:

C:\Program Files\CambridgeSoft\ChemOffice2010\ChemDraw for Excel\ChemDrawExcel12.xla could not be found

Chinese user having problems with Chem Draw uninstallation
Chinese user having problems with Chem Draw uninstallation | Source

It's not only annoying but makes me worried as to the uninstaller that CambridgeSoft makes. Afterall searching "Cambridgesoft" in my registry editor found alot of left behind registry values and folders after uninstallation. I followed the direction on how to fix this problem from the PerkinElmer Informatics forum but it didn't help me. I followed their directions. First I went to registry editor by typing "regedit" from Start -> Run Then I followed the directions:

  1. In the left pane of the Registry editor, expand HKEY_LOCAL_MACHINE and then expand Software. Select the CambridgeSoft folder and then delete this folder and its contents.
  2. Now expand HKEY_CURRENT_USER and then Software folder. Select the CambridgeSoft folder and delete this one as well.

But the problem didn't go away.. I restarted and still the same problem. I did some digging, went back to registry and searched for "CambridgeSoft" and to my surprise there were a ton of these folders all over the place. I didn't want to break my computer so I searched carefully and found the registry setting to fix to clear this problem. This has been tested on Windows 7 x64, I can't guarantee that it will work on any other system and am not responsible if anything breaks, you should backup your registry before editing.

Go to the following location.

HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Options

Not sure how to get there?

  1. First hit Start -> Run -> Type in "regedit"
  2. In the left panel of the Registry Editor, expand HKEY_CURRENT_USER
  3. A tree showing many folders should appear, expand the folder Software
  4. Expand Microsoft folder, then expand Office folder
  5. expand 14.0, and then expand Excel, and then Options folder

Inside the Options folder, on the right side there were two registry keys "OPEN" and "OPEN1". When i double clicked OPEN, I found this value:

"C:\Program Files\CambridgeSoft\ChemOffice2010\ChemDraw for Excel\ChemDrawExcel12.xla"

I replaced that with:

/R "C:\Program Files (x86)\Microsoft Office\Office14\Library\Analysis\ANALYS32.XLL"

and hit OK, Next I saw OPEN1 registry key beneath OPEN, i double clicked that as well as saw something similar to this: "/A ChemDrawExcel12.cla"

I went and replaced that with

/R "C:\Program Files (x86)\Microsoft Office\Office14\Library\Analysis\ATPVBAEN.XLAM"

and hit OK, that's it.

I rebooted and clicked on a Excel file to preview, and no pop-ups.

This was tested on Windows 7 x64.

Comments

    0 of 8192 characters used
    Post Comment

    • profile image

      Someone 

      4 years ago

      This solved my problem. Thank you! (Windows 7 X32)

    • profile image

      blackoutchili 

      5 years ago

      thanks, that helped me a lot,

      had the same annoying error

    working

    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, hubpages.com uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: https://hubpages.com/privacy-policy#gdpr

    Show Details
    Necessary
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
    CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the googleapis.com or gstatic.com domains, for performance and efficiency reasons. (Privacy Policy)
    Features
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Marketing
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Statistics
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)