Forum

Hi Shawn, Thanks for sharing further information. 1. I'd say the VBA is specifying the axis labels when the 'Refresh Chart' macro is run. There'...

Hi Patrick, The 'value if false' argument is omitted and your formula is incomplete, so I'd say that's causing the problem as it's going around in ...

Hi Doug, Looks like you're in Excel Online. There's no Power Query editor in Excel Online yet. Mynda

Hi Rasit, Welcome to our forum! I think Named Sets can help you. Mynda

Hi Jacqui, This formula will give you a list of Thursday and Friday dates where A1 contains the first date you want to start at: =WORKDAY.INTL(A...

Hi Jacqui, It depends on whether those workdays are sequential or not. e.g. are they Monday and Tuesday or Monday and Thursday? Also, please confir...

So the problem is that you can't get a PivotTable to display in the layout shown in the Template sheet. If that's the case then you'd need to write so...

Hi Alison, Unfortunately, the file doesn't really help me understand why the 'Show report filter pages' tool doesn't work for you (I honestly think...

Hi Peter, Have you see this tutorial on scraping data from multiple web pages? I can see from the URL structure that you have parameters in the str...

Hi Shawn, It's difficult to hold a picture of your workbook in my head in order to answer your question. Please upload an example Excel file with s...

Hi Alison, The file didn't get attached. You need to click 'start upload' after selecting your file, then wait for the grey check mark beside the f...

Hi Kabil, The data/business isn't something I'm familiar with. It uses acronyms I don't recognise, so it's difficult to help without further explan...

Hi Jim, That's not incremental refresh in the true sense. The purpose of incremental refresh is to prevent Power Query getting all the data every t...

"In both these cases there should be no problem to autorefresh all the copies of Pivot Table / Power Pivot with a single click on the "Refresh All" bu...

Hi Libor, The answer partly depends on which version of Excel you have and partly on whether you need Power Pivot and DAX function capabilities. ...