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?
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? Read More