Section 1: De-activate PLDRlLL.Connect COM Add-in in Excel

1. Open Excel.
2. Select Options, and then select Add-Ins.
3. On the Manage pane, select COM Add-ins.
4. Click Go.
5. Disable PLDRlLL.Connect.
6. Click OK.
7. Verify you can generate the report without errors.

Section 2: To fix the formula issue

1. In Sage 50, click Setup, User preferences, Option.
2. Choose English for Microsoft Excel language.
3. Click OK.

Section 3: To fix the issue regarding numbers showing up as text with the green little triangles

1. Set Sage 50's decimals and thousands separators. In Sage 50, click Setup, Settings, Company, Currency.
2. Set comma and thousands separators to the following formats:
   • English: 1,000,000.00
   • French: 1 000 000.00
3. Close Sage 50.
4. Set Windows decimals and thousands separators by going to Windows Control Panel.
5. If you see Clock, Language and Region then click it else skip this.
6. Click Region and Language.
7. Keep (or change) language option to French (Canada).
8. Click Additional settings.
9. In the Numbers tab, update the comma and thousands separators.
10. Click the Currency tab.
11. Update the comma and thousands separators.
12. Click OK.

    Note: Set Microsoft Excel's decimals and thousands separators

    • Excel derives its number formats from the settings in the Regional and Language Options control panel.
    • If it doesn't seem to use the Windows settings, you also need to follow the instructions below to update the settings in Excel:
      
      • For Excel 2010 and 2013:
        
        1. On the main menu of Excel, click File, Options
        2. In the Excel Options screen, click Advanced
        3. Choose to Use system separators or choose the Decimal and Thousands separator that you want to use
           
      • Excel 2007
        
      • Excel 2003
        
13. If changes were applied to the Region and Language settings in Windows Control Panel by following the steps above, the computer needs to be rebooted.
14. Open Sage 50 and test the export of a report to Microsoft Excel.