Embed Excel 2007 Pivot Table in Form

[mrlddst]

Is it possible in Access 2007 to embed a Excel 2007 pivot table into a form and link it to the tables in the same database? I keep getting a database in use error. I don't want to use the pivot table form as I am unable to format it as the users would like it.

[June7]

Never tried but my guess is no.

[mrlddst]

Well is there a way to use the pivot table in excel instead of the pivot table form in the same access database?

[ItsMe]

You could try a web browser control. If that does not work, I will guess no. But, I will just guess no right now anyway.