Forum

Ok, now I have more questions and one still unanswered: 1. Where is the form putting the data? Surely it's not only emailing it to you. Isn't it p...

Hi Maurice, Welcome to our forum! I think there is a bug with importing csv files at the moment. Open the CSV file in Excel, then File > Save...

Hi Jithesh, Welcome to our forum! Presumably when someone enters their name they don't prefix it with 'First Name' and 'Last Name' etc. so how w...

Yes, that's what I said. Excel.CurrentWorkbook doesn't work with undefined ranges of data. You can either get the data into another workbook using Exc...

Hi Chris, As I said, If you don't want to format your data in an Excel Table then Excel.CurrentWorkbook will also work with defined names. i.e. it ...

Hi Deep, Welcome to our forum! You only attached one file, so it's a bit difficult to help specifically, but this is similar to replicating an appr...

Hi Chris, Excel.Workbook cannot get data from an Excel file that is open, therefore you can't reference the current file using this function, whic...

Hi Jon, Refresh the query, then click on the cog icon beside the Expanded Content step > click 'load more' > check the box for the new column...

Hi Vivian, You need to change the order of the series in the PivotTable so that it displays Actual in column C, then Budget in column D. Mynda

Hi Ben, Welcome to our forum! The overall size of any chart will not change automatically upon refresh/new data being added. The plot area insid...

Yes, as explained here. Obviously you only have one file, but the concept is still the same because you have multiple sheets. Mynda

Hi Hussain, I don't think your question is quite clear enough. Presumably the bigger list won't have just 13 rows remaining and that there will be ...

Hi Vivian, I don't know what would be causing this. After opening it at home, did you save it and then try opening it at work again to see if that ...

Hi Alexios, Welcome to our forum! This should be done in the PivotTable rather than Power Query. If you want to share a sample Excel file we can he...

Hi Bruno, This is a job for Power Query, so I've moved your topic and edited the subject accordingly. You can use Power Query's Unpivot tool to fix...