If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
header and footer problems
Morning, I use a worksheet at work, which works out all scrap, customer returns and other stuff. The file has about 20 different tabs showing graphs and various tables linked together. There is one sheet which shows its months 'customer returns'. The footer on this page needed to be edited as is shows information from 2003. (We copied and renamed this to create this 2005 copy). I edited the header and footer with the information needed and pressed ok. This is the wierd part; I then looked at another tab within that document then went back to the tab where I edited the information, I looked at the print preview button and it showed the header and footer as it it hadn't been altered. I have tried saving this after I edited the header and footer and it still doesn't work. I am getting very frustrated about this, if there is there anyone that can help then reply back Thanks Cliffhanger79 -- cliffhanger79 ------------------------------------------------------------------------ cliffhanger79's Profile: http://www.excelforum.com/member.php...o&userid=28556 View this thread: http://www.excelforum.com/showthread...hreadid=482141 |
#2
|
|||
|
|||
header and footer problems
As I recall, there are different Headers/Footers for each worksheet.
"cliffhanger79" wrote in message news:cliffhanger79.1xytna_1131096001.9692@excelfor um-nospam.com... Morning, I use a worksheet at work, which works out all scrap, customer returns and other stuff. The file has about 20 different tabs showing graphs and various tables linked together. There is one sheet which shows its months 'customer returns'. The footer on this page needed to be edited as is shows information from 2003. (We copied and renamed this to create this 2005 copy). I edited the header and footer with the information needed and pressed ok. This is the wierd part; I then looked at another tab within that document then went back to the tab where I edited the information, I looked at the print preview button and it showed the header and footer as it it hadn't been altered. I have tried saving this after I edited the header and footer and it still doesn't work. I am getting very frustrated about this, if there is there anyone that can help then reply back Thanks Cliffhanger79 -- cliffhanger79 ------------------------------------------------------------------------ cliffhanger79's Profile: http://www.excelforum.com/member.php...o&userid=28556 View this thread: http://www.excelforum.com/showthread...hreadid=482141 |
#3
|
|||
|
|||
header and footer problems
Not only that, if a chart is an embedded chart, you can select the chart
and do page setup, and it will make changes as if the chart will be printed by itself. This does not affect the page setup of the worksheet which contains the embedded chart. I suspect the OP may have changed the headers and footers of an embedded chart, then checked the headers and footers of the whole worksheet, which were unchanged. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Barb Reinhardt wrote: As I recall, there are different Headers/Footers for each worksheet. "cliffhanger79" wrote in message news:cliffhanger79.1xytna_1131096001.9692@excelfor um-nospam.com... Morning, I use a worksheet at work, which works out all scrap, customer returns and other stuff. The file has about 20 different tabs showing graphs and various tables linked together. There is one sheet which shows its months 'customer returns'. The footer on this page needed to be edited as is shows information from 2003. (We copied and renamed this to create this 2005 copy). I edited the header and footer with the information needed and pressed ok. This is the wierd part; I then looked at another tab within that document then went back to the tab where I edited the information, I looked at the print preview button and it showed the header and footer as it it hadn't been altered. I have tried saving this after I edited the header and footer and it still doesn't work. I am getting very frustrated about this, if there is there anyone that can help then reply back Thanks Cliffhanger79 -- cliffhanger79 ------------------------------------------------------------------------ cliffhanger79's Profile: http://www.excelforum.com/member.php...o&userid=28556 View this thread: http://www.excelforum.com/showthread...hreadid=482141 |
#4
|
|||
|
|||
header and footer problems
No its not that. I changed the header information on one sheet, press ok, Looked at another sheet then went back to the sheet which I changed the header and it read the original information. Cliffhanger79 -- cliffhanger79 ------------------------------------------------------------------------ cliffhanger79's Profile: http://www.excelforum.com/member.php...o&userid=28556 View this thread: http://www.excelforum.com/showthread...hreadid=482141 |
#5
|
|||
|
|||
header and footer problems
Assuming that you're clicking OK and not Cancel after changing the
settings, then I don't know what is causing that behavior. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ cliffhanger79 wrote: No its not that. I changed the header information on one sheet, press ok, Looked at another sheet then went back to the sheet which I changed the header and it read the original information. Cliffhanger79 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
header and footer problems | [email protected] | New Users | 2 | October 28th, 2005 06:09 PM |
header footer not showing when opening new document | PWalker | General Discussions | 1 | September 5th, 2005 09:18 PM |
No Header and Footer toolbar | Amy | General Discussion | 2 | August 16th, 2005 07:25 PM |
Same header but even/odd footer (sorry for the new thread) | B?atrice Karjalainen | Page Layout | 1 | December 16th, 2004 12:40 AM |
Headers and Footers | Specter7 | New Users | 2 | May 17th, 2004 03:51 PM |