I have set all the reports to an interactive size of 0 which means that as you are looking at them in the browser they are as big as they need to be

With the big question with lots of columns it just can’t handle rendering that much data,

So I have set the interactive size back to 21cm, 29.7cm

Which means that instead of it being on 1 page it spans multiple pages. I've then sent to a csv format and it all goes into one csv file.

So fingers crossed that’s going to help a lot for anything that could end up sizeable