Excel Charts in a report (1 Viewer)

[Garyrpollitt]

Is there a way to create a report which links to 3 different excel sheets all showing different charts. I can do a hyperlinkm to excel. But I want to open a report with the charts already their

 

[Adrianna]

Insert the excel reports into the report, using INSERT --> OBJECT --> From File

This will place your reports directly into our report.

Do make sure that you select "Linked" if you plan for the data to change from time to time. That way you only have to update the report in excel and not in access too.

Adjusting the page setup may be the most challenging part!

 

[Garyrpollitt]

Thanks A, but this will only link to the first sheet or the sheet that had the focus when Excel was saved. I have charts on 3 different sheets, and each Excel spreadsheet is saved as data1.xls,data2.xls,data3.xls etc. Therefore when I open a report I will say I want to see the 3 charts from data3.xls in an Access report, so the variable is data? etc. I cannot see what use 'Source Item' in the properties, it works with a form but not with reports. Thats why I thought use code to open excel , highlight the sheet I want , copy it, then (this bit I cannot do) is copy it as a picture into the relevant table, any ideas ?