Month: June 2024
XLOOKUP formula not working
Hello
I’m having trouble with the XLOOKUP formula, my excel doesn’t show that it has this formula. I have the newest version of excel and the formula worked perfect on my other computer – windows and now I have Mac Air. I transferred all the files and nothing is working.
The formula
=XLOOKUP(A3;Toiduained!A:A;Toiduained!B:B;)
and shows error #NAME?
How can i get XLOOKUP formula on my excel?
Hello I’m having trouble with the XLOOKUP formula, my excel doesn’t show that it has this formula. I have the newest version of excel and the formula worked perfect on my other computer – windows and now I have Mac Air. I transferred all the files and nothing is working. The formula=XLOOKUP(A3;Toiduained!A:A;Toiduained!B:B;)and shows error #NAME? How can i get XLOOKUP formula on my excel? Read More
Deleting Teams Chat History
Hello
Please i need your help on this issue.
A new staff will be taking over an existing user account. Is there a way for a user to permanently delete their entire Teams 1:1 chat history? We want the new staff to have access to all emails and groups but not the 1:1 chats in Teams.
Hello Please i need your help on this issue. A new staff will be taking over an existing user account. Is there a way for a user to permanently delete their entire Teams 1:1 chat history? We want the new staff to have access to all emails and groups but not the 1:1 chats in Teams. Read More
Busy on Busy settings
We use Teams to make phonecalls and use the busy on busy settings with the busy signal.
But we have a problem now with transfering incoming calls.
If a co-worker receives an incoming call and wants to transfer it with feedback to me, the treansferred call disconnects after transfer because Teams thinks I am still in a call. (the feedback call)
How can we solve this issue?
We use Teams to make phonecalls and use the busy on busy settings with the busy signal.But we have a problem now with transfering incoming calls.If a co-worker receives an incoming call and wants to transfer it with feedback to me, the treansferred call disconnects after transfer because Teams thinks I am still in a call. (the feedback call)How can we solve this issue? Read More
Secondary mailboxes and FSLogix Roam Identity
HI,
Got a bit of a puzzler, so we have a client who uses outlook to access the main mailbox on the tenant, but they also have a secondary mailbox added to outlook from a different tenant, so when they log in it authenticates to both, all good. The reason they have it set up this way is to do with signatures.
With existing FSLogix this works fine, we then upgraded them to the latest, this changes the authentication method and puts the token on EntraID, the secondary mailbox now wants the password every time, as its on another tenant. Makes sense, so enabled Roam Identity to put back status quo. However this then pulls the machine out of EntraID/Intune, and recommendations is not to use Roam Identity if enrolled into Intune.
Anyone else come across this or any way forward/guidance, have about 50+ users set up this way?
Thanks
HI,Got a bit of a puzzler, so we have a client who uses outlook to access the main mailbox on the tenant, but they also have a secondary mailbox added to outlook from a different tenant, so when they log in it authenticates to both, all good. The reason they have it set up this way is to do with signatures. With existing FSLogix this works fine, we then upgraded them to the latest, this changes the authentication method and puts the token on EntraID, the secondary mailbox now wants the password every time, as its on another tenant. Makes sense, so enabled Roam Identity to put back status quo. However this then pulls the machine out of EntraID/Intune, and recommendations is not to use Roam Identity if enrolled into Intune. Anyone else come across this or any way forward/guidance, have about 50+ users set up this way? Thanks Read More
Make software oath mandatory in addition to other MFA methods
Hi,
We’re seeing quite a few issues with users who bought a new phone, and subsequently are locked out of their account due to MS Authenticator not properly porting their information to their new device. I’ve been trying to promote using software oath (in our case configure MFA using 1Password) to prevent such lockouts and reduce the number of support tickets , but with limited success so far.
Is there a way to not just make MFA in general mandatory, but also specify that software 2FA app needs to be one of them (in addition to e.g. MS Authenticator)?
Thank you!
Hi, We’re seeing quite a few issues with users who bought a new phone, and subsequently are locked out of their account due to MS Authenticator not properly porting their information to their new device. I’ve been trying to promote using software oath (in our case configure MFA using 1Password) to prevent such lockouts and reduce the number of support tickets , but with limited success so far. Is there a way to not just make MFA in general mandatory, but also specify that software 2FA app needs to be one of them (in addition to e.g. MS Authenticator)? Thank you! Read More
what is the meaning of flags in Digiinfo?
Hi
When using Digiinfo to examine the touchpad output, the ‘buttons and flag’ column has four types of flags: tip, confidence tip, confidence, and blank. What do these four flags mean respectively? How are these flags generated?
The flag is “Tip” when I touch the touchpad with a palm.
The flag is “confidence tip” when I touch the touch pad with a finger tip
The flag is “confidence” when my finger leave the touch pad.
The flag is blank when no object touches the touchpad.
How does Digiinfo determine the flag??
Hi When using Digiinfo to examine the touchpad output, the ‘buttons and flag’ column has four types of flags: tip, confidence tip, confidence, and blank. What do these four flags mean respectively? How are these flags generated?The flag is “Tip” when I touch the touchpad with a palm.The flag is “confidence tip” when I touch the touch pad with a finger tipThe flag is “confidence” when my finger leave the touch pad.The flag is blank when no object touches the touchpad.How does Digiinfo determine the flag?? Read More
Reaction Button has disappeared
Hello,
For one of my colleague (and only one) the reaction button has disappeared (or may be, was never been there)
We’re using Exchange mailbox on Outlook with 0ffice365 licence
How to proceed to activate this button ? (I’ve searched but not find anything 🙁 )
Thanks for your help
Hello,For one of my colleague (and only one) the reaction button has disappeared (or may be, was never been there)We’re using Exchange mailbox on Outlook with 0ffice365 licence How to proceed to activate this button ? (I’ve searched but not find anything 🙁 ) Thanks for your help Read More
Holidays in red in calendar navigator
Is it possible to show holidays in red in Calendar navigator?
In top left of Outlook, here:
If not, are there any plans to add this feature?
Is it possible to show holidays in red in Calendar navigator?In top left of Outlook, here:If not, are there any plans to add this feature? Read More
New Outlook client – view online archive of shared mailbox
Hi there,
I have a user who has an Office 365 E3 license and is using the new Outlook client.
He has access to a shared mailbox and it is appearing on the client.
The shared mailbox has an in-place/online archive but it is not appearing on the client.
The archive of the shared mailbox appears on the old Outlook client and on OWA.
Is anyone else having the same issue?
I checked and found the below:
It mentions that shared mailboxes are supported and online archives also, but no mention of the online archive of a shared mailbox.
Does anyone have more info?
e.g. an official technote from Microsoft on whether it is supported or not.
Hi there, I have a user who has an Office 365 E3 license and is using the new Outlook client.He has access to a shared mailbox and it is appearing on the client.The shared mailbox has an in-place/online archive but it is not appearing on the client.The archive of the shared mailbox appears on the old Outlook client and on OWA. Is anyone else having the same issue?I checked and found the below:https://support.microsoft.com/en-us/office/new-and-classic-outlook-for-windows-feature-comparison-de453583-1e76-48bf-975a-2e9cd2ee16ddIt mentions that shared mailboxes are supported and online archives also, but no mention of the online archive of a shared mailbox.Does anyone have more info?e.g. an official technote from Microsoft on whether it is supported or not. Read More
Using Azure Storage Blob as a CDN using Azure CDN – Anonymous Public Access
Hi all,
I am wondering if anyone here has any answers to help solve for this problem. We have a CDN which is used by a public website. The CDN is using Azure CDN / Frontdoor with a custom domain and is connected to the Azure storage blob using a VPN. The Storage blob is setup to only accept connections from the VPN and specified IP addresses and to add new content to the storage blob you need to request elivated permissions via PIM to an RBAC role specific to this storage blob.
The problem is the company I am working for want to enforce disabling anonymous public access to the storage blob and we can’d use SAS tokens from the website. Our tests show that doing so stops anyone accessing the website from being able to load assets from our CDN.
Is there some way to configure the storage blob to accept anonymous public access only from the CDN while still turning off the anonymous public access on the storage blob?
Hi all,I am wondering if anyone here has any answers to help solve for this problem. We have a CDN which is used by a public website. The CDN is using Azure CDN / Frontdoor with a custom domain and is connected to the Azure storage blob using a VPN. The Storage blob is setup to only accept connections from the VPN and specified IP addresses and to add new content to the storage blob you need to request elivated permissions via PIM to an RBAC role specific to this storage blob. The problem is the company I am working for want to enforce disabling anonymous public access to the storage blob and we can’d use SAS tokens from the website. Our tests show that doing so stops anyone accessing the website from being able to load assets from our CDN.Is there some way to configure the storage blob to accept anonymous public access only from the CDN while still turning off the anonymous public access on the storage blob? Read More
Triangulation of hollow objects
Hi all,
simply, how to make the simple hollow 3D triangle depicted below?
Is there some contraint method I could use instead? I use the following command to get the surface:
tri = triangulation(delaunay(x,y),x,y,z);Hi all,
simply, how to make the simple hollow 3D triangle depicted below?
Is there some contraint method I could use instead? I use the following command to get the surface:
tri = triangulation(delaunay(x,y),x,y,z); Hi all,
simply, how to make the simple hollow 3D triangle depicted below?
Is there some contraint method I could use instead? I use the following command to get the surface:
tri = triangulation(delaunay(x,y),x,y,z); delaunay, triangulation MATLAB Answers — New Questions
how print multiple values on screen in one line in matlab
I am doing image image processing in matlab , so if many object will be detected at once, then i want multiple vallues in at once in one line . I mean I will be getting cordinates of every box which is detected .I am doing image image processing in matlab , so if many object will be detected at once, then i want multiple vallues in at once in one line . I mean I will be getting cordinates of every box which is detected . I am doing image image processing in matlab , so if many object will be detected at once, then i want multiple vallues in at once in one line . I mean I will be getting cordinates of every box which is detected . image processing, fprintf MATLAB Answers — New Questions
Error using barrier Objective function is undefined at initial point. Fmincon cannot continue.Error in Calibration (line 161) [x, fval ] = fmincon(GGG, x0, A, b, Aeq, beq, lb,
Hello,
Please can someone help me solve this issue. I keep getting the below error. Attached also is my matlab codes.
Thanks,
Celestine.
>> Calibration
Error using barrier
Objective function is undefined at initial point. Fmincon cannot continue.
Error in fmincon (line 861)
[X,FVAL,EXITFLAG,OUTPUT,LAMBDA,GRAD,HESSIAN] =
barrier(funfcn,X,A,B,Aeq,Beq,l,u,confcn,options.HessFcn, …
Error in Calibration (line 161)
[x, fval ] = fmincon(GGG, x0, A, b, Aeq, beq, lb, ub, nonlcon, opts);Hello,
Please can someone help me solve this issue. I keep getting the below error. Attached also is my matlab codes.
Thanks,
Celestine.
>> Calibration
Error using barrier
Objective function is undefined at initial point. Fmincon cannot continue.
Error in fmincon (line 861)
[X,FVAL,EXITFLAG,OUTPUT,LAMBDA,GRAD,HESSIAN] =
barrier(funfcn,X,A,B,Aeq,Beq,l,u,confcn,options.HessFcn, …
Error in Calibration (line 161)
[x, fval ] = fmincon(GGG, x0, A, b, Aeq, beq, lb, ub, nonlcon, opts); Hello,
Please can someone help me solve this issue. I keep getting the below error. Attached also is my matlab codes.
Thanks,
Celestine.
>> Calibration
Error using barrier
Objective function is undefined at initial point. Fmincon cannot continue.
Error in fmincon (line 861)
[X,FVAL,EXITFLAG,OUTPUT,LAMBDA,GRAD,HESSIAN] =
barrier(funfcn,X,A,B,Aeq,Beq,l,u,confcn,options.HessFcn, …
Error in Calibration (line 161)
[x, fval ] = fmincon(GGG, x0, A, b, Aeq, beq, lb, ub, nonlcon, opts); fmincon, optimization MATLAB Answers — New Questions
How to connect MATLAB on windows OS to Clickhouse database server on a cloud Linux virtual machine?
Hi,
My computations are stored in a Clickhouse databse server on a Linux (Ubuntu) virtual machine (VM). I would like to access the data from the Clickhouse server on the VM to MATLAB in my local machine on windows OS, so that I can process the data locally.
I tried to explore the database tool box, but since I am new to this, I haven’t been able to connect to the database on the VM.
I would appreciate pointers from the experts.
Thanks in advance.Hi,
My computations are stored in a Clickhouse databse server on a Linux (Ubuntu) virtual machine (VM). I would like to access the data from the Clickhouse server on the VM to MATLAB in my local machine on windows OS, so that I can process the data locally.
I tried to explore the database tool box, but since I am new to this, I haven’t been able to connect to the database on the VM.
I would appreciate pointers from the experts.
Thanks in advance. Hi,
My computations are stored in a Clickhouse databse server on a Linux (Ubuntu) virtual machine (VM). I would like to access the data from the Clickhouse server on the VM to MATLAB in my local machine on windows OS, so that I can process the data locally.
I tried to explore the database tool box, but since I am new to this, I haven’t been able to connect to the database on the VM.
I would appreciate pointers from the experts.
Thanks in advance. database, clickhouse MATLAB Answers — New Questions
Nonorthogonal eigenvectors for general eigenvalue problem with eig() and eigs()
I am working with a finite element model and want to decompose my system using the eigenvectors of the system. The eigenvalue problem is of the form: K*V = M*V*D, where V is the eigenvector matrix and D is the eigenvalue matrix. Both M and K are block diagonal symmetric matrices. For the generalized eigenvalue problem it should be the case that V’*M*V = a matrix whose only nonzero terms are along the diagonal, but I am getting nonzero terms on either side of these. Using the code included below for something like N =5, I get (after rounding to nearest 3rd decimal to remove near zero terms)
abs( Orthgonal_Check_eig) = [ 78.8050 0 0 0 0
0 43.4540 0 0 0
0 0 0 34.9310 0
0 0 34.9310 0 0
0 0 0 0 29.6430]
Where I am taking the absolute value because this case has complex eigenvectors (though I believe I’ve seen it with real eigenvector matrices as well). If I rerun the code it does not always happen, but I am trying to understand why this can occur for both eig() and eigs() so that I can determine if it is the conditioning of the matrices or if it is inherent to the approximations inside of eig() and eigs(). Is there a better one of the two to use to avoid this issue?
N = 5;
M = zeros(N,N);
K = zeros(N,N);
for ii = 1:N
% Diagonal Terms
M(ii,ii) = rand*50;
K(ii,ii) = rand*500;
if ii ~=N
% Off Diagonal Terms
off_diagonal = rand*50;
M(ii,ii+1) = off_diagonal;
K(ii,ii+1) = off_diagonal*10;
M(ii+1,ii) = off_diagonal;
K(ii+1,ii) = off_diagonal*10;
end
end
M= round(M);
K= round(K);
[Veig,~] = eig(K,M);
[Veigs,~] = eigs(K,M,3);
Orthgonal_Check_eig = Veig’*M*Veig;
Orthgonal_Check_eigs =Veigs’*M*Veigs;I am working with a finite element model and want to decompose my system using the eigenvectors of the system. The eigenvalue problem is of the form: K*V = M*V*D, where V is the eigenvector matrix and D is the eigenvalue matrix. Both M and K are block diagonal symmetric matrices. For the generalized eigenvalue problem it should be the case that V’*M*V = a matrix whose only nonzero terms are along the diagonal, but I am getting nonzero terms on either side of these. Using the code included below for something like N =5, I get (after rounding to nearest 3rd decimal to remove near zero terms)
abs( Orthgonal_Check_eig) = [ 78.8050 0 0 0 0
0 43.4540 0 0 0
0 0 0 34.9310 0
0 0 34.9310 0 0
0 0 0 0 29.6430]
Where I am taking the absolute value because this case has complex eigenvectors (though I believe I’ve seen it with real eigenvector matrices as well). If I rerun the code it does not always happen, but I am trying to understand why this can occur for both eig() and eigs() so that I can determine if it is the conditioning of the matrices or if it is inherent to the approximations inside of eig() and eigs(). Is there a better one of the two to use to avoid this issue?
N = 5;
M = zeros(N,N);
K = zeros(N,N);
for ii = 1:N
% Diagonal Terms
M(ii,ii) = rand*50;
K(ii,ii) = rand*500;
if ii ~=N
% Off Diagonal Terms
off_diagonal = rand*50;
M(ii,ii+1) = off_diagonal;
K(ii,ii+1) = off_diagonal*10;
M(ii+1,ii) = off_diagonal;
K(ii+1,ii) = off_diagonal*10;
end
end
M= round(M);
K= round(K);
[Veig,~] = eig(K,M);
[Veigs,~] = eigs(K,M,3);
Orthgonal_Check_eig = Veig’*M*Veig;
Orthgonal_Check_eigs =Veigs’*M*Veigs; I am working with a finite element model and want to decompose my system using the eigenvectors of the system. The eigenvalue problem is of the form: K*V = M*V*D, where V is the eigenvector matrix and D is the eigenvalue matrix. Both M and K are block diagonal symmetric matrices. For the generalized eigenvalue problem it should be the case that V’*M*V = a matrix whose only nonzero terms are along the diagonal, but I am getting nonzero terms on either side of these. Using the code included below for something like N =5, I get (after rounding to nearest 3rd decimal to remove near zero terms)
abs( Orthgonal_Check_eig) = [ 78.8050 0 0 0 0
0 43.4540 0 0 0
0 0 0 34.9310 0
0 0 34.9310 0 0
0 0 0 0 29.6430]
Where I am taking the absolute value because this case has complex eigenvectors (though I believe I’ve seen it with real eigenvector matrices as well). If I rerun the code it does not always happen, but I am trying to understand why this can occur for both eig() and eigs() so that I can determine if it is the conditioning of the matrices or if it is inherent to the approximations inside of eig() and eigs(). Is there a better one of the two to use to avoid this issue?
N = 5;
M = zeros(N,N);
K = zeros(N,N);
for ii = 1:N
% Diagonal Terms
M(ii,ii) = rand*50;
K(ii,ii) = rand*500;
if ii ~=N
% Off Diagonal Terms
off_diagonal = rand*50;
M(ii,ii+1) = off_diagonal;
K(ii,ii+1) = off_diagonal*10;
M(ii+1,ii) = off_diagonal;
K(ii+1,ii) = off_diagonal*10;
end
end
M= round(M);
K= round(K);
[Veig,~] = eig(K,M);
[Veigs,~] = eigs(K,M,3);
Orthgonal_Check_eig = Veig’*M*Veig;
Orthgonal_Check_eigs =Veigs’*M*Veigs; eigenvalue problem, eig, eigs, orthogonality MATLAB Answers — New Questions
Choosing Between Graph API Requests or Graph SDK Cmdlets
Deciding whether to use Microsoft Graph PowerShell SDK cmdlets or Graph API requests is sometimes not easy. Some say that it’s best to use Graph API requests everywhere and avoid the complication of possibly buggy Graph PowerShell SDK cmdlets. My approach is different. I start with Graph PowerShell SDK cmdlets and only resort to Graph API requests when absolutely necessary. It works for me!
https://office365itpros.com/2024/06/05/microsoft-graph-powershell-sdk-api/
Deciding whether to use Microsoft Graph PowerShell SDK cmdlets or Graph API requests is sometimes not easy. Some say that it’s best to use Graph API requests everywhere and avoid the complication of possibly buggy Graph PowerShell SDK cmdlets. My approach is different. I start with Graph PowerShell SDK cmdlets and only resort to Graph API requests when absolutely necessary. It works for me!
https://office365itpros.com/2024/06/05/microsoft-graph-powershell-sdk-api/ Read More
How to Remove Windows 10 from Windows10/11 dual boot?
I’ve been running Windows 10 and Windows 11 as a dual-boot setup on my computer, but now I want to remove the Windows 10 installation altogether. However, I’m having trouble figuring out how to do this. Can anyone help me with this? I’ve tried using the built-in Disk Management tool to delete the Windows 10 partition, but it seems like that’s not a viable option. I’ve also tried using third-party software, but I’m not sure if those tools will actually remove all the files and registry entries associated with the Windows 10 installation.
Can anyone help me with this? Thanks.
I’ve been running Windows 10 and Windows 11 as a dual-boot setup on my computer, but now I want to remove the Windows 10 installation altogether. However, I’m having trouble figuring out how to do this. Can anyone help me with this? I’ve tried using the built-in Disk Management tool to delete the Windows 10 partition, but it seems like that’s not a viable option. I’ve also tried using third-party software, but I’m not sure if those tools will actually remove all the files and registry entries associated with the Windows 10 installation.Can anyone help me with this? Thanks. Read More
Risk when pressing Ctrl+z in File Explorer
Hi, I have been facing a critical issue with my files when using Ctrl+z by mistake. I know that when clicking Ctrl+z in File Explorer, it Undo the recent action on the file. However, this will create an issue if it was done unintentionaly.
Scenario:
1- create a new file
2- open the file and type anything in it.
3- save the file and exit
4- press Ctrl+z : this will delete the file immidiately
The only way to recover the file is to press Ctrl+y, however, the content will be gone as if it was a new file.
I beleive that this would affect users data and they won’t be able to recover their recent work.
Hi, I have been facing a critical issue with my files when using Ctrl+z by mistake. I know that when clicking Ctrl+z in File Explorer, it Undo the recent action on the file. However, this will create an issue if it was done unintentionaly. Scenario:1- create a new file2- open the file and type anything in it.3- save the file and exit4- press Ctrl+z : this will delete the file immidiately The only way to recover the file is to press Ctrl+y, however, the content will be gone as if it was a new file. I beleive that this would affect users data and they won’t be able to recover their recent work. Read More
How to install Windows Server 2016 Core as a VM that has the GUI?
I have an installation of an ISO for Windows Server 2016 Core that I would like to run, but only within a VM but it came without the GUI, and I wanted to install the GUI version during setup but I wasn’t able to. And since I’m running this installation only for the VM, I’m not sure how to set it up in the VM with the GUI.
Upon opening the installation, I am only given the ability to type into command prompt, and I cannot install other modules from there using Get-WindowsFeature
I have an installation of an ISO for Windows Server 2016 Core that I would like to run, but only within a VM but it came without the GUI, and I wanted to install the GUI version during setup but I wasn’t able to. And since I’m running this installation only for the VM, I’m not sure how to set it up in the VM with the GUI. Upon opening the installation, I am only given the ability to type into command prompt, and I cannot install other modules from there using Get-WindowsFeature Read More
Macro to find missing data points from list
Hi All,
I have a spreadsheet which records prices for items each per day (10am to 5pm). The spreadsheet records prices for many funds and timeslots, so when reviewing to see if any were missed for a period can be time consuming and hard to identify.
To help with this I was wondering if I can use a macro to find missing prices, given we have an expected price for 10:00,11:00,12:00,13:00,14:00,15:00,16:00,17:00 each day it has any price. So if a fund has no data/row of information at all for say 17:00, but prices for all other times on the same date it has been missed.
I have put together an example with two funds, being ABC and CAT. The example has prices for both funds at each time point on the first date, however then the 17:00 data is missing for CAT on the second. I would manually find this and put the information on the missing prices tab.
Since the spreadsheet can cover years of data, i often review a month or quarter at a time. So I am hoping to only include missed prices which are between the start and end of period dates given on the analysis tab.
Greatly appreciate any tips or insight on how to do this.
Many thanks
Hi All, I have a spreadsheet which records prices for items each per day (10am to 5pm). The spreadsheet records prices for many funds and timeslots, so when reviewing to see if any were missed for a period can be time consuming and hard to identify. To help with this I was wondering if I can use a macro to find missing prices, given we have an expected price for 10:00,11:00,12:00,13:00,14:00,15:00,16:00,17:00 each day it has any price. So if a fund has no data/row of information at all for say 17:00, but prices for all other times on the same date it has been missed. I have put together an example with two funds, being ABC and CAT. The example has prices for both funds at each time point on the first date, however then the 17:00 data is missing for CAT on the second. I would manually find this and put the information on the missing prices tab. Since the spreadsheet can cover years of data, i often review a month or quarter at a time. So I am hoping to only include missed prices which are between the start and end of period dates given on the analysis tab. Greatly appreciate any tips or insight on how to do this. Many thanks Read More
