Forum Discussion
Solved
Inconsistent import of Excel data from SharePoint - blank values
I've been experiencing inconsistent data import from Excel files in SharePoint and was wondering if anyone else has experienced the same and if so, any suggested resolutions/fixes? Due to confide...
Power Query is notoriously bad at handling protected cells in Excel sheets. Avoid using these if you can.
Thank you for this feedback.
I can see this will be problematic as we cannot change the data capture tool at this point in time. We are moving towards a new tool, away from Excel, so any issues caused by protected cells will drop away in the future.