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 :
Customer experience | Sales, Customer Insights,...
Suggested Answer

Updating Leads/Opportunities via Imports when Status is Closed

(0) ShareShare
ReportReport
Posted on by 4

Hi everyone,

Is it possible to update Leads or Opportunities that have been closed/won/disqualified in CRM via imports?

I recently had to recreate a field and while transferring all the existing data from the old field to the new one (so users had a smooth transition) I exported All Leads, populated the new data to the new field and when imported back into the system I get many errors related to "original record no longer exists".

Any advice about this? Thanks!!

I have the same question (0)
  • Suggested answer
    Wahaj Rashid Profile Picture
    11,321 on at

    Hi,

    I am able to update closed Leads using the following steps:

    https://crmtipoftheday.com/254/update-fields-on-disabled-records/

    Can you please make sure, you are using the same steps?

    Best,

    Wahaj

    (if it helps, mark it verified)

  • LuHao Profile Picture
    40,892 on at

    Hi barbieruelas,

    I can also successfully import the closed leads/opportunities following the link provided by Wahaj.

    Note that the data of columns A to C in the exported excel file cannot be modified. They represent the identification of records.

    Columns A to C are hidden by default.

    pastedimage1596767400635v1.png

  • Suggested answer
    Wahaj Rashid Profile Picture
    11,321 on at

    Hi,

    Can you also make sure, you are re-importing the leads in the same environment?

    If you exported the file from Production, updated the new field, and trying to import it in Staging, it won't work.

    Because one of the hidden columns (in excel file) has GUID of the Lead records and this GUID is different in each environment.

    If you need to test it, you should export this data from Staging and re-import in staging.

    If it works fine, you have to do the same exercise by exporting data from Production.

    Best,

    Wahaj

    (if it helps, mark it verified)

  • Wahaj Rashid Profile Picture
    11,321 on at

    Hi,

    Did it work for you?

    Thanks,

    Wahaj

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 > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 74 Super User 2025 Season 2

#2
Daniyal Khaleel Profile Picture

Daniyal Khaleel 32 Most Valuable Professional

#3
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 31 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans