Error when opening Embedded Excel File in Word

[doodles82a]

My workbook works fine. However, after I embed my workbook, as an
object, in a word document, my attempt to open my workbook yields an
error when I respond in the affirmative to enable macros. The error is
as follows:

Error # 1004 was generated by VBA Project method 'Calculation' of
Object '_Application' failed.

Once I press the OK button, the application seems to work fine. What's
causing the error? I'd like to alleviate the issue that is causing the
error to avoid confusion for other users.

Thank you!

Michael

 

[Joel]

Because you are getting an error without doing anything an Event trigger
macro is failing. It is probably in a Wrokbook Open Event which would be
located in the THISWORKBOOK module of the Excel workbook. without seeing a
macro code I can't tell what the solution would be.