Because Excel has been crashing on me lately, one of the things I started wondering about is the use of multiple sheets in a workbook. I typically have 8 to 10 worksheets, some large, some not so large.
So my exploratory question is:
Assumming I could put all the stuff I now have on 10 wrorksheets onto a single sheet, would that be more efficient AND less prone to crash errors?
Is there an optimum number of sheets to use, like maybe 5?
Does the video card have a harder time servicing 10 sheets than 1 sheet?
Curious Sid