Downgrading From PowerPivot v2 to v1

OK, let’s say you already installed v2, whether inadvertently or…  advertently.

And now you need to downgrade to v1, so that your workbooks function on your server, or can be opened by other people running v1 on their desktops.

So… how to do that?

The Obvious Thing Works for Most People

Simple:  just uninstall v2 (from Windows Control Panel) and then install v1.

But if you see this error when you try to build a new workbook, or open an old one, well, it’s not working out:

An operation that uses the database driver could not be completed - seen after downgrading PowerPivot v2 to v1.

What to do if you get that error?

1) Open Start Menu

2) Find “Command Prompt” – it is under Accessories

3) Right Click on Command Prompt, choose Run as Administrator

4) Once in the cmd window (looks like the old DOS window), type the following:

regsvr32 “C:\Program Files\Microsoft Analysis Services\AS OLEDB\10\msolap100.dll”

You may need to correct for your actual folder location – that’s the location on my machine.  The quotes ARE required.

Read more on our blog

Get in touch with a P3 team member

  • This field is hidden when viewing the form
  • This field is hidden when viewing the form
  • This field is for validation purposes and should be left unchanged.

This field is for validation purposes and should be left unchanged.

Related Content

End the Spreadsheet Spiral and See the Full Picture

Outgrowing Excel isn’t the problem. Staying stuck in it is. If your

Read the Blog

Top Business Intelligence Tools for 2025: Which One is Right For Your Company?

The top five analytics tools for 2025? Tableau, Power BI, SAS, KNIME,

Read the Blog

Now You Can: Pivot Faster with Business Agility

Build Business Agility Into Every Process Because when things change, the last

Read the Blog

Now You Can: Spot a Slowdown Before It Hits Your Bottom Line

Hidden Economic Red Flags in Your Data You don’t need a news

Read the Blog