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
- Click on the Formulas tab on the top ribbon of Excel
- Click on Calculation Options
- Change it from Automatic or Manual to Partial
- Make sure the Format Stale Values box is also unchecked
- Try exporting to PDF again and the strikethroughs should be gone