Forum

Hi Tim, Trying to allow for a variable number of rows at the top is not a trivial exercise. However, I think it's highly likely that the reports wi...

Hi Mick, Welcome to our forum! You can use a chart label trick to do this as explained in this post. See your file attached. Mynda

Hi Kyrstin, Welcome to our forum. I had no problems using the Get Data > From Folder connector to extract the data in your files. I used the ...

Hi Liv, The problem is that you don't have a version of Excel that supports the SEQUENCE function, which is only available to Microsoft 365 users. ...

Hi Liv, The dates in row 5 start at May 1, which is inline with the minimum date in your Data sheet. I'm not seeing the problem there. The year ...

Hi Graham, TBH I've never paid a lot of attention to the syntax of the Excel.Workbook function as this is something Power Query typically codes for...

Hi Tim, It's tricky to say without seeing your file, but as I read your message I thought of trying remove blanks and then promote headers instead ...

Hi Niamh, Welcome to our forum! You can use the Group By tool to number grouped data, which you can then summarise in a PivotTable into your des...

Hi Danijela, Welcome to our forum! Looking at the file, they currently have a detailed forecast by account over 12 months x 5 years and I guess ...

Hi Graham, Code 1 is referencing a sheet name and code 2 is referencing a named range. Mynda

Hi Marc, The queries should refresh in order by default. The PivotTables will only refresh correctly the first time if they are referencing the que...

Hi Marc, I'd say this is down to your privacy settings for this query. Open the query and go to the File tab > Options & Settings > Data ...

Yes, absolutely! You can install Windows OS on your Mac using Parallels or similar VM software.

Hi Andrew, You told me which sheets, but I don't know what data you wanted to return and in which cells on the Dashboard sheet. That said, the best...

Hi Bhavnesh, Welcome to our forum! Excel doesn't have searchable functionality unless you're using Excel Online. Here are some tutorials on how ...