Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Error Uploading Excel ...
Microsoft Dynamics CRM (Archived)

Error Uploading Excel Template any time we add a column formatted as "time"

(0) ShareShare
ReportReport
Posted on by mc625569

CRM 365 on premise .  We are unable to upload any excel template into the system if we've added any "time" formatting to any new columns. 

We are attempting to download data to CRM including a date field, then create a new field in excel that extracts the time from that field. Any time we format this new column as time we cannot upload the spreadsheet back into CRM . 

When we try to upload we get "an error has occurred. Try this action again/contact your admin".   We don;t have duplicate column names, but we do want to create a column in excel that derives the time from a downlaoded CRM date/time field. 

Is there some limitation about doing this?  We are using named ranges not direct cell references. 

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error Uploading Excel Template any time we add a column formatted as "time"

    I'm having the exact same problem.

    I'm wanting to pull out the week commencing date for the Created Date on the Lead record. I can export the data from the lead, then create a new column to show week commencing.

    When I try and upload the template I get an error....

    Interested if anyone has a way around this.

  • mc625569 Profile Picture
    mc625569 on at
    RE: Error Uploading Excel Template any time we add a column formatted as "time"

    We do have a time field in CRM. When we export this to excel it has the date and time In a single cell. We want this in separate cells.  I can’t find a way to do this that actually allows me to reimport this template and reuse it. As soon as I format any field as time in excel and try and parse our the time it cannot be uploaded.

  • RaviKashyap Profile Picture
    RaviKashyap 55,410 on at
    RE: Error Uploading Excel Template any time we add a column formatted as "time"

    Hi,

    Why are you adding the new time column in the excelsheet? Do you have the field in CRM which you want to update with this new time column?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans