Error message while trying to collapse grouped rows

Hi everyone,

I've had this problem before and it's been where there has been formatting beyond the table, so deleting all rows/columns outside my data area has solved the problem.

I've tried this and it's still coming up with the error message "Cannot shift objects off sheet".

Does anyone have any other suggestions that might help me out here?

Many thanks in advance,

Rob

Oh, just as an addition to that, previously when I've had this problem I've still been able to collapse the rows manually (using the individual "-" buttons). But this time I get half way down the table doing that and then I get the error message.

Rob

Never mind, I managed to fix it. It turned out that it was a comment box which was causing the problems. It was set to "move but don't size with cells" and had stretched to a ridiculous length. Deleted that and it all works again.

Rob