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:

INSERT EXEC failed because the stored procedure altered the schema of the target table.

This morning I was trying to call a stored procedure and insert the results in a temp table using the following code  -- create table #...