MS Access embed excel file on ms access form

Taras
Taras used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Top Expert 2014

Commented:
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.

Author

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.
Most Valuable Expert 2012
Top Expert 2014
Commented:
You shouldn't need the excel object library checked, unless you're doing other things with it. An OLE object is a "linked" object.

Author

Commented:
Thank you

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial