I have built a couple databases in Access 2003 that contain charts. I gather the data in a query (or two or three) and use a transfer spreadsheet macro to export the information to Excel, which puts the chart together. When the report is opened in Access, the chart shows up as an OLE Unbound picture. This has always worked great since charting in Access is so limited.
Last week I converted to Access 2007. Since then, when I open these reports, either no chart shows up at all, or just the upper left corner is on the report. I have allowed all content into the trusted zone, and double checked all of the paths, changing the excel extentions to xlsx. This is happening to all of my charts, even though they seem to be showing up ok in excel, they aren't showing up in Access. Can anyone let me know what I'm missing?
As always, thanks for your help.