Strikethroughs on PDF after exporting from Excel in Sage Intelligence

Strikethroughs on PDF after exporting from Excel

Problem

When you using Sage Business Intelligence and using the Excel Add-In, the data content looks correct, and displays properly. However, when the data is exported as a PDF, all the formula cells display as strikethroughs

Reason

When exported to PDF, Excel formulas can show strikethroughs due to a new feature called "Stale Value Formatting". This visual indicator is intended to warn users that a formula's value is outdated and needs to be recalculated
​

Solution

  1. Click on the Formulas tab on the top ribbon of Excel
  2. Click on Calculation Options
  3. Change it from Automatic or Manual to Partial
  4. Make sure the Format Stale Values box is also unchecked
  5. Try exporting to PDF again and the strikethroughs should be gone

    • Related Articles

    • Scheduling a Sage Intelligence Report

      Scheduling a Sage Intelligence Report Sage Intelligence Reporting supports unattended report execution using operating system batch files or external scheduling tools such as Windows Task Scheduler or SQL Server Agent. This is commonly used for ...

    • QuickBooks reports are slow when exporting to Excel worksheet

      Problem When exporting a QuickBooks report to Excel, the export process is very slow. Resolution While in QuickBooks, perform the following: Open your QuickBooks company file Run a report to export to Excel Select Excel > Create New Worksheet Click ...

    • Sage Intelligence Add-in giving error or not showing up in Excel

      Problem: When running Sage Intelligence requiring the Excel add-in, an exception error is shown to the user, or the add-in does not show up in Excel Reason: The likely reason for this problem is that the Excel Add-in is not registered correctly. ...

    • The Report Designer Component is required by this report and is not installed on this workstation

      Problem When you try to run the Report Manager from Sage Intelligence reporting module in SAGE you get an error "The Report Designer Component is required by this report and is not installed on this workstation" Why Is This Happening? Report manager ...

    • Unable to password protect PDF document

      Problem: When printing to paperless office, the following error is displayed Resolution: Close out of Sage Click on "Force session log-off" -->YES When you are on the below screen select an actual printer instead of a PDF printer (i.e: CutePDF) Try ...