import from excel online not working

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi,

Normally I use export to excel online and make changes then import these changes back into dynamics 365 but it doesn't work anymore and it detects 0 changes, then randomly it would work. It only works about 1 10th of the time and sometimes works for 1 or 2 changes instead of 50+. Basically it doesn't detect any changes at all and thinks there is 0 imports.

Any help would be much appreciated.

*This post is locked for comments

All responses (5)

Answers (0)

Suggested answer

Kokulan 18,048 on at

Like (0)

Report

RE: import from excel online not working

Please try from your Person Options area as shown below
Community Member Microsoft Employee on at

Like (0)

Report

RE: import from excel online not working

Hi,

You are correct that the modified date comes in a mm/dd/yyyy format while here in Australia we use dd/mm/yyyy. Am unsure of how to change this as my timezone is set to my location.
Suggested answer

Kokulan 18,048 on at

Like (0)

Report

RE: import from excel online not working

Could you check user time zone for the user who does the import? If says 0 import, means it did not detect any changes, could it be the modified on date and actual user timezon difference causing the issue?
Community Member Microsoft Employee on at

Like (0)

Report

RE: import from excel online not working

Yes it does
Kokulan 18,048 on at

Like (0)

Report

RE: import from excel online not working

Does your Excel file has hidden columns with record GUID and Checksum? I think there should be about three columns hidden