--- title: "The Excel export does not add up the total amounts at the bottom, they all remain at 0. How can that be?" slug: "the-excel-export-does-not-add-up-the-total-amounts-at-the-bottom-they-all-remain-at-0-how-can-that-be" description: "The Excel export does not add up the total amounts at the bottom, they all remain at 0. How can that be?" tags: ["check-ai", "QA85"] updated: 2024-06-10T08:43:01Z published: 2024-06-10T08:43:01Z canonical: "docs.retailvista.net/the-excel-export-does-not-add-up-the-total-amounts-at-the-bottom-they-all-remain-at-0-how-can-that-be" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.retailvista.net/llms.txt > Use this file to discover all available pages before exploring further. # The Excel export does not add up the total amounts at the bottom, they all remain at 0. How can that be?
This has to do with the security in Office 2010 and later, where formulas in an Excel sheet are not immediately executed when opening the file. By clicking on 'Edit', the file is opened in read & write mode and all formulas are also executed.