Last seen: Dec 22, 2025
When you create a new query from Online Services-From SharePoint Online List, In the Access SharePoint dialog box that appears next, you have 3 creden...
You can also try this: Create a new excel workbook. When you open it for the first time, which is the default cell format displayed in Home tab, Nu...
Yes, a simple Refresh All from Data tab will update all reports.
Yes, you can replace characters, just like I said in previous message, there is a Replace Values button in Transform tab, in the Power Query window. ...
You have to go to Power Query tab in Ribbon, click on Show Queries to view the Queries Pane, right click the query and select Edit (or just double cli...
Yes, from Power Query tab, choose New Query-From Database-MySQL Database, type the IP and database name, then the credentials in the next window. A...
Hi Hooi, You have to provide more details. In the file you mentioned, there is no code for connecting to the database, I hoped to find there the in...
If you connect the pivot table to an external data source, it will have a different pivot cache then the rest of the pivot tables that are using the i...
Glad to hear that your problem is solved, we are here to help 🙂 This is a good example that shows why there should always be sample files uploaded...
Hi Hooi, I suggest leaving the source data as is, use that table just for data entry, not for reports. See the attached file, Sheet1 does exactl...
I do have to say that I don't really understand the need of filtering both the source table and the pivot table report made from that table. Maybe ...
Hi Tim, Yes, you have to create a defined name with GET.CELL function to get the row height from a cell. The sample file you uploaded contains a GET...
yhooithin05 said For Each SlItem In ThisWorkbook.SlicerCaches("Slicer_Field1").SlicerItems----> Can i run through only the selected sheet but not ...
Hy Toby, You should perform a clean reinstallation for office, there is a cleanup tool from Microsoft: Uninstall-Office-2016-Office-2013-or-Office-...
yhooithin05 said Why do we have to disconnect all the slicers? Well, that's the name of the subject: "macro to detach all slicers from all pi...