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