Time Zone Issue Sharepoint and Excel

Copper 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