MrExcel Publishing
Your One Stop for Excel Tips & Solutions

page setup / header & footer institution name


Posted by Darcy Bradley on December 12, 2001 3:52 PM

Is their a way to change the institution name in the page setup menu on the header/footer drop down menu?

Our organization went through a merger and has changed names, however the old name still appears in that header/footer drop down menu?!?


Posted by Joe Was on December 12, 2001 4:40 PM

Go to File-Page Setup-Headers/Footers then select custom and type your new hearder(footer) in the left, center or right box. It will be added to the dropdown list, to use any time without re-creating it each time. JSW

Posted by Darcy Bradley on December 13, 2001 7:58 AM

Posted by Joe Was on December 13, 2001 8:53 AM

I tried it on my PC the new custom header is added to the header list of any file saved with it. It becomes part of the named file when saved. It works when Excel is closed for that file and when the whole application is exit'ed. The custom header is not put into the Excel application only files saved with it.

If this is not what is happening on your system a number of things could be going on:
The system manager has locked out application changes, You are using a shaired file and only have view status, the application has a macro to add the header that overides your setting, etc.

Try and check the code with the VB editor check all the sheets, moduls and "This WorkBook" check for any text that matches the heder/footer thats bad. You can use search Ctrl+f. JSW

Posted by Darcy Bradley on December 13, 2001 9:13 AM

:Somehow in the past I had excel 2000 set-up so that on new files the institution name was changed, and this was the case for all new files, however, I recently re-installed excel 2000 and that is when I reverted back to the old name, so I know that the name can be changed for all new files, but I have no idea how I changed it last time. Ideas? I tried it on my PC the new custom header is added to the header list of any file saved with it. It becomes part of the named file when saved. It works when Excel is closed for that file and when the whole application is exit'ed. The custom header is not put into the Excel application only files saved with it. If this is not what is happening on your system a number of things could be going on:

Posted by Joe Was on December 13, 2001 10:04 AM

OK, File-Properties-Summary then change "Author" and "Company" that should do it. Some of the default Header/Footer options pull these fields. Let me know if this worked or not so if needed we can look at some other options. JSW :Somehow in the past I had excel 2000 set-up so that on new files the institution name was changed, and this was the case for all new files, however, I recently re-installed excel 2000 and that is when I reverted back to the old name, so I know that the name can be changed for all new files, but I have no idea how I changed it last time. Ideas? : I tried it on my PC the new custom header is added to the header list of any file saved with it. It becomes part of the named file when saved. It works when Excel is closed for that file and when the whole application is exit'ed. The custom header is not put into the Excel application only files saved with it. : If this is not what is happening on your system a number of things could be going on:

Posted by Darcy Bradley on December 14, 2001 8:24 AM

That did not work, because when I exited Excel and then re-opened it reverted back to the old name, any idea where it pulls the company name from? OK, File-Properties-Summary then change "Author" and "Company" that should do it. Some of the default Header/Footer options pull these fields. Let me know if this worked or not so if needed we can look at some other options. JSW : :Somehow in the past I had excel 2000 set-up so that on new files the institution name was changed, and this was the case for all new files, however, I recently re-installed excel 2000 and that is when I reverted back to the old name, so I know that the name can be changed for all new files, but I have no idea how I changed it last time. Ideas?


Posted by Joe Was on December 14, 2001 11:20 AM

Check to see if Tools-Options "General" tab "User Name:" box has the old name in it? JSW

That did not work, because when I exited Excel and then re-opened it reverted back to the old name, any idea where it pulls the company name from? : OK, File-Properties-Summary then change "Author" and "Company" that should do it. Some of the default Header/Footer options pull these fields. Let me know if this worked or not so if needed we can look at some other options. JSW


Posted by Joe Was on December 14, 2001 11:36 AM

Also check

Also check: with explorer "Program Files\Microsoft Office(or your package)\Office\XLStart" for the files Book.xlt and or Sheet.xlt copy these to a floppy and delete them if you have them. restart Excel.

The other option is that you have a custom properties profile or a network stored properties profile. The windows file find utility can help find these files, just delete then to reset your Excel.

If I can think of some other places I will post back. JSW