Problem with Excel charts in Access 2007 report

C

Chris

Hi there,

I have an Access database developed in Access 2002 (XP).

The db has reports which contain links to charts in Excel spreadsheets
(unbound objects, linked so updates when Excel changes).

When running Access 2002 this all worked fine.

I've since got a new laptop with Access 2007, and now the report only
displays a small part of the linked chart from the Excel sheet - just the top
corner (4cm by 8cm) rather than the whole chart.

As a test, with straight data, it shows everything, it's just charts that
don't display properly.

For the life of me I cannot figure out why, and cannot fix it. I've changed
the clip/zoom settings, tried converting the DB to 2007, tried saving the
Excel charts as 2007 files, have even tried a new blank report, linking to a
new fresh test Excel file with simple chart, same problem.

All Office 2007 updates applied.

Any ideas? All help appreciated.

Thanks,

Chris
 
C

Chris

Can no one help with this?

Any chance someone could at least try to replicate the problem, to prove I'm
not going mad, even if you don't know the solution?

Just create any old graph of a decent size in Excel, and try to link to it
from an unbound object frame in an Access report ... see if you can get the
full graph to display.

Would very much appreciate it, thanks.

Chris
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top