Forum

That happens because your computer date format is set to US format: MM-DD-YYYY. The text file has a different date format: DD-MM-YYYY, PQ fails to ...

SUM function does not work because you have text in Sales columns, make sure you have ONLY numbers, remove those "-". (see sheet 1 cell D64 for an exa...

Why in column D: Anantapur is repeated 7 times Chittoor is repeated 9 times?

Can you provide a sample file where we can replicate the issue? Hard to say, it may be something related to your sheet setup.

PQ Editor is not excel, it has different functionality. Load data to worksheet if you want to review all rows, PQ has only a data preview, in order...

Hi Richard, There is a fuzzy merge option in PQ, expand the advanced Merge options (hope your version has these options) You can add the match p...

Hi Franck, Optimizing cuts is not an easy problem, cannot be solved with a simple formula. See this video, it's cheaper to buy specialized softw...

Possible solution attached.

Hi, When you write into: Cells(sonsat, 2) = TextBox1 You have to disable events, because you are using a Sheet Change event. That event trigg...

Hi Hayley, You should not create new caches for new pivot tables, if they share the same data source. Slicers cannot be connected to multiple pivot...

The code provided will refresh a power query. (ThisWorkbook.Worksheets("SheetName").ListObjects("TableName").QueryTable.Refresh ) To refresh a p...

Use this code in a standard module: Option Explicit Public TimeInterval As Double Sub RefreshQuery() ThisWorkbook.Worksheets("SheetName")...

Try adding a new column with the formula: List.Zip({[ListA],[ListB]}) Those 2 lists must have the same number of elements.

These lines needs to be changed: Application.UserName & " changed " & Caller & " (row " & Wks.Range(Cell).Row & ") " _ & " fro...

Ok, I understand you need to store form data into an archive (sheet B), but why that sheet B must be in a separate file? You can store template data i...