I am attempting to run a report based on about 100 sheets all contained in one folder.
When I try to source the report across these sheets the report crashes before I can even add the columns.
If I try to add between about 1 and 10 source sheets it seems to work okay but when I add more it locks up and crashes.
Any advice? I've run reports on significantly more sheets in the past so I don't think thats the issue.
Thanks!