I can not use formula's in the excel export from sharepoint. If I start a formula with an "=" sign and select a cell, I get [@[columnname]].
How can I work with formulas in the excel export from sharepoint?
Data imported from Sharepoint list is placed in Excel Table which works by default with structured references https://support.office.com/en-us/article/using-structured-references-with-excel-tables-f5ed2452-2337...
Traditional explicit references (like =A1) also could be used within the Tables, but usually it's less suitable.