Forum Discussion

ohalev's avatar
ohalev
Copper Contributor
Jul 03, 2024

Exporting List View to Excel Includes Hidden Source Fields Used in Calculated Columns

Hi,

I have a custom SharePoint Online list with several calculated fields that use other fields for their calculations (e.g., the calculated field "Full Name" = [First Name] + [Last Name]). In my list views, only the calculated fields (e.g., "Full Name") are displayed, not the source fields (e.g., "First Name" and "Last Name"). However, when I export the list view to Excel, all the source fields used in the calculations are included in the export as empty columns, even though they are not displayed in the view. How can I prevent these unused source columns from appearing in the Excel export?

 

 

No RepliesBe the first to reply

Resources