Category: Microsoft
Category Archives: Microsoft
Data Validation – editing in any of the input boxes – why does it not behave
Can someone help me understand why when I use normal editing gestures in any of the input boxes within the Data Validation popup, that it behaves so badly. For example, I have the following formula: =AND(LEN(A1)=8, ISNUMBER(VALUE(MID(A1,1,7))), RIGHT(A1,1)=”B”). I go to the Formula box and change the B to a Q. The B remains there despite typing over it. However, when I close it and re-open, the Q is there. Or if I try to use an arrow key to move within the text, it starts adding cell references.
I just don’t understand why it behaves so differently from any other input box.
Can someone help me understand why when I use normal editing gestures in any of the input boxes within the Data Validation popup, that it behaves so badly. For example, I have the following formula: =AND(LEN(A1)=8, ISNUMBER(VALUE(MID(A1,1,7))), RIGHT(A1,1)=”B”). I go to the Formula box and change the B to a Q. The B remains there despite typing over it. However, when I close it and re-open, the Q is there. Or if I try to use an arrow key to move within the text, it starts adding cell references. I just don’t understand why it behaves so differently from any other input box. Read More
Sumproduct with three criteria, one of which is an or statement with two dates
Hi everyone,
This is a complex endeavor for me. I am attempting to use sumproduct with three criteria on another tab.
Criteria 1: If column C indicates “YES”
Criteria 2: If column F indicates “Standalone Service”
Criteria 3: If either columns AA or AB have August in the date
Here’s the formula I’m trying to work with
=SUMPRODUCT((Master_Calendar!$F$3:$F$503=”Standalone Service”)*(Master_Calendar!$C$3:$C503=”YES”)*((MONTH(Master_Calendar!$AA$3:$AA$503)=8)+(MONTH(Master_Calendar!$AB$3:$AB$503)=8)))
I don’t know what I’m doing wrong
Thanks
Hi everyone, This is a complex endeavor for me. I am attempting to use sumproduct with three criteria on another tab.Criteria 1: If column C indicates “YES”Criteria 2: If column F indicates “Standalone Service”Criteria 3: If either columns AA or AB have August in the dateHere’s the formula I’m trying to work with=SUMPRODUCT((Master_Calendar!$F$3:$F$503=”Standalone Service”)*(Master_Calendar!$C$3:$C503=”YES”)*((MONTH(Master_Calendar!$AA$3:$AA$503)=8)+(MONTH(Master_Calendar!$AB$3:$AB$503)=8)))I don’t know what I’m doing wrong Thanks Read More
outlook calendar
Hello everyone,
I have some calendars in Outlook that I no longer need. Is there a way to remove them, please? I want to keep the email inboxes, but I have two unnecessary calendars. I use iCloud for my calendars.
Thank you,
Si
Hello everyone,I have some calendars in Outlook that I no longer need. Is there a way to remove them, please? I want to keep the email inboxes, but I have two unnecessary calendars. I use iCloud for my calendars.Thank you,Si Read More
MDI – licensing for multiple isolated AD forests
Hi,
We have the following setup:
400 humansstandard AD domain in a single forest (sync’ed via AADConnect to the Entra tenant)
500 AD accounts (user accounts + service accounts),
450 synced to Entra ID (some on-prem service accounts are not synced),
400 accounts with M365 E5 licenses (RBAC accounts do not get any licenses),
MDI sensors installed3 separate dev/UAT/prod AD domains (each in a separate forest, no trusts, isolated): 20 accounts, 300 accounts, 500 accounts (prod AD has many accounts for external clients/consultants/etc).
accounts not synchronized to anywhere
we want to start using MS Defender for Identity for these domains to sync to the existing MDI workspace.
1. Are these 400 M365 E5 licenses enough for the whole environment (1+3 AD domains) ?
2. If not, what is the final count of licenses needed?
3. how many licenses need to be bought and of which SKU?
Hi, We have the following setup:400 humansstandard AD domain in a single forest (sync’ed via AADConnect to the Entra tenant)500 AD accounts (user accounts + service accounts),450 synced to Entra ID (some on-prem service accounts are not synced),400 accounts with M365 E5 licenses (RBAC accounts do not get any licenses),MDI sensors installed3 separate dev/UAT/prod AD domains (each in a separate forest, no trusts, isolated): 20 accounts, 300 accounts, 500 accounts (prod AD has many accounts for external clients/consultants/etc).accounts not synchronized to anywherewe want to start using MS Defender for Identity for these domains to sync to the existing MDI workspace.1. Are these 400 M365 E5 licenses enough for the whole environment (1+3 AD domains) ?2. If not, what is the final count of licenses needed?3. how many licenses need to be bought and of which SKU? Read More
IFS displaying spill range and not just one result?
Hi,
I am using the AND function with two criteria inside (e.g if equal to 5 and 10) for a range of cells (vertically, for example A1:A10) but only 1 result appears. How do I spill all results for all 10 cells and not just have the first true result outputted?
For example output should be TRUE, FALSE, FALSE, ETC with TRUE and FALSE being their respective values.
Right now output is only TRUE.
Thanks!
Hi, I am using the AND function with two criteria inside (e.g if equal to 5 and 10) for a range of cells (vertically, for example A1:A10) but only 1 result appears. How do I spill all results for all 10 cells and not just have the first true result outputted? For example output should be TRUE, FALSE, FALSE, ETC with TRUE and FALSE being their respective values. Right now output is only TRUE. Thanks! Read More
Name Reservation on Azure Container Registry
What’s changing?
Starting August 1st, Azure Container Registry (ACR) will update its behavior regarding the deletion and re-creation of registries. ACR will prevent the reuse of a subdomain name, e.g. abc123.azurecr.io, for a period after the resource is deleted. This updated behavior enhances security and prevents subdomain takeovers by automatically reserving registry names during the creation of the ACR resource, without requiring any additional action or configuration from customers.
Once a resource name is reserved, it remains reserved from the moment of creation and throughout an extended period following the deletion of the resource (referred to as a cooldown period). During this cooldown period, subscriptions not associated with the original Azure AD tenant that created the resource will be unable to use the same name for a new registry. After the cooldown period concludes, the name reservation is lifted, allowing any subscription to create a registry with the previously reserved name.
Customer impact
Most customers will not be impacted by this update. If you delete a registry, you can create a new one with the same name within the cooldown period, provided the subscription belongs to the same Azure Active Directory (AAD) tenant. This ensures a seamless experience for customers who routinely create –> delete –> recreate resources with the same name within the same AAD tenant for testing and production workflows.
The name reservation feature guarantees that customers have exclusive rights to a resource name between its deletion and subsequent recreation, preventing other customers from claiming the same name during this interval.
Learn more
To learn more about Azure Container Registry: Azure Container Registry documentation
To learn more about the different ways to avoid dangling domains and subdomains takeover: Prevent dangling DNS entries and avoid subdomain takeover
To learn more about the one-to-many relationship between an Azure AD tenant and an Azure subscription: Azure subscriptions and Azure AD Tenants
Microsoft Tech Community – Latest Blogs –Read More
Migration batches with office 365
Migration batches
I am getting this error even though I tested connection via
telnet imap.integra.net 143 and I get the command window
I also tested the one of the accounts on outlook and it worked just fine.
But with the Migration batches in Exchange admin center after it synced with errors
Here is the error for all.
Error: ImapAuthenticationException: The username or password for this account is incorrect, or IMAP access is disabled. –> Imap server reported an error during LOGIN indicating that authentication failed: ‘Authentication failed.’.
People I need real help!
Migration batchesI am getting this error even though I tested connection viatelnet imap.integra.net 143 and I get the command windowI also tested the one of the accounts on outlook and it worked just fine.But with the Migration batches in Exchange admin center after it synced with errorsHere is the error for all.Error: ImapAuthenticationException: The username or password for this account is incorrect, or IMAP access is disabled. –> Imap server reported an error during LOGIN indicating that authentication failed: ‘Authentication failed.’. People I need real help! Read More
August V1 Title Plan out now!
MPN Partner Portal Learning Resources page resources page for Training Services Partners
As always, don’t forget to check out the Courseware News & Overview tab!
Thank you
Hello, Partners —
The August Monthly Title Plan V1 is attached to this forum.
This Monthly Title Plan is also shared in:
MPN Partner Portal Learning Resources page resources page for Training Services Partners
MCT Lounge Tech community Lounge for MCTs
We have added four more courses that are coming soon, to the supporting PDF, to provide you with information per all new courses coming soon.
As always, don’t forget to check out the Courseware News & Overview tab!
Thank you
Read More
Need to help escalate concern for focus OD-SPO
For several weeks, both my OneDrive and SharePoint storage reported incorrect values. In mid-to-late June, I deleted both Primary and Secondary recycle bins but the files came magically back twice.
When I finally managed to have someone look at the concern through Quick Assist, I have also deleted the files and they never went away. The MS Support Engineer said they’re doing “advanced diagnostics”. What I remember a day before I had an issue with OneDrive and SharePoint is that Azure or Microsoft 365 had issues. When I transferred files to SharePoint from OneDrive, the storage utilization never changed.
If I had to provide feedback about MS Support, they stood me up for a whole week at one point and, despite stating email in the communication preference because my vocal cords are damaged, they keep calling then email just to tell me they can’t reach me. New agents assigned to the ticket almost never read ticket details. Just 2 people.
Any help from Microsoft to look into this would be appreciated as I have emailed escalation personnel from the BPO but nobody replied since earlier this morning. It’s close to 4PM Eastern now.
FYI Tracking ID 2406220030001049. Ticket has been open since mid-June. FYI @Russell Read
Regards,
m365bizsubs001
MS365 Business Standard Subscriber
For several weeks, both my OneDrive and SharePoint storage reported incorrect values. In mid-to-late June, I deleted both Primary and Secondary recycle bins but the files came magically back twice.When I finally managed to have someone look at the concern through Quick Assist, I have also deleted the files and they never went away. The MS Support Engineer said they’re doing “advanced diagnostics”. What I remember a day before I had an issue with OneDrive and SharePoint is that Azure or Microsoft 365 had issues. When I transferred files to SharePoint from OneDrive, the storage utilization never changed.If I had to provide feedback about MS Support, they stood me up for a whole week at one point and, despite stating email in the communication preference because my vocal cords are damaged, they keep calling then email just to tell me they can’t reach me. New agents assigned to the ticket almost never read ticket details. Just 2 people.Any help from Microsoft to look into this would be appreciated as I have emailed escalation personnel from the BPO but nobody replied since earlier this morning. It’s close to 4PM Eastern now.FYI Tracking ID 2406220030001049. Ticket has been open since mid-June. FYI @Russell Read Regards,m365bizsubs001MS365 Business Standard Subscriber Read More
Inventory Qty Update Formula
I have a workbook with 3 tabs – Inventory Sheet, Mat Log, Cost Tracking.
The cost tracking sheet had the original inventory amount that we need to start with (Column J).
On the Mat Log sheet, when an item is removed or added to inventory, the person will enter the date in column A, the Mat. Code in Column B – and that will populate the name in Column C. Column F is the amount they are taking out (negative number) or putting into inventory (positive number). Here is where the “I need help” comes in. On the inventory sheet, I need the quantity associated the product code to always be updated based on what happens on the Mat Log sheet.
I have a workbook with 3 tabs – Inventory Sheet, Mat Log, Cost Tracking. The cost tracking sheet had the original inventory amount that we need to start with (Column J).On the Mat Log sheet, when an item is removed or added to inventory, the person will enter the date in column A, the Mat. Code in Column B – and that will populate the name in Column C. Column F is the amount they are taking out (negative number) or putting into inventory (positive number). Here is where the “I need help” comes in. On the inventory sheet, I need the quantity associated the product code to always be updated based on what happens on the Mat Log sheet. Read More
Color Code Emails: Use Conditional Formatting or Assign Categories?
Are you unsure which feature to use for color-coding your emails? Should you use conditional formatting or assign categories?
In this blog post, Color Code Emails: Conditional formatting or Categories » TRACCreations4E, I discuss the differences between the two.
Which do you prefer?
Are you unsure which feature to use for color-coding your emails? Should you use conditional formatting or assign categories?
In this blog post, Color Code Emails: Conditional formatting or Categories » TRACCreations4E, I discuss the differences between the two.
Which do you prefer?
Upcoming Task on 2016 (active)
Hi All,
How do I display more than 50 task, I went into Advanced options ad it say I only have 50 lines but it does say something about filters. I need to display like 150 lines for production scheduling.
Thank you,
Tony
Hi All,How do I display more than 50 task, I went into Advanced options ad it say I only have 50 lines but it does say something about filters. I need to display like 150 lines for production scheduling. Thank you,Tony Read More
eye tracked keyboard
for a few days I have been having trouble with the eye tracking keyboard: I start writing a word and when I go to click on the suggested word, the letters I had written plus the complete word appear on the screen.
For example, I write eyed (eyedropper) and when I press the suggested word on the keyboard, eyedeyedropper is written.
The strange thing is on the desktop WhatsApp client, the writing is correct.
What could it be?
Thanks in advance.
for a few days I have been having trouble with the eye tracking keyboard: I start writing a word and when I go to click on the suggested word, the letters I had written plus the complete word appear on the screen.For example, I write eyed (eyedropper) and when I press the suggested word on the keyboard, eyedeyedropper is written.The strange thing is on the desktop WhatsApp client, the writing is correct.What could it be?Thanks in advance. Read More
I cannot remove Organization from Person Account on MS Teams
Hello, MS Teams members,
I want to remove an old organization on MS Teams from my personal account, but I cannot.
Hello, MS Teams members,I want to remove an old organization on MS Teams from my personal account, but I cannot. Read More
Dynamic array and spilled array – FILTER function behavior
I am attempting to create a dynamic dependent data validation list (using instructions found on the My Online Training YouTube video). A link to the file is found here.
On the Standards Categories TAB, there is a Table (StdCategories) with two columns for Category and Subcategory. The primary data validation list is for the Category values, and the dependent data validation is for the Subcategory values.
Starting in Cell E2, the Categories are populated horizontally using the UNIQUE and TRANSPOSE functions. Starting in Cell E2, the FILTER and SORT functions are used to populate the Subcategory values for each Category. There is some sort of error occurring in every other Column (starting in column F) where the work “None” is used as the error return value. For some reason, the formula is not matching the value in Row 2 with the associated values in the StdCategories table. I’ve verified this using the Evaluate Formula feature. I’ve tried searching for any help on this issue, but I either can’t find it, or I’m not searching with the right terminology.
Is anyone familiar with this odd behavior, or have any suggestions on diagnosing the error?
I am attempting to create a dynamic dependent data validation list (using instructions found on the My Online Training YouTube video). A link to the file is found here. On the Standards Categories TAB, there is a Table (StdCategories) with two columns for Category and Subcategory. The primary data validation list is for the Category values, and the dependent data validation is for the Subcategory values. Starting in Cell E2, the Categories are populated horizontally using the UNIQUE and TRANSPOSE functions. Starting in Cell E2, the FILTER and SORT functions are used to populate the Subcategory values for each Category. There is some sort of error occurring in every other Column (starting in column F) where the work “None” is used as the error return value. For some reason, the formula is not matching the value in Row 2 with the associated values in the StdCategories table. I’ve verified this using the Evaluate Formula feature. I’ve tried searching for any help on this issue, but I either can’t find it, or I’m not searching with the right terminology. Is anyone familiar with this odd behavior, or have any suggestions on diagnosing the error? Read More
Unable to change expired password
I am using Server Next Preview Build 26257. It is a domain controller. I only have the one AD account which I created to do the evaluation. The account password expired today. When I attempt to change it at login, I enter the new password twice as required and hit Enter, but it sends me back and says “The password for this account has expired” with an OK button.
If I try again I get the same result. If I purposely type a mismatch for the new PW it does acknowledge that.
Has anyone else seen this? I can’t think of a workaround.
I am using Server Next Preview Build 26257. It is a domain controller. I only have the one AD account which I created to do the evaluation. The account password expired today. When I attempt to change it at login, I enter the new password twice as required and hit Enter, but it sends me back and says “The password for this account has expired” with an OK button. If I try again I get the same result. If I purposely type a mismatch for the new PW it does acknowledge that. Has anyone else seen this? I can’t think of a workaround. Read More
Explanation of the Microsoft AI Cloud Partner Agreement & Marketplace Publisher Agreement.
We have to clarify two clauses from the agreement:
Microsoft AI Cloud Partner Program Agreement: Section 8 Limitations of Liability (b) it says Privacy and Data Protection, Confidentiality and Publicity and indemnification are carved out of any limitations in paragraph 8.(a).
Can you please confirm our understanding that Microsoft is asking the Company to have the risk of unlimited liability related to these carve-outs ?Microsoft Publisher Agreement: Section 9 (b) has indemnification claims subject to indirect damages and Section 9 (c) have carve-outs for confidentiality, privacy or data protection which we interpret as having the risk of unlimited liability.
Can you please confirm our understanding that Microsoft is asking the Company to have the risk of unlimited liability related to these carve-outs ?
Helllo there, We have to clarify two clauses from the agreement:Microsoft AI Cloud Partner Program Agreement: Section 8 Limitations of Liability (b) it says Privacy and Data Protection, Confidentiality and Publicity and indemnification are carved out of any limitations in paragraph 8.(a). Can you please confirm our understanding that Microsoft is asking the Company to have the risk of unlimited liability related to these carve-outs ?Microsoft Publisher Agreement: Section 9 (b) has indemnification claims subject to indirect damages and Section 9 (c) have carve-outs for confidentiality, privacy or data protection which we interpret as having the risk of unlimited liability. Can you please confirm our understanding that Microsoft is asking the Company to have the risk of unlimited liability related to these carve-outs ? Read More
How to request 10 free M365 licences for NonProfit with a Godaddy M365 account
Hi,
our organization is eligible to M365 offer for non profit, but since we are client to Godaddy M365 , we are automatically redirect to ther logon page when we try to request licences on Microsoft interface.
We have contact Godaddy hoping they will remove those restrictions, in order for us to receive M365 licences, but they told us that if we want to move to microsoft they wil simply delete our instance so allow us to go for Microsoft.
Have someone face that issue? If there are advices, your are welcome.
Sorry for my english
Hi, our organization is eligible to M365 offer for non profit, but since we are client to Godaddy M365 , we are automatically redirect to ther logon page when we try to request licences on Microsoft interface. We have contact Godaddy hoping they will remove those restrictions, in order for us to receive M365 licences, but they told us that if we want to move to microsoft they wil simply delete our instance so allow us to go for Microsoft. Have someone face that issue? If there are advices, your are welcome. Sorry for my english Read More
Can’t Download Files Completely from One Drive
Hi, I tried to download dataset files online for model training, but there is a file where I keep on encountering errors, where the files had 8000+ file inside, but it can’t download completely. The file is around 22.6GB but whenever I tried to download, it is able to download. But even it shows download complete, it is actually not complete. Instead, it shows a txt file showing the error, as shown below. Does anyone knows ways to solve this problem?
Anyone knows how to solve this error?
Hi, I tried to download dataset files online for model training, but there is a file where I keep on encountering errors, where the files had 8000+ file inside, but it can’t download completely. The file is around 22.6GB but whenever I tried to download, it is able to download. But even it shows download complete, it is actually not complete. Instead, it shows a txt file showing the error, as shown below. Does anyone knows ways to solve this problem?Anyone knows how to solve this error? Read More
