Category: Microsoft Office

How to rename an outlook profile

By jldurham6,

If you are using MS Outlook (any version), you will notice that there is no way to rename the mail profile from Control Panel (see Figures A and B).

Figure A

Figure B

I knew that most of these settings are stored in the registry, so I ran a search for every instance of Profile. I did find where the change was and confirmed my suspicion that this setting can be modified using the registry.
… Continue reading

Add a drop down list to Excel

By jldurham6,

Create a drop-down list

You can make a worksheet more efficient by providing drop-down lists. Someone using your worksheet clicks an arrow, and then clicks an entry in the list.

A drop-down list in Excel

  1. On a new worksheet, type the entries that you want to appear in your drop-down list. The entries should be in a single column or row without any blank cells, like this:

    2. … Continue reading

Enable auto complete for the date

By jldurham6,

Date AutoComplete may not be useful (I always turn it off), but it is certainly still available in Word 2007.
The difference is that you need a macro to turn it on or off. Press Alt+F11 to display the Visual Basic Editor. Press Ctrl+G to activate the Immediate window. Type
… Continue reading

This operation has been cancelled due to restrictions in effect

By jldurham6,

Also see http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q310049

http://www.slipstick.com/problems/this-operation-has-been-cancelled-due-to-restrictions

 

Note: These solutions work in all versions of IE. A very common question comes up often in the Microsoft forums: When clicking on a hyperlink in an e-mail, I get this Message : “This operation has been cancelled due to restrictions in effect on this computer. Please contact your system administrator.” I get this message every time that I attempt to use the hyperlink. I am the administrator on this stand alone computer. How do I deactivate this feature so that I activate hyperlinks ?This is not an Outlook error. The most common cause is a corrupt registry key in Internet Explorer. The registry key found at
… Continue reading