Hi
I have a pivot table based upon a list I create via code, it collects job
codes for the week. Most weeks there is someone is working each day, but
sometimes if there is no one working on a Sunday, and as I don't want to a
section that shows who is not working, and no one is working on a Sunday
Excel does not bother to create a column for it. Which may be a reasonable
thing to do, but it moves my totals column 1 column to the left and that
gives me grief, because of my formatting.

Is there any way I can force it to give me 7 columns of data, even if a
column is empty?

I hope so!