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.
Power Query is notoriously bad at handling protected cells in Excel sheets. Avoid using these if you can.