Forum Discussion
combining 5 different excels in 1 main file
I have five colleagues that have their own action lists where per task they keep by when they have started a task and what has done and when they have finished it. The columns are in all the excels ...
You may use Power Query in master file using From Folder connector. From time to time copy updated files in one folder / SharePoint folder and Refresh master file.
thank you, one more question, if I refresh the data, the columns get very long / the width of the columns change every time, and I have to change the "view" after every refreshing. is there a way to make sure the width does not change?