Multi-Sheet Cap for Reports/Pivots/Dashboards
I need to report on data spread over 50+ sheets that are updated independently. The plan had been to place all these sheets in a single workspace and run a Dashboard or a Pivot referencing them all, but I cannot find whether there is a limit on the number of sheets a single Dashboard or Pivot can reference. Or if there is a similar limit on the maximum number of cells. Is this approach viable?
Thank you very much!