Skip to main content

How to Re-enable DataSnipper in Excel

The DATASNIPPER ribbon has disappeared from Excel. Follow these steps to get it back.

Introduction

In rare cases, the DATASNIPPER ribbon stops appearing within Excel. Excel can detect add-ins that slow down performance and disable them automatically. Follow the steps below to get back to snipping.

Step 1: Re-enable DataSnipper

  1. Click File at the top left of Excel.

  2. Click Options.

  3. Click Add-ins.

  4. In the Manage drop-down, choose Disabled Items and click Go.

  5. Locate the DataSnipper Excel Add-in in the list.

  6. Click Always enable this add-in.

Step 2: Installation issue

If DataSnipper does not appear in your Add-in list at all, DataSnipper might not be installed. Please contact your IT department about the installation of DataSnipper.

Step 3: Re-activate Add-in

  1. Click File > Options > Add-ins.

  2. In the Manage drop-down, choose COM Add-ins and click Go.

  3. If the checkbox next to the DataSnipper add-in is cleared, click it to select it, then click OK.

Step 4: Load Behavior issue

If you see a Load Behavior error when trying to activate DataSnipper, it is caused by a missing library. Contact your IT department and ask them to install .NET version 4.7.2 or higher.

Step 5: Conflict with another Add-in

  1. Click File > Options > Add-ins > COM Add-ins > Go.

  2. Uncheck all add-ins except DataSnipper, then click OK.

  3. Restart Excel. Your DataSnipper tab should now be visible.

Did this answer your question?