Subscribe Subscribe | Subscribe Comments RSS

Google
 

Archives for Office Tips category

How to disable and prevent add-ins and global templates from loading when you launch Microsoft Word.

Launching Word with the switch of /a will disable all add-ins and global templates. This switch comes in handy if Word is crashing when you try to launch it or behaving abnormally because of an add-in or template. You can launch Word in this fashion in a couple of ways. I am using Word 2003 in this example, but this method will work with Word 2007 as well.

1. Press the Windows Key + R to bring up the Run dialog and type winword /a in the box and click OK.

2. Create a shortcut that points to the location of the Word application.

  • Right-click the desktop and select New > Shortcut.
  • Click Browse and select the location where Microsoft Word is installed. On my computer it was “C:\Program Files\Microsoft Office\OFFICE11\winword.exe”.
  • Click OK once you have selected where the winword.exe file is.
  • The path should now be in the field for Type the location of the item:.
  • At the end of this line, put a space and then type /a.
  • Click Next and type in a name for the shortcut. Click Finish when you are done.

Now you should have a nice Word icon that you can use that will prevent any add-ins or global templates from loading.

See also:
Enable or disable add-ins in Office programs

You get the following error when you try to install Office 2007:

Error 1935. An error occurred during the installation of assembly component {10CD20D2-733E-4174-9D02-2C6C26163DA5}.

This problem usually occurrs because there is something wrong with the .NET framework installation.

1. Click Start > Control Panel > Add or Remove Programs.

2. Find Microsoft .NET Framework, and then click Change/Remove.

3. Click Repair, and click Next.

If that doesn’t solve the problem, you may want to try downloading and reinstalling the .NET Framework again.

How to insert a date in Word 2007 that automatically updates itself based on when it was created, printed or saved.

1. On the Office ribbon, select the Insert tab.

2. Under the Text group, click Quick Parts > Field.

Quick Parts, Insert Field

3. Under the Categories box, click Date and Time.

Select field names and format

4. In the Field names box, select CreateDate, PrintDate, or SaveDate.

5. Select the date and time format that you want in the Date formats box.

6. Click OK when ready.

Now the date in your document will be inserted into the document and will update automatically based on the selection you made.

Enable the Track Changes feature in Word 2007.

1. While in the document, On the Review tab, under the Tracking group, click Track Changes.

2. Make the changes you wish to make. You can also add your own notes.

How to assign a picture to a contact in Outlook 2007.

1. In Outlook, select the Contacts folder.

2. When you are in an existing contact or create a new one, click the Contact tab.

3. In the Options group, click Picture. Click Add Picture.

4. Browse to the picture you wish to use and double-click it.

Enable or disable Outlook 2007 from autosaving your email messages to the Drafts folder automatically.

1. In outlook click Tools > Options.

2. In the Preferences tab, under E-mail, click Email Options.

3. Check or uncheck the box for Automatically save unsent messages option.

4. Click OK, then OK again.

Excel 2007: Protect a Workbook

How to protect a workbook and disable the options in Excel 2007 to Insert, Delete, Rename, Move or Copy, Hide, and Unhide.

Perform the following steps:

1. Open the workbook and click Review > Changes > Protect Workbook.

2. Under the Protect Workbook dialog box, click Structure. You can set a password if you wish.

Now when a user right-clicks in the workbook, the Insert, Delete, Rename, Move or Copy, Hide, and Unhide options, they will be grayed out.

Does Word 2007 regularly detect words that you commonly use as misspelled words? You can change this by adding the word to the dictionary.

1. Expand the Office Quick Access Toolbar and select More Commands… .

Office Bar - More Commands...
Read more… »

I don’t like Word 2007 telling me what to do. It autocapitalizes things that I don’t want it to. I can capitalize my own work thank you! You can change these settings to your liking by performing these steps.

1. Expand the Office Quick Access Toolbar and select More Commands… .

More Commands

2. Click Proofing and then click the AutoCorrect Options… button.

Word Options

3. Here you can check the boxes to customize what you want Word to automatically capitalize.

  • Correct Two Initial Capitals
  • Capitalize first letter of sentences
  • Capitalize first letter of table cells
  • Capitalize names of days
  • Correct accidental usage of caps lock key

You may also set Exceptions if you don’t want these settings to apply to certain words.

AutoCorrect Options

4. Click OK, then OK again when you are done.

These settings are also located other Office 2007 applications such as Excel and PowerPoint.

You can also see how to turn off capitalization in older versions of Office applications.

Print attached files without opening the email or the attachment in Outlook 2007.

1. In the Inbox, highlight the email that contains the attachment(s) you wish to print.

2. Click File > Print.

3. Put a check in the Print attached files check box. Click OK.

How to enable the Delegates tab or the Add button when they are missing in Outlook 2007.

1. Under Tools, click Trust Center, and click Add-ins.

2. In the Manage list, click Exchange Client Extensions, and then click Go.

3. Under Add-In Manager dialog box, select the Delegate Access check box.

If Delegate Access is not listed, the add-in has to be installed.

1. In the Add-In Manager dialog box, click Install.

2. Select dlgsetp.ecf, and then click Open.

3. Click OK to close the Add-In Manager dialog box.

Outlook 2007 Date Shortcuts

You can add easily dates in Outlook 2007 using shortcuts.

You can add dates in Outlook 2007 using shortcuts. Instead of calculating or guessing dates, you can type one of the following in a date related item in Outlook 2007:

today - Todays date

yesterday - Yesterdays date

tomorrow - Tomorrow’s Date

next week - Date 1 week from today

2 weeks - Date 2 weeks from today

1 month - Date 1 month from today

1 year - Date 1 year from today

You can add the word ago to any of the above. For example, typing 1 year ago would display the date 1 year from today.

Ensure that Outlook 2007 is enabling the iPhone to connect with it. Try these steps if the sync is not working with Outlook 2007.

1. Open Outlook 2007 and click Tools > Trust Center.

2. Under Categories, click Add-ins.

3. Under Details, look for iTunes add-in under Inactive Application Add-ins.

4. In the Manage box, click COM Add-ins, and then click Go.

5. In the COM Add-Ins dialog box, select the iTunes sync add-in.

6. Click OK.

How to forward your Outlook 2007 email automatically to another email address. Useful for when you are going away on vacation, or using a different email address for a certain period of time.

1. In Outlook 2007, from the Tools menu, select Rules and Alerts. From the Email Rules tab, choose New Rule…

Forwarding Email - New Rule

2. Select under Start from a blank rule select Check messages when they arrive and click Next.

Forwarding Email - Blank Rule
Read more… »

How to enable or disable the sound for Mail Notification in Outlook 2007.

1. In Outlook, click Tools menu > Options.

2. On the Preferences tab, click E-mail Options, and click Advanced E-mail Options.

3. Under When new items arrive in my Inbox, check or uncheck Play a sound.