Quick Excel query

Not sure why it happens to you, works fine for me (E2016).

Try:

1. make sure workbook saved before printing, then print workbook , or

2. "select all sheets" and then "print active sheets" instead workbook

When you go to print is there a printer setting - Settings - Print Entire Workbook ?

Based on how excel designates worksheets in VBA, I wouldn't be surprised if the Tues and Mon sheets were created after the others.

Despite these sheets / tabs being renamed, excel will still consider them to be Sheet5 and Sheet6.

It sounds like excel is then printing them in order as sheets 1-6.

I've had a quick search for references on this, but nothing useful is coming up for an elegant solution.

A quick and dirty fix may be to copy the sheets to a new workbook in the order required.

So move the Monday sheet across first, then Tuesday and so on. Worth a try and let us know how you get on!

had that in mind, cannot replicate...

Tested, new sheets created, moved to different order, shuffled around - print still in order the sheets aligned in workbook

I also wonder if it's a printer connected to their machine, or a server printer similar to what's described in the link I shared.

Local printer may print sheets in order they're arranged in workbook, printer server may use the sheet names to sequence the print job.

I wonder if you could print to pdf then print the pdf?

A quick test on my Excel 365 shows sheets are printed in the TAB order that they are arranged by. So arrange the tabs in the order you want to print them.

No experience with Xerox but by the look of it there are two universal drivers that might help. The first is the PCL6 driver and I have a personal hate for them as they have caused me problems in the past then there is the Postscript driver.

Assuming you have the permission to add printer drivers I'd give both of these a try and see if one works over the other

https://www.support.xerox.com/en-us/product/global-printer-driver/downloads?platform=win10x64&language=en