web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Excel Template - Different Column Name

(0) ShareShare
ReportReport
Posted on by

Hi to all,

I am having issues using Excel templates in CRM;

Is there a way to have different column names than they are named in CRM?

Let´s say: The name of the CRM column is "Estimated Revenue (Base)", which is quity bulky and ugly.

When I use this as template, it works to download data, but if I change a single letter in the template´s column name, CRM does not recognize it anymore and leaves all the column empty.

As I frequently have to sum sum up these data in excel, it is a bit tiring to change all the names afterwards.

I hope there is an easy workaround,

best regards,

massex

*This post is locked for comments

I have the same question (0)
  • Rao Rapolu Profile Picture
    470 on at
    RE: Excel Template - Different Column Name

    change the display name in CRM, should work....

  • JamieLV Profile Picture
    15 on at
    RE: Excel Template - Different Column Name

    There is a "very hidden" worksheet (use View Code to unhide) that contains the column names as they appear upon exporting to Excel.  You must update the export worksheet column header and update cell A1 on this hidden worksheet to have the same display name.  Cell A1 contains the Dynamics field names as well as the Excel column header display names for all fields on the export sheet.  You must find the column header you want to edit within and carefully edit to match the change you made on the export sheet.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
HR-09070029-0 Profile Picture

HR-09070029-0 2

#2
ED-30091530-0 Profile Picture

ED-30091530-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans