Last seen: Jun 14, 2025
Hello, Just tested to add som new sub-categories and categories in a fresh downloaded copy of the personal budget file, had no issues. Br, Ander...
Hello Stuart, If you expand the formula bar you will see the rest of the formula, you can either click on the arrow on far right, press CTRL + SHIF...
Hello, There are ways to minimize the data size, for example this article about Reduce the file size of your Excel spreadsheets. The best tip is to...
Hello, Difficult issue there. I have not stumbled upon such issue myself, but anyway, something seems to trigger the creation of those other querie...
Hello, Attached is a formula version based on what you have entered manually, I might have got the wrong understanding, but it is adjustable so jus...
Hello, The document file size will of course grow with new data added. There are ways to minimize the growth, for example this article about Reduce...
Well, then the question is if there is another workbook that is the active workbook? Does it work better using ThisWorkbook.Save instead? Otherwise...
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...