When I edit the columns to be displayed on a list view and press "Export to Excel" the Excel file does not have any of the columns I added

(0) Share

Report

Posted on by psychobunny83

Let's say I'm on the main list view for Accounts, and I have it showing 2 columns "Account Name" and "City" for an example.

I press the little "Edit Columns" button, and I add a few more, such as "Account Type" and "Customer Value".

It shows the new columns. I press Export to Excel, and the Excel file just shows the view with the 2 columns and doesn't show the ones I added. It seems like it only exports columns that are permanently part of the view and not ones you add temporarily. Is there a way to fix this as otherwise what is the point of the "Edit Columns" button if they don't export to Excel?

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Nya 29,060 on at

Like (0)

Report

RE: When I edit the columns to be displayed on a list view and press "Export to Excel" the Excel file does not have any of the columns I added

Hi,

If a column is added with "Edit Columns" button, there will be a "*" following the name of the view.

It means that you can only see the data temporarily and if the page is refreshed, it will disappear.

So you need to click the following buttons to save it as a new view.

Or you can edit the view in Power Apps.

Here is the detailed steps:

Create and edit public or system model-driven app views with Power Apps - Power Apps | Microsoft Docs

Was this reply helpful? Yes No
Teska.chawla 156 on at

Like (0)

Report

RE: When I edit the columns to be displayed on a list view and press "Export to Excel" the Excel file does not have any of the columns I added

Hi,

Please save the view with extra columns. Then only the export excel will show all columns

Was this reply helpful? Yes No