MS Access embed excel file on ms access form

When I tried to embed excel file on my form with this method:

Use the unbound Object frame control. When you put one on your form a wizard will open. Select "Create From File". Browse to the spreadsheet and the check the Link box.

I got error OLE has to be registered.
In my MS Access 2o13 I have reference to OLE Automation checked and Microsoft Excel 15.0 object Library checked too.
TarasAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Be sure your Office and Windows installations are fully up to date.

Also try doing the same process in a new, blank database. If you can embed the Excel file in a new database, then your original db might need to be compacted/repaired.
0
TarasAuthor Commented:
Excel 2013 file has power view map in.
When I link this file it is opening in its own window as excel application out of ms access and I can see it but on access form in unbound frame it is only white area and when I click on it I got that error  OLE Server is not registered error. Is it connected with power view map in excel, does ms access has to make reference to some other then OLE Automation and Excel object library. I have those references checked beside others.
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You shouldn't need the excel object library checked, unless you're doing other things with it. An OLE object is a "linked" object.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
TarasAuthor Commented:
Thank you
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.