I got this message when I was trying to add something on footer.

"The header or footer cannot be no longer than 255 characters. Delete some
text or make formatting less complex."

The question is that I've used identical format and number of characters on
sheet 1 and it worked fine..but on sheet 2 it gives me above message. - I
have the same header on both sheet 1 and sheet 2.

Is there any way to override or fool this problem because I really don't
want to omit or change any of the contents of footer..Thanks