UnsolvedCoding
Technical User
Are there any known coding reasons why a footer in Excel would not update properly for printing?
The code for the footers is created in a separate macro, and the workbook can be closed and re-opened and the footers will show up on print preview and print correctly for the first few. Up to ten at a time have been checked for accuracy. But when I try to print a set of 50 or more sheets the footer isn't updating, it simply retains the information from the first page.
Is this a coding issue, a printer issue or a formatting issue?
And yes, I know the workbook is large, can't get around that.
It has taken me a while to make sense of what I hear at work involving computers. There is much talk of bugs and questions about Raid.
Therefore I have come to the logical conclusion that the only way to have a properly functioning computer is to regularly spray it with Raid bug killer.
The code for the footers is created in a separate macro, and the workbook can be closed and re-opened and the footers will show up on print preview and print correctly for the first few. Up to ten at a time have been checked for accuracy. But when I try to print a set of 50 or more sheets the footer isn't updating, it simply retains the information from the first page.
Is this a coding issue, a printer issue or a formatting issue?
And yes, I know the workbook is large, can't get around that.
It has taken me a while to make sense of what I hear at work involving computers. There is much talk of bugs and questions about Raid.
Therefore I have come to the logical conclusion that the only way to have a properly functioning computer is to regularly spray it with Raid bug killer.