bottom
Great ExcelTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > ExcelTips Home > General > Changing Your Company Name

Changing Your Company Name

Summary: The installation process for Office and Excel allows you to specify a company name. If your company name later changes, you may be faced with the task of figuring out how to change it in the program. It is not as easy as it might at first appear, as described in this tip. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

When you first install Excel (or Office), you are asked for your name and the name of your organization (company, group, etc.). This information is stored in several places in your system. If you later change the name of your group, it can be no small task to make the changes necessary to change your company name.

Perhaps the easiest way is to simply uninstall Excel (or--heaven forbid--Office) and then install it again, from scratch. (You will see why this is easiest when you learn about the alternative shortly.) If you choose this method, make sure you save your data files before removing Excel. When you reinstall, you can then provide the correct company name for this installation.

If you don't want to uninstall Excel, then you can simply find and change all the places in which the program stores your company name. These include the Registry and INI files. You can change the Registry by using the Registry editor, but make sure you understand that changing the Registry improperly could make your system unstable or unusable. (Sound scary? It needn't be; simply use caution and common sense.) Follow these steps:

  1. Choose Run from the Start menu. This displays the Run dialog box. (Click here to see a related figure.)
  2. In the Open box, type regedit. This is the name of the Registry editing program.
  3. Click on the OK button. The Registry Editor is started. (Click here to see a related figure.)
  4. Choose Find from the Edit menu, or simply press Ctrl+F. This displays the Find dialog box. (Click here to see a related figure.)
  5. In the Find What field, enter the name of your company; the one you want to change.
  6. Click on Find Next. The Registry is searched for the company name. When a match is found, it is displayed on the screen.
  7. Analyze what was located to determine if you want to change it. You can figure out what the occurrence is for by looking at the name of the Registry key in which the company name is stored. Your company name could have been stored in the Registry by any number of programs, including Excel.
  8. To make a change, double-click on the Registry value on the right side of the Registry Editor screen. This displays an editing dialog box for the value.
  9. Change the value, then click on OK.
  10. Press F3 to find the next occurrence of your company name.
  11. Repeat steps 7 through 10 until you have made all the changes desired.
  12. Close the Registry Editor.

You might think that you need to restart your system at this point. If the only changes you need to make were in the Registry, then this would be true. However, there are other places you need to change, as well. You can find other occurrences of your company name in files by following these steps:

  1. Choose Find or Search from the Start menu. This displays the Find menu.
  2. Choose Files or Folders from the Find menu. Windows displays the Find dialog box. (This dialog box could be named Search Results, or a slightly different name, depending on your version of Windows.)
  3. In the Look In area, specify where you want the program to look. At a minimum you should look on the C: drive, as well as the drive on which you actually installed Excel. (Chances are good that this will be drive C:, as well.)
  4. Click on the Advanced tab, if one is available.
  5. In the Containing Text box, enter your company name or an unambiguous portion of your company name.
  6. Click on Find Now or Search Now. Windows displays a list of all the files which contain your company name in one way or another.
  7. Examine each of the files, making changes to them as necessary.

It is important that you examine files closely in step 7. The types of files you are looking for is anything that is either obviously for Excel or anything that may be an INI file.

You will also want to search the options and settings in any Excel templates you may have developed. If you choose Options from the Tools menu, and click on the General tab, the User Name box may actually have your company name in it. You should also choose Properties from the File menu, and then click on the Summary tab. The contents of the Company Name box should be changed there.

When you are done, close Excel and restart your system. The company name should appear changed in all instances.

Tip #2908 applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003


More Power! For some people, the prospect of creating macros can be scary. Those who conquer their fears, however, find they become much more confident and productive once they learn how to make Excel do exactly what they want. ExcelTips: The Macros is an invaluable source for learning Excel macros. You are introduced to the topic in bite-sized chunks, pulled from past issues of ExcelTips. Learn at your own pace, exactly the way you want.
 
Check out ExcelTips: The Macros today!

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home
Vital News Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

 

Great Info!

Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)