Home

SharePoint export to Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-890147%22%20slang%3D%22en-US%22%3ESharePoint%20export%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-890147%22%20slang%3D%22en-US%22%3E%3CP%3EI%20can%20not%20use%20formula's%20in%20the%20excel%20export%20from%20sharepoint.%20If%20I%20start%20a%20formula%20with%20an%20%22%3D%22%20sign%20and%20select%20a%20cell%2C%20I%20get%20%5B%40%5Bcolumnname%5D%5D.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20work%20with%20formulas%20in%20the%20excel%20export%20from%20sharepoint%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-890147%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-892350%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20export%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-892350%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F40721%22%20target%3D%22_blank%22%3E%40Michael%20Challoner%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EData%20imported%20from%20Sharepoint%20list%20is%20placed%20in%20Excel%20Table%20which%20works%20by%20default%20with%20structured%20references%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fusing-structured-references-with-excel-tables-f5ed2452-2337-4f71-bed3-c8ae6d2b276e%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fusing-structured-references-with-excel-tables-f5ed2452-2337-4f71-bed3-c8ae6d2b276e%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETraditional%20explicit%20references%20(like%20%3DA1)%20also%20could%20be%20used%20within%20the%20Tables%2C%20but%20usually%20it's%20less%20suitable.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Michael Challoner
Visitor

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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies