Print Settings being lost when I move to another sheet

**ani4ani** · 04-24-2010, 06:54 AM

Hi this problem is really getting me down and frustrating me to death.

I have multiple sheets in a workbook and have [and continue to set up] print paremeters for each sheet in the workbook.

However, if I move onto another tab, and then return to a previously setup tab, all of the print settings have been lost again, even "Custom Footer" infomation, e.g. even my free text "disclaimer" in the footer has reset to old text?

I would appreciate any help on this one

many thanks

OK SOLVED - EMBARRESSED TO STATE THAT CUSTOM VIEWS WITH PRINT SETTINGS WAS MY PROBLEM

**teylyn** · 04-24-2010, 07:10 AM

Can you post the workbook? Delete all the data, if need be, just leave your print setup in place.

**ani4ani** · 04-24-2010, 07:12 AM

Originally Posted by teylyn

Can you post the workbook? Delete all the data, if need be, just leave your print setup in place.

Hi the file is huge, nearly 15 MB? Would that be allowed?

Is there a way to actually "purge" print settings on a sheet?

**teylyn** · 04-24-2010, 07:28 AM

15 MB would definitely be too much. Create a copy of the workbook, hit Ctrl-A in each sheet and then the delete key, do clear all values and formulas. Leave the print settings as they are, and post the sheet. If it is still big, zip it.