Jul 13 2022 04:48 AM
I have a workbook of 12 tabs. When I try to print multiple copies of the entire workbook, the output is not collating, even though I have it set to collated. I've checked my printer settings, preferences, & properties. Can anyone give me an idea of where this issue is or might be?
Jul 14 2022 01:51 AM
Note: If a worksheet has defined print areas, Excel will print only those print areas. If you don't want to print only the defined print area, select the Ignore print area check box. Learn more on setting or clearing a print area.
*If If you print the saved file on a different printer (than the default printer set by Windows), the page breaks and font spacing may change.
*By default, a shared workbook is set to save "Print Settings" and "Filter Settings" per user. So if the shared Excel file contains an auto filter, each user will have their own view saved. Under "View" - "User-defined views" the views that have already been saved can be called up and deleted again.
To prevent user-defined views from being saved, the "Filter settings" option can be deactivated when the workbook is shared under "Review" - "Share workbook" - "Other" tab. If this is a shared file, that could also be an issue.
If I may recommend, always inform about the digital environment of your file. Excel version, operating system, storage medium. If possible insert file (without sensitive data). This would lead to a more accurate and faster solution proposal.
Hope I could help you with these information / link.
I know I don't know anything (Socrates)
Jul 14 2022 06:46 AM
Mar 07 2024 12:08 PM
@spr1nger Did you ever find a solution for this issue? I am having the same problem now and I cannot find anything or any way to fix it.