Forum Discussion
Excel files 'null' when closed but with data when opened
Hi all, I am importing several hundred Excel files from a folder into Power Query. Unfortunately, for some sheets within every file Power Query shows 'null' only. When I open the sample file and ...
I suspect something is named differently in the files showing null. Look at your M code in the Advanced Editor in the query editor and look for specific references to named things (files, tabs/worksheets, tables, etc.). Note that Power Query is case sensitive.
Pat