Wednesday, March 15, 2006

Opening Excel from an email in Outlook

I came across this problem today where Excel by default opens a s a 'Read Only' when opened from an email.

This is because the macros of the sender of the email are set to 'High'. This option automatcially sends the excel attachement in the email as 'Read Only' file making it difficult for the user to make changes.

This problem can be overcome by setting the Macro Security to Low in the Senders outlook. To do this, go to Tools -- Macro -- Security -- Choose Low and save the setting.

No comments:

Two ways to reset the identity of a table in sql server.

I know of the following two ways to reset the identity of a table in sql server. You often tend to use dummy data during the course of y...