I know this is a very old post, but I recently had a similar issue where it was auto-sizing most of the time but one report wouldn't.

I tried the resize solution but got an error message.

I then realised that there was a merged cell in the column data being pasted and that seemed to mess things up... just a heads up as something to check