Excel online is different canvas to Excel on the desktop. Your audience is likely to be less familiar with Excel, they are very likely to have a small screen and they probably couldn't "be bothered" to scroll off the first page of your report. In this article I will show you how SubTotals in Excel can make big data concise and then ExcelOnline can expand that information so you can see detailed data.
PS. Soon I will publish the vba that goes with this article on this page at vb123.com.au