Forum Discussion
Solved
Get & Transform won't pull sheet titles
I have several queries that I'm working with that are pulling information from external Excel files and aggregating the information. When I use the Excel files on my local machine, the sheet names pu...
I think I've solved it. It's something to do with the way that it's saved on downloading. Once I open and save the source excel workbook, everything shows up.
Yes, that’s exactly right. I have several files that I’m pulling in, one will pull fine from the server and the other two will not. All three will pull if I copy to my local drive.
Have no idea what that could be. In general it shall be no difference if you query the file from local drive or from server.
I think I've solved it. It's something to do with the way that it's saved on downloading. Once I open and save the source excel workbook, everything shows up.
Interesting, thank you for sharing.
