Last seen: Apr 29, 2025
Hello, If you are certain that the workbook is saved, then do set the saved property in the code too. Should prevent the question to pop up. If ...
Hello, Adding a simple example file based on your PDF as source. When testing you can add new data to the Page001 table and then refresh the Pivot ...
Hello, If you right click and choose Save link as, do you get a proper file then? Br, Anders
Hello, Assuming that the source data that is loaded into Power Query in this case will be a table in the same workbook, then it will work for every...
Hello, Power Query lets you import data from different sources, gives you tools to transform the data so it suits your needs and then you present i...
Hello, If you add the week number to the data table then I see no problem to group by week number. See attached file for an example. If you don't w...
Hello, I have made another variant where I add some helper columns to the table, which in my view makes it easier to follow the logic for the diffe...
Hello, Not sure you need a Pivot Table for the data, but then I don't know how much data you do have. Attached is an example of using a Pivot Table...
Hello, If you remove the AllYears query, you can then delete those two columns in the table and then add the AllYears table into Power Query again....
Hello, I would go with Power Query too, but a formula version I would use is =SUM(('Sheet 2'!$E$4:$P$2558)*(('Sheet 2'!$A$4:$A$2558=$A3)+('Sheet...
Hello, Is it Power Query Custom Data Types you are looking for? Br, Anders
Hello, If you attach a sample file with some data it would be much easier to give you a correct answer. The XLOOKUP function can return values in m...
Hello, According to information at Microsoft support pages. (As per date of this post) Python in Excel is now available to Enterprise and Busi...
Hello, I had lots of issues with the dates in your sample file, so I took the liberty to make a variant of it. You need to check if the numbers are...
Hello, You can use ISTEXT instead for such scenario. Br, Anders