FAI-Moving the code to the report detail format event appears to achieve the desired result except that the ole object is not saved and will return to the last saved design view state when report is closed. The REM code is my feeble attempt to work around that. TA-SAL
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Dim ctl As Control, wkb As Workbook, wks As Excel.Worksheet
Set ctl = Me.OLEUnbound85
ctl.Verb = acOLEVerbHide
ctl.Action = acOLEActivate
Set wkb = ctl.Object.Application.Workbooks("Worksheet in " & Me.Caption)
Set wks = wkb.Worksheets(1)
wks.Cells(22, 4).Value = "test7"
'wkb.Save
'ctl.Requery
'ctl.Save
'Me.Application.DoCmd.Save acReport, Me.Name
Set wkb = Nothing
ctl.Close
Set ctl = Nothing
End Sub