none
Power Query Cannot Combine Data RRS feed

  • Question

  • Hello, 

    This morning I was able to use get and transform to merge workbooks in a given file pretty easily. When I selected which file I wanted to get the date from, a prompt would pop up and ask if I wanted to load or edit and load the data first in which case I chose to edit the data, manipulate it, then load to my workbook. I ran into an unrelated computer issue later in the day which caused my IT department to uninstall and then reinstall microsoft office. After doing this, I was no longer to combine the data as easily as before. Now, after selecting the folder I want to grab the data from there is no prompt asking me if I want to edit then load or anyhting like that. I jsut get brought straight to the query where it shows me the file names and I can no longer combine the data. Does anyone have any input here? IT has assured me that my excel is up to date but I know prior to reinstalling I was able to do this but now I can not. 

    Thank you!

    Tuesday, April 23, 2019 10:07 PM

Answers