Forum Discussion
Power Pivot in Excel 2019 - From other Sources button wont work
Hi guys, I have recently upgrade my Microsoft Office to version 2019. I have no idea why the "From other sources" button in the Data Model window jus wont work. I tried repairing it locally, repa...
Hi. I have exactly the same problem. I'm using Excel 2016. I'm on the Office 365 monthly update channel. I think it broke with the latest update that I installed last week. I installed it on 2 computers and both are broken.
What sort of data are you trying to import? If it is a text or CSV file, try using Data > Text/CSV. Make sure you click the drop-down arrow next to Load and select Load To. Then choose Connection Only and make sure you tick the Add to Data Model checkbox.
This seems to be Microsoft's preferred way of importing data (maybe they broke the button on purpose)
Hope this helps
Mike Thomas
http://theexceltrainer.co.uk