Last seen: Mar 17, 2025
Hi Anke, If file A is open, querying File_A data from another file will return a query error. Maybe you can change the code to save a copy of the F...
If you don't want to see the "nag" dialog box, you can just remove the code that displays the message box. If cmtCount = 0 Then MsgBox "No threaded...
Hi Sherry, That error was solved, you are using an old version. Use the file sent on august 25 August 24, 2022 - 3:45 pm My mistake...
There is no safe or unsafe method. Only in PBI you can give access to reports with granular access to data, with no access to data sets, but this requ...
No file attached. Can you upload a screenshot with the line in code that returns that error? When you press debug, that line is highlighted.
Is there a way to quickly remove all filters in an Excel Table? Hi Ian, Late reply, but I think will be useful: Press Ctrl+Shift+L keys TWI...
What you can do is to insert several rows/columns between existing pivot tables. Once you add them between 2 pivots, you can try the refresh, if refre...
Hi Peiqian, Usually, you should not have pivots one under another, only if you have a number of categories that don't change over time, or you're s...
Hi Trias, You can use this: Sub Makro2() dim y as string dim z as string y = "N" z = "AV" Makro1 y, z ' call and pass variables end sub S...
Are there missing comments anymore? Please post a sample file where the code adds 35 comment columns and there should not be this many.
The file you uploaded in your other topic has a different structure. In the new file, there seems to be only one dependent task? Previously there w...
Is it the only file open? If not, try closing all other files. There is nothing wrong in your file, any change is instant on my side. Can you sh...
Too many formulas probably, how many records you have in your tables?
Hi Deborah, You have to create your dependency system. Here is the formula I used in the structure below: =IFERROR(IF(AND([@Completed]=TRUE,I...
Can you try: ActiveWorkbook.FollowHyperlink Address:= Application.WorksheetFunction.EncodeURL("\bradford#helixFSRSWarehouseWarehouseWarehouseEquipm...