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:

Step By Step Guide to resolve SQL server connection issues when connecting from R Studio

Yesterday I tried using a couple of  RevolveScaleR functions -- RxSqlServerData and RxImport.in Rstudio.  These are my learnings as part of ...