I have 58 sheets in a workbook, and I need to calculate the percentage across
all sheets into sheet 1. We are using this workbook to conduct a training
analysis. Each sheet represents a learner, and their knowledge of the
content as high medium or low. Sheet 1 should give us an overview of the
specs, yet it seems excel 2000 cuts you off after 35 sheets when writing the
formula