Forum Discussion
SharePoint export to Excel
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?
1 Reply
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-4f71-bed3-c8ae6d2b276e
Traditional explicit references (like =A1) also could be used within the Tables, but usually it's less suitable.
