The attached Excel file shows a representation of the data imported, at the same time, to two different Excel platforms, using the same Excel template.
The template has a single relevant formula (D13/H13) and the correct display (on a PC with Win 10, Office 365) is the RH block. The LH display(on a Laptop, Win 10, Excel 2016) has the unwanted, 'Phantom' Grand Totals.
I'm assuming there is a setting that has automatically introduced the Grand Totals that, despite much searching, I have failed to find.
How do I stop Grand Totals being added to the Laptop display?
Bookmarks