Forum

Hi Patrick, Your formula in Col I was referencing itself - you should have been given warnings by Excel about 'circular references' when you opened...

Hi Nawaf, PC specs are only part of the story. Performance in PP and PQ will be affected by things like: A poorly designed data model Writin...

Hi Chris, You could nest them inside each other but that'd be very ugly! Try this = Table.SplitColumn(#"Trimmed Text", "String", Splitter.Sp...

Hi Dave, If you're getting this data from the web then you should try using Power Query to get it. But with the data supplied already in Excel, th...

Hi Gokhan, No file is attached to your reply. Did you try my file? Regards Phil

Hi, This can be done in a Power Pivot Pivot Table. Have you got PP? What version of Excel do you have? See attached for solution, and this post...

Nearly forgot to mention that you will need to make a change to the PQ Options otherwise every time the query runs PQ will ask you to give permission ...

Hi Brian, I can't write a SQL UPDATE without knowing things like your table and column names so here's some code that works on the AdventureWorks s...

You're welcome

You're welcome.

Hi Bruno, You can access the file in PQ using a From Web query and the URL to the file PQ will see it as an XLSX file and show you the 4 table...

Hi, This line Set ExpenseTable = ThisWorkbook.Worksheets("ExpenseData").ListObjects("Expenses") had curly quotes like this “” around Ex...

Hi Sue, wrap it in IFERROR e.g. =IFERROR(EDATE(C34,35),"") Regards Phil

Hi, Are you asking how to find out the chart type for all charts on the active sheet? Change the For Each loop to this For Each ChtObj In ...

Hi Please attach your workbook with the code that is generating the error. Phil