Last seen: Dec 22, 2025
We're here to help 🙂 Which worked for you, the link or the Worksheet_Activate event?
In parts table, you have 3 countries: China, France, United States. In orders table, you have 5 countries: France, Singapore, Taiwan, Mexico, Switz...
There are ways to force users to enable macros. What if you don't allow them to see any sheet until they enable macros? They can see just a message: i...
Well, there are ways to force users to enable macros. What if you hide all the sheets from the workbook, and display just a message? They have no o...
Maybe disabling the menu item will help, I've seen some codes for that. Users will not be able to open the Headers and Footers menu to make changes: ...
In the attached file, I merged the 2 tables by 4 keys: Customer Name, Country, Platform and Quarter. This is the equivalent of performing a Vlookup ba...
I used the grouping from the attached image. I do not know which is the correct grouping, you should know that. In the Customer tab, you have perce...
Check the attachment for an example. The formula should check if the denominator is not zero, otherwise the result will be an error. When you ma...
Please prepare a sample file , with source data from the same file, paste some relevant sample data into 2 excel tables than make your queries, you sh...
You should use the Join type to “Full Outer (all from second, matching from first)” Normally, you should be able to Join the tables by matching mul...
Have you tested the sample file from the link I sent in the previous message? You have great examples on that tutorial, that can help you achieve what...
You can merge the Queries, you will have both parts and orders in a single table. From the merged query, you can create a single report, that will dis...
It's difficult to guess what is in your file, if you don't give details I cannot understand what's going on. That's why a sample file is more valuable...
Yes, you have to refresh all when new data is added to the source database. The preview of data from power query window is not for analyzing each r...
Hi Paula, Go to File-Account. In the right side, you will see Office product informations and a dropdown for Updates. Click on Update Now, to ma...