Thursday, July 29, 2010

Disable the Excel prompt for opening formats different than the extension

many web sites export tabular information from grids/tables into 'Excel' format. the file is not a true Excel format and actually contains X/HTML. if the file is opened in Excel 2007 you may get a prompt that the file is in a different format than specified by the file extension.


If you regularly work with files like this, there is a way to disable this prompt, add a DWORD key called ExtensionHardening with value 0 to
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security

Change where sent e-mail messages are saved when using an Exchange account

By default, a copy of each message that you send is saved in the Sent Items folder.


When you reply to or forward an e-mail message that is saved in any folder other than the Inbox, you can configure Outlook to save a copy of the sent message in the same folder as the original message.

1. On the Tools menu, click Options, and then on the Preferences tab, click E-mail Options.

2. Under Message handling, the Save copies of messages in Sent Items folder check box must be selected.

3. Click Advanced E-mail Options.

4. Select the In folders other than the Inbox, save replies with original message check box.