Problems in importing excel to powerpivot

[nurul91]

Dear guys,
This is the first time i use PowerPivot.

All of my data is on excel format. I cant find anyway to import it to PowerPivot.This was what i did

Get external data --> from other sources-->excel file--> choosing my file-->finish and i failed. This message appears

"Failed to connect to the server. Reason: Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified."

What should i do?

 

[scottsen]

Can't say I have ever seen that one before Super weird. Try to re-install I guess...

 

[olivierhbh]

Hello Nurul,

Have you checked Google about that? If not have a look at the solutions provided in these results:
https://www.google.ch/search?es_sm=...1.1.0....0...1c.1.64.serp..1.1.87.of8XIkmjNds

It looks like a .NET Framework problem.

Olivier.