khawarameer
Board Regular
- Joined
- Jun 2, 2009
- Messages
- 152
Hello,
I am trying to import 05 excel files (.xlsx) from a folder in to power query. However when i use combined binaries it gives me error that said files are not in proper excel format. Further when it try to import individual file power query shows 3 sheets in the file where as i have made only one sheet in all these files with common name "Consolidated". can any one help however import all excel files.
Regards
KAM
I am trying to import 05 excel files (.xlsx) from a folder in to power query. However when i use combined binaries it gives me error that said files are not in proper excel format. Further when it try to import individual file power query shows 3 sheets in the file where as i have made only one sheet in all these files with common name "Consolidated". can any one help however import all excel files.
Regards
KAM