Hi are you able to upload a sample of your worksheets ? are these sectors tagged with a group name ? if yes it will be easier to use Group By in ...
Hi, may be this is what you wanted, for Plant 1001 9000, two records you only take unique number, i.e. 9000, like wise for 1002 9000, only 900...
Hi, You desired display not very clear (what is 27,004( 9000+9001+9003) ?) Attached is the power query output, please take a look, if it is no...
Hi Mynda, found out the cause, as these 24 worksheets consists of two sets of datasets, one is table (each of the range cell format as table and ...
Hi Mynda one more query, after using Excel.Workbook(File.Contents("D:usersp....................XXXXX.xlsx"),null, true), the speed is really s...
Hi Mynda, Phil, Thanks for all the advises, I really appreciate. after so many investigation and I found out it was due to backend Office 2019 ...
Hi Phil On-Premise means local installed, ok, basically there are 24 worksheets (same structure) in one workbook (same workbook), what I wanted...
Hi Phil yes I am using on premises excel 2019, I got 24 worksheets and they are all formatted as tables, when I bring into a blank workbook using...
Hi Phil, I was attempting to bring in one workbook consists of 25 worksheets (same structure), after that I did a append as new query, then close...
Hi Mynda, I managed to fix it somehow Power query trying to access a user.zip, temp.zip in my power query directory, keep on saying is denied, ...
Hi Mynda, now I can't even see the UI in Power Query Editor when I click any query trying to edit in PQE, it shows Send Frown/OK and stay white s...
Hi Mynda, Got it and thanks for you guidance