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

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

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

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

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