"bloomberg and others run their code with ontime. restoring calculation mode to automatic. that's a disaster when handling solutions designed for manual calc as a full calc cycle may take long minutes..."

- if you're concerned about excessive calculations from Bloomberg, switch from in cell function calls to use the API to download the data.. that way, you have complete control over it.

- Ask the Bloomberg help desk to make you a spreadsheet...

"next question is linked somehow: onkey assigned functions can be discovered?"

not that I know of, but I think the answer to the first part resolves this for u.

"and last one... anyone knows the password for standard ms addins like analysis toolpack and solver?"

Not I.. and I wouldn't go dowloading a password cracker if you work in a financial institution. You will be hauled in front of HR before you can say "Excel Worksheet" !

If they're bothering you, you can turn them off by unchecking the addin.