I have serious issue when trying to insert a linked Excel 2010 chart into an Access 2010 Report.
I have:
-
[*]created the chart in Excel 2010 (32 bit on Windows 7 Ultimate 64 bit)
[*]selected and copied the Excel Chart
[*]in Access, selected “Paste Special” to paste the chart into the Details section of my Report
[*]then receive the error message “The OLE server isn’t registered. To register the OLE server, reinstall it”
[*]I’ve googled endlessly without any success. Its been suggested that I need to re-install “MyControl.ocx” but can’t find “Mycontol.ocx” on my computer.
[*]Microsoft prattles on about Norton causing this issue, but Norton has never been close to my computer.
How can I identify exactly which OLE server I require?
Where can I get it?
Anyone got a solution that works?
Totally frustrated by this….
Trevor
