Forum

Thanks for confirming, Peter. I can only think there is something throwing Excel 2019 off that's causing these errors. Glad the new file is working fo...

Hi Peter, Thanks for sharing the screenshots. The formulas should still show the results as long as you don't edit them. Anyhow, I've attached a fi...

Hi Craig, Glad you've figured out a workaround. Your users will need to be very specific about which query they refresh as opposed to Refresh All s...

Hi Craig, I have so many questions! First, I think there's some confusion with regards to putting the file containing the query on Teams vs the sou...

Hi Nader, Welcome to our forum! Please upload a sample Excel file that illustrates what you want to do so we don't have to recreate data in order t...

Hi Peter, None of the files are attached that you mention. Remember to click the 'Start Upload' button after selecting your file and wait for the g...

Hi Jessica, Seeing that you don't want to display the values, just the colours, you can add a column that takes the absolute value of the HRGC and ...

No worries. I didn't see your comment about posting on TechNet because you followed up with another post and only read the last one thinking I had rea...

I don't think you can use VBA to edit queries, but you could try. TBH I've never used VBA to edit queries. BTW, you should let us know when you cro...

Hi Casey, My understanding is you want one column for type of funding, one for amount and so on. If so, you need to duplicate the query, once for e...

Hi Keith, It's not clear where the error is occurring, but presumably it's the "Filtered Rows3" step. The error is telling you that you're trying t...

Hi Johan, I'm a bit fuzzy on what you're actually trying to do. The classification of the data into XYZ and ABC should be done in Power Query. I th...

Hi Pieter, One idea that has come back is to check if you can turn off the security settings in the query. You might need to do that in the Mac sep...

Hi Chris, Looks like the dates in rows 1 and 9 are corrupted in some way. I copied the dates to new cells and pasted as values, formatted as dates,...

Hi Grace, The problem is the numbers in sheet2 (3) are text, and the numbers in Sheet2 (2) are numbers. You can tell the numbers in sheet 2 (3) are...