SharePoint export to Excel

Copper Contributor

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

@Michael Challoner 

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.