Time Zone Issue Sharepoint and Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1797046%22%20slang%3D%22en-US%22%3ETime%20Zone%20Issue%20Sharepoint%20and%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1797046%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everybody%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20having%20this%20issue%20when%20I%20connect%20an%20local%20Excel%20file%20with%20a%20Sharepoint%20list%20online.%20In%20the%20Sharepoint%20list%20date%20%26amp%3B%20time%20are%20shown%20Ok%20but%20when%20I%20pull%20the%20data%20to%20Excel%20is%20around%206%20-%207%20hours%20later%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDon't%20know%20why%20is%20this%20happening%20and%20how%20can%20I%20fix%20this.%20Any%20ideas%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ESharepoint%20list%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22CP0822_0-1603137581743.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F227785iDAA52453F7B115AF%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22CP0822_0-1603137581743.png%22%20alt%3D%22CP0822_0-1603137581743.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EExcel%20file%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22CP0822_1-1603137628944.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F227786i19C1E0BEABC150A7%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22CP0822_1-1603137628944.png%22%20alt%3D%22CP0822_1-1603137628944.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1797046%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi everybody,

 

I'm having this issue when I connect an local Excel file with a Sharepoint list online. In the Sharepoint list date & time are shown Ok but when I pull the data to Excel is around 6 - 7 hours later

 

Don't know why is this happening and how can I fix this. Any ideas?

 

Sharepoint list

CP0822_0-1603137581743.png

 

Excel file

CP0822_1-1603137628944.png

 

 

1 Reply

Hi @CP0822,

 

Does the timezone in the SharePoint site match the timezone for the Excel file?

 

Change regional settings for a site.

 

I hope this helps.

 

Norm