When copying an Excel-constructed formula from another application (Business
Objects) and pasting it into Excel, the cell displays the formula instead of
the formula's result.

The Excel-constructed formula is:
=HYPERLINK("http://www.microsoft.com","Microsoft")

The format of the cell is set to "General", and there are no strange or
extraneous characters either in front of, or at the end of, the formula.

Yet, after I have pasted the formula into Excel, if I then press the F2 key
and then the Enter key, the result of the formula is correctly displayed
(including the hyperlink)!

Does anyone know what is causing this behavior, and how to solve this
problem so that the pasted formula displays correctly? Any help would be
greatly appreciated.

Thanks,
Bob