During this time of COVID 19, when many companies are forced to telework, AccountEdge Hosted may be a good option. And it’s important to note that it doesn’t have to be a permanent solution. You can host your company file only as long as needed, then return to whatever environment makes sense for your business. If you’d like to discuss that or any other teleworking solution with a product specialist, please call 800.322.6962. Be safe.

  • Section: Reports & Forms
  • Last updated: June 27, 2019, 6:16 p.m.

Send Reports to Excel: Calculations

When you send a report to Microsoft® Excel, you may want to add extra calculation columns. If you enter a formula, and it is not working (not calculating the column formula), it may due to a preference in Excel.

Activating Calculation Preference on Microsoft Windows

To activate this preference in Excel, go to your Tools or Formulas menu (at the top of your screen). Choose Options and select Calculation; set this to Automatic. Excel will now calculate formulas from an AccountEdge report.

Activating Calculation on Mac OSX

To activate this preference on Mac, go up to the Excel menu (next to the Apple menu) and choose Preferences. Choose Calculations. Set the preference to Automatic.