Last seen: Apr 29, 2025
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.
I can also refresh it on: M365 on Win10Enterprise M365 on macOS Sonoma Office 2019 on Win11 (ARM version in a VM) Perhaps it's a fire...
In 2019 that would definitely not be a small change! I can't think of any way offhand without a lot of helper columns and/or terrible performance. ...
Enter it with Ctrl+Shift+Enter then copy down.
Which version (and build, if 365) of Office do you have?