Get & Transform won't pull sheet titles

[Josh Treen]

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 pull through without a problem:

However, if I use the same file on a network share, I get the following

Any ideas as to why this would be happening? 

[#2]

Hi Josh,

You mean when you use something like

= Excel.Workbook(File.Contents("\\server\SharedFolder\MyFile.xlsx"), null, true)

?

[#3]

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.

[#4 · Accepted solution]

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. 

[#5]

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.

[#6]

Interesting, thank you for sharing.