It makes a little sense but I don't see the picture yet.
Could you attach the macro code for the Report so I can test?
And why is it in Personal Xlsb?