Last seen: Dec 22, 2025
If you don't type anything in file filter input box, the default file filter is *.* , this means that a file name should any chars before and after th...
Hi, Please test the file attached, I tested it and works with FileSystemObject. The results of the test are in the file. Cheers, Catalin
Hi rathanak, Whenever there is no answer, this may mean that the subject is not clear enough, it's a good idea to come up with more details and an ...
Make sure that Workbook calculation is set to Automatic, not Manual, this can be a reason. You can upload a sample file where this problem can be test...
Hi Daniel, The problem is a complex one, there is no simple formula. You can see how complex things can be here: Schedule Calculator I sugges...
oops, my mistake. In DAX the formula is very similar to an excel formula: NewColumn = IF(ISERROR(SEARCH("komunne", TableName[ColumnName])),0,1)
Hi Marianne, You can try Text.Contains formula: =if Text.Contains([ColumnName], "kommune") then 1 else 0 You can also use multiple nested if ...
You're welcome 🙂
You can try a fairly simple code that will prevent users from typing wrong values in real time. There are some examples on this page, with date format...
You should add the code to the personal.xlsb workbook, and add an icon to your toolbar, with that code, this way the code will be available only on yo...
The code you posted is just protecting the sheet, without unprotecting the sheet before refresh. More, the code is protecting the sheet before refresh...
Unfortunately, you have to use vba for refresh on protected sheets, or manually unprotect before refresh.
Did you checked the formula from cell G2? There are no cell references other than $A$17 and $A$5, and these are the pivot tables first cells (a piv...
You can Append table2 data to table 1 data, check the attached file. In each query, I added a custom column to indicate the Data Source (orders-Parts)...
If there is no relationship between the tables, then what are we talking about 🙂 ? the Parts/Orders division does not make sense in this case. You...