Forum Discussion
Adding multiple Percentile columns to each Table in a Table of Tables
Hello Anonymous
about question 1) this is a column you added to the query-table manually. Just delete it.
question2) I know that in some excel-versions the table is selected after refresh. The only way you may be able to work around is to use a makro, that does a select of a single after the refresh
Hope that helps
Jimmy
Jimmy801 i did not add that column. if you see my query code, only the required columns are being generated. But in this one, an extra column gets added. Try unloading the query and loading it to a new worksheet and see for yourself. Not sure why its happening with this query only. My concerns are that this extra column could be the reason why my excel workbook gets corrupted when vba code is applied.
P.S: Strangely, i see 3 dots "..." in the last row of this column.
Hello Anonymous
I cannot confirm that. When I unload it and load it, then the correct data is shown in a new sheet
Then there is something else causing this
BR Jimmy
Now i got 2 extra columns viz., Column1 & Column2 added when i loaded to a new sheet in Column C and 5 extra columns when i loaded to a new sheet in Column F. I think i know what is happening. When i add a new sheet and select the column & row i.e cell where the data should be loaded, it somehow offsets those many columns from the table start column.
If i just load it by selecting New worksheet in the load dialog, it will default to the 1st column only and so no extra column gets added.See, if you are aware of this same behaviour in your excel and if you know whats causing this issue.