Using OLE frame with an Excel sheet for a report template

[Sajit]

I am trying to use an Excel file as a template for an Access report.

I Linked the Excel template file through an OLE frame with the properties
set as follows:

Source Doc : C:\sajit\test.xls
Source Item : test1

where test1 is the Excel range name in the sheet in which the template is.
I also have other sheets which are used as templates for other reports. The
templates were made by making a 'Copy' 'Sheet' from the previous sheet, each
sheet contains one template range. The range have been named unique to each
sheet.

When I preview the report, Access picks the wrong template, even though the
filename and the range name specified in properties are correct. Access
picks the template from the sheet with which I closed the Excel file.

The file is linked since there are changes that come to the layout of the
template format.

I also have the control source table for the report also linked to an Excel
sheet. Here the reason for using Excel is that it allows the flexibility of
editing data in a data sheet view.

Does anyone know a work around this problem?

Sajit
Abu Dhabi