Forum

Hi Lin, Did you use the Power Query from web, or the Get External Data > From Web option? I suspect you used the latter. If you're using Excel 2...

Hi Ed, No idea, but I wonder if you changed any of the chart types to a line chart in the process? Maybe this affected the legend. Otherwise, I'...

Hi Hasnat, This is a known bug. The 'fix' is to edit any cell and the mouse will focus on the worksheet again. Mynda

Hi Melvis, Easy, place your values field in both the 'Values' area and the 'Filters' area of the PivotTable. In the filter remove all zero and N/A ...

Hi Anne, I've made some notes beside your list below to point you in the right direction: 1. Remove all rows with Ended in them > Text Filter...

Hi Adele, I'd say if it's telling you there are duplicates then there are. Are you able to share the file? Or at least the 3 tables in question? Yo...

You could try: =IF(ISERROR(INDEX($A$1:$B$8,SMALL(IF($A$1:$A$8<>$E$1,ROW($A$1:$A$8)),ROW(1:1)),2)),INDEX($A$1:$B$8, SMALL(IF($A$1:$A$8<>...

Hi Joe, I'm not aware of any that aren't safe or broken. I like the Sparklines as they are most useful to me, but that doesn't mean they're the bes...

Hi Tim, Try saving to your desktop as a .xlsb file. Mynda

Hi Peter, When you import the file you should get a dialog that allows you to choose the tables in the XML file. Do you see more than one table? If...

Another option is to educate the users on what to select; either in person, or put a 'read this' note at the front of the file that explains the proce...

Hi Blanka, You have two options; 1. Set the query to Fast Combine: There are risks with this. 2. use the technique described here: My...

Hi Joe, You can set the format of the field in the modelling tab. Select the field in the field list and then go to the Modelling tab where you'll ...

Glad it was helpful, Marilyn 🙂

Hi Fred, You have two options: 1. Insert a dummy PivotTable that contains the field you want in your Slicer. Then insert a Slicer for the PivotT...