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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Excel Online Import Errors

(0) ShareShare
ReportReport
Posted on by 329

Hey all, I'm having trouble getting some of my fields to update via excel online. I have users aching to use this feature, and it seems pretty "hit and miss." On the success of the reimports of data.

2017_2D00_10_2D00_09_5F00_15_2D00_21_2D00_07.jpg

I tested a column that a user was trying to update via excel online (The production group it's assigned to) and even when copying the format from the line above to a line below, I get the following error. I've also tried typing it in clean and get the error. I can't seem to figure out why this error is throwing, when the source data is from CRM, how could it not be required format? Any ideas?

*This post is locked for comments

I have the same question (0)
  • LCRMAdminG Profile Picture
    329 on at

    As a follow up: I have tried exporting to desktop Excel, making the changes, importing and I get the same error. These are happening on every single field. I thought at first it was just look ups, but I am having that issue even with open text field like the Opportunity name etc. 

  • Panky Profile Picture
    155 on at

    I think the template through which you are uploading the excel is in wrong format. Kindly check it again.

  • LCRMAdminG Profile Picture
    329 on at

    I am using excel online, so the template is already set by the CRM.

  • LCRMAdminG Profile Picture
    329 on at

    Hi, just bumping for help. I'm still stuck on this. Hoping for some ideas on what I can check or adjust? Or should I take this to my developer?

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans