Forum Discussion
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 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?
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 Replies
- 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.
Hi Josh,
You mean when you use something like
= Excel.Workbook(File.Contents("\\server\SharedFolder\MyFile.xlsx"), null, true)?
