Power query - Combine and Edit Window

Dear Community, I'm using Excel 2016. When I tried to load data from folder, after giving the folder path, a window appears , where it list all the files, and we can choose to "combine and Edit,...

excel

Bruce0108
Apr 13, 2020
Mynda Abiola1 SergeiBaklan After lot of research, I have FIXED the problem by replacing Addins folder from another system. My system has lesser files compared to another system. I copied the whole addins folder under C:\Program Files\office16 and replace my folder. and it works now. and Thank you for all of your inputs. However, I didn't understand how a installation have less files 🙂

Bruce0108

Copper Contributor

Apr 13, 2020

Mynda Abiola1 SergeiBaklan After lot of research, I have FIXED the problem by replacing Addins folder from another system. My system has lesser files compared to another system. I copied the whole addins folder under C:\Program Files\office16 and replace my folder. and it works now. and Thank you for all of your inputs. However, I didn't understand how a installation have less files 🙂

SergeiBaklan
Diamond Contributor
Apr 13, 2020
Bruce0108

Why didn't you simply repair the Office?
- Bruce0108
  Copper Contributor
  Apr 13, 2020
  SergeiBaklan I did try to reinstall, it didn't work either.

Forum Discussion

Power query - Combine and Edit Window

Resources