No totals when viewing in Excel

No totals when viewing in Excel

Created by: Gavin Hodge

Modified on: Mon, 7 May, 2018 at 9:55 AM


Spreadsheet reports are exported to Excel format when sent via email, and also when 'Save As Excel' is used while viewing a report.


When you first open an Excel attachment it will show in Protected Mode where formula cells are shown blank. To exit Protected Mode and enable formulas, click the Enable Editing button at the top of the window:


This step is required each time a new attachment is opened.


It is possible to disable Protected View in Excel, but this step should be taken with caution.

    • Related Articles

    • Report Designer Excel Style Formulas

      Created by: Gavin Hodge Modified on: Fri, 14 Feb, 2020 at 9:43 AM Most formula transformations can be done using value source formulas, but the report designer tool also supports using literal Excel style formulas.  While value source formulas are ...
    • Import an Excel file

      Created by: Johann Du Toit Modified on: Tue, 3 Dec, 2019 at 12:46 PM How to Import Your Own Excel Data and use it to create a Report Note: This functionality is only available on Professional and Enterprise plans.    Set up a Connector to Excel Click ...
    • How to decide when to use Value Source or Excel formulas?

      Created by: Johann Du Toit Modified on: Fri, 14 Feb, 2020 at 9:41 AM Warning! This is a confusing subject, but please bear with us. If you've done some report designs and created formula columns, then you would be familiar with "Value Source" or ...
    • Running Reports

      Created by: Gavin Hodge Modified on: Wed, 14 Feb, 2018 at 3:38 PM Executing reports is the core part of Wink Reports. This reference will cover changing filter values, exporting, using saved filters, parameter lists, and creating sharing URLs. The ...
    • Designing a conversion rate report

      Created by: Gavin Hodge Modified on: Tue, 18 Sep, 2018 at 2:06 PM A conversion rate report is one of the more advanced uses of the report designer. It requires use of many features of the designer including value formulas, Excel style formulas, ...