Last seen: Jun 10, 2026
Is this the kind of thing you wanted?
It might also be useful to know your regional settings in case it's an issue with the decimal point.
You'd need to have two other queries that reference the first query, and add any additional steps in the other queries.
It's much harder to try and diagnose potential issues with code that you can't see... 😉 Especially as you haven't said what is actually happening. Ar...
Where are the images and what is the actual code line that inserts them?
They are not copies. They are temporary files created that contain information about who has a file open (they should be pretty small files).
FYI, you can also link the table in the data model to a table on a worksheet if you want, using the Existing Connections button on the Data tab. (You ...
You should be able to use CUBESET: =CUBEVALUE("ThisWorkbookDataModel";"[Measures].[Sum of Investments]";"CUBESET("ThisWorkbookDataModel";"[Invest C...
You can do it with code. For example, let's say you have the new query in A2 of Sheet1 of a workbook, add this code to it: Sub ChangeQuery() Dim wb...
You have two SaveCopyAs commands, so you will end up with two copies of the workbook each time, plus the original. I can't tell whether Save_Backup al...
It's still only for Insiders as far as I know. Even with that, I only got them about a week ago I think.
FYI, cross-posted:
Try: =LOOKUP(2,1/(Table134[solacom-RingTime]=Q3)/(Table134[solacom-callType]="SR911")/(Table134[Week]=Q2),Table134[Date Time])
Is it also a web query?
=INDEX(A:A,match("6-Month Review",G:G,0)) should do it.