Category: Microsoft
Category Archives: Microsoft
How to get the Account code from the formula refer the amount column
Hi,
I have 2 sheets in workbook. 1st sheet is Summary sheet and other one is details sheet. I have attached the sample sheet with required result in highlighted cells,
1st sheet having the sample balance sheet where it summarizes the accounts amounts from the details sheet. i want the account number in 1st sheet against group of balance sheet accounts as per the amount total.
Thank you in advance
Tejas Shah
Hi, I have 2 sheets in workbook. 1st sheet is Summary sheet and other one is details sheet. I have attached the sample sheet with required result in highlighted cells, 1st sheet having the sample balance sheet where it summarizes the accounts amounts from the details sheet. i want the account number in 1st sheet against group of balance sheet accounts as per the amount total. Thank you in advance Tejas Shah Read More
Sharepoint: Automatically sort by “last added”
I’m german so sorry for my english
is it possible that Sharepoint automatically sorts by “last added” in a list?
we always have to manually click “sort by newest”
see screenshot.
thx
I’m german so sorry for my englishis it possible that Sharepoint automatically sorts by “last added” in a list?we always have to manually click “sort by newest”see screenshot.thx Read More
MDE notifications
Hello,
Can we configure an email alert in MDE in case there is signature update failure? Please guide.
Thanks,
K
Hello, Can we configure an email alert in MDE in case there is signature update failure? Please guide. Thanks,K Read More
Temu Coupon $100 Off Code (afh97457) $100 Off For New Users
Get the latest Temu Coupon code $100 off (afh97457) and use it while shopping on Temu to get $100 off on your order. Apply this Temu $100 off coupon to get discount on your shopping.
temu $100 off coupon code: afh97457
Temu coupon code $100 off: afh97457
Get the latest Temu Coupon code $100 off (afh97457) and use it while shopping on Temu to get $100 off on your order. Apply this Temu $100 off coupon to get discount on your shopping.temu $100 off coupon code: afh97457Temu coupon code $100 off: afh97457 Read More
How to change branding for Defender alerts?
Hey all,
Would someone be able to share the steps for changing the branding for these alerts?
Rather than “Your administrator has blocked this action,” Defender is currently alerting that “ABC has blocked this action.”; ( ABC is a company )
I’ve attached the snippet for the same.
Thanks,
Hey all, Would someone be able to share the steps for changing the branding for these alerts? Rather than “Your administrator has blocked this action,” Defender is currently alerting that “ABC has blocked this action.”; ( ABC is a company ) I’ve attached the snippet for the same. Thanks, Read More
Out of Office inbox rule in Outlook
Hi
We have Exchange 2016 environment in our organization.
I wonder if it is possible to distinguish whether a given rule in Outlook was created in Inbox rules/alerts or in Out of Office?
Is it possible to delete only the rules connected with Out of Office?
Thank you in advance for your answers.
Regards
Pit
HiWe have Exchange 2016 environment in our organization.I wonder if it is possible to distinguish whether a given rule in Outlook was created in Inbox rules/alerts or in Out of Office?Is it possible to delete only the rules connected with Out of Office?Thank you in advance for your answers. RegardsPit Read More
How to transfer all photos from OneDrive into a hard drive?
Need to transfer all photos from OneDrive into a hard drive. I’m almost running out of space on OneDrive, and I want to find a way to quickly download all of them somewhere, before deleting them from the cloud.
Thing is, it seems like I have to scroll and drag click all of the photos; 3 years worth of them, which is really tedious to do. I was wondering if there was an easier way to just download all of them somewhere?
Note that this isn’t about the OneDrive files, it’s the OneDrive photos section, which I don’t think you could sync to your computer.
I’m using a MacBook Air M1 2021, if it helps. Thanks!
Need to transfer all photos from OneDrive into a hard drive. I’m almost running out of space on OneDrive, and I want to find a way to quickly download all of them somewhere, before deleting them from the cloud. Thing is, it seems like I have to scroll and drag click all of the photos; 3 years worth of them, which is really tedious to do. I was wondering if there was an easier way to just download all of them somewhere? Note that this isn’t about the OneDrive files, it’s the OneDrive photos section, which I don’t think you could sync to your computer. I’m using a MacBook Air M1 2021, if it helps. Thanks! Read More
Exel formula needed
Hi there,
I am trying to show a specific fixed annual cost in a spreadsheet each year for a specified period. The cost is shown in a specific cell (D9) but only applies annually for a certain number of years (this figure is stated in cell E9).
I have established a row of policy years number 1 to 10 from E19 to N19 but only want the fee to show in the relevant number of cells. For example if the cost is £1,500 in cell D9 but the number of years it is applicable for in 7 (as stated in E9) I would only want it showing in cells E19 to L19 (i.e. years 1 to 7). Does anyone know how to create this formula?
Hi there, I am trying to show a specific fixed annual cost in a spreadsheet each year for a specified period. The cost is shown in a specific cell (D9) but only applies annually for a certain number of years (this figure is stated in cell E9). I have established a row of policy years number 1 to 10 from E19 to N19 but only want the fee to show in the relevant number of cells. For example if the cost is £1,500 in cell D9 but the number of years it is applicable for in 7 (as stated in E9) I would only want it showing in cells E19 to L19 (i.e. years 1 to 7). Does anyone know how to create this formula? Read More
Managed Home Screen FIDO2 authentication
Hello!
I was just wondering if it is possible to use NFC Smartcard to make it easier to log in to Manged Home Screen?
I have a Thales FIDO2 certified smartcard next to me which is registered on my account but i only see password field and not
Hello!I was just wondering if it is possible to use NFC Smartcard to make it easier to log in to Manged Home Screen?I have a Thales FIDO2 certified smartcard next to me which is registered on my account but i only see password field and not Read More
Setting the default language
Hi, I am starting my first .Net Core web application. I cannot find the way to setup the default language for this application, to display the validation messages in my language (italian).
With .net framework this is very easy to do.
Can someone help me?
Thanks.
Hi, I am starting my first .Net Core web application. I cannot find the way to setup the default language for this application, to display the validation messages in my language (italian).With .net framework this is very easy to do.Can someone help me?Thanks. Read More
Excel sum functions
Hello everyone,
I need to make a counting table using datas from an other table like shown in the picture under. I’ve tried NB SI ENS formulas with for exemple : =NB si ens ($D$6:$D$29;H5=D7; $E$6:$E$29;E7=G6) but it doesn’t work. It’s in reality a big table with > 250 columns and > 20 lines to fill.
Would you have an idea on how to make it with a single formula please ?
Edit : NB SI is the french equivalent of COUNT IF
Thank you very much,
Arnaud
Hello everyone, I need to make a counting table using datas from an other table like shown in the picture under. I’ve tried NB SI ENS formulas with for exemple : =NB si ens ($D$6:$D$29;H5=D7; $E$6:$E$29;E7=G6) but it doesn’t work. It’s in reality a big table with > 250 columns and > 20 lines to fill. Would you have an idea on how to make it with a single formula please ? Edit : NB SI is the french equivalent of COUNT IFThank you very much, Arnaud Read More
How can I resolve QuickBooks Error 6144 82 efficiently?
Encountering QuickBooks error 6144 82 while accessing company files. What does this error signify and how can I fix it to resume normal operations?
Encountering QuickBooks error 6144 82 while accessing company files. What does this error signify and how can I fix it to resume normal operations? Read More
Better Alternatives to Snipping Tool for Windows 11?
Hello everyone,
I’ve been using the Snipping Tool on Windows 11, but I find it quite hard to use. In addition, it lacks the editing features I need. I’m looking for recommendations for alternative screenshot tools that are user-friendly and come with robust editing capabilities. Ideally, the alternative should offer features such as:
Easy-to-use interfaceAdvanced editing tools (annotations, text, shapes, etc.)Ability to capture different types of screenshots (full screen, window, region, scrolling)
Please suggest a better better Snipping Tool for Windows 11.
Hello everyone, I’ve been using the Snipping Tool on Windows 11, but I find it quite hard to use. In addition, it lacks the editing features I need. I’m looking for recommendations for alternative screenshot tools that are user-friendly and come with robust editing capabilities. Ideally, the alternative should offer features such as:Easy-to-use interfaceAdvanced editing tools (annotations, text, shapes, etc.)Ability to capture different types of screenshots (full screen, window, region, scrolling)Please suggest a better better Snipping Tool for Windows 11. Read More
Unable to send notification to teams installed application (chat)
When I tried to call the interface, an error message appeared as follows:
Interface information:
payload:
{
“topic”: {
“source”: “entityUrl”,
“value”: “https://graph.microsoft.com/v1.0/chats/19:email address removed for privacy reasons.spaces“
},
“activityType”: “taskCreated”,
“previewText”: {
“content”: “New Task Created”
},
“recipient”: {
“@odata.type”: “microsoft.graph.aadUserNotificationRecipient”,
“userId”: “f80482f7-ad6c-487a-aa67-c84539b487e1”
},
“templateParameters”: [
{
“name”: “taskId”,
“value”: “Task 12322”
}
]
}
Error message:
{
“error”: {
“code”: “Forbidden”,
“message”: “Application with AAD App Id ‘6c67b54d-866d-4405-876a-0d99323a0e86’ is not authorized to generate notifications about ‘https://graph.microsoft.com/v1.0/chats/19:email address removed for privacy reasons.spaces‘ to the recipient. Ensure that the expected Teams app is installed in the target scope (user, team, or chat).”,
“innerError”: {
“date”: “2024-05-29T07:03:26”,
“request-id”: “5350c32f-5f62-400c-9970-6ca8b5d47c88”,
“client-request-id”: “5350c32f-5f62-400c-9970-6ca8b5d47c88”
}
}
}
manifest file as follow:
{
“$schema”: “https://developer.microsoft.com/en-us/json-schemas/teams/v1.17/MicrosoftTeams.schema.json”,
“version”: “1.0.1”,
“manifestVersion”: “1.17”,
“id”: “26d59d9a-fce9-4640-b553-e0f07971381e”,
“name”: {
“short”: “notice”,
“full”: “notice”
},
“developer”: {
“name”: “notice”,
“mpnId”: “”,
“websiteUrl”: “https://localhost/test”,
“privacyUrl”: “https://localhost/test”,
“termsOfUseUrl”: “https://localhost/test”
},
“description”: {
“short”: “notice”,
“full”: “notice”
},
“icons”: {
“outline”: “outline.png”,
“color”: “color.png”
},
“accentColor”: “#FFFFFF”,
“staticTabs”: [
{
“entityId”: “index0”,
“name”: “Personal Tab”,
“contentUrl”: “https://localhost/test”,
“websiteUrl”: “https://localhost/test”,
“scopes”: [
“personal”
]
}
],
“validDomains”: [
“localhost”
],
“webApplicationInfo”: {
“id”: “6c67b54d-866d-4405-876a-0d99323a0e86”
},
“activities”: {
“activityTypes”: [
{
“type”: “taskCreated”,
“description”: “Task Created Activity”,
“templateText”: “{actor} created task {taskId} for you”
},
{
“type”: “approvalRequired”,
“description”: “Deployment requires your approval”,
“templateText”: “{actor} created a new deployment {deploymentId}”
}
]
},
“authorization”: {
“permissions”: {
“resourceSpecific”: [
{
“name”: “TeamsActivity.Send.User”,
“type”: “Application”
},
{
“name”: “TeamsActivity.Send.Group”,
“type”: “Application”
},
{
“name”: “TeamsActivity.Send.Chat”,
“type”: “Application”
}
]
}
}
}
When I tried to call the interface, an error message appeared as follows:Interface information:https://graph.microsoft.com/v1.0/chats/19:email address removed for privacy reasons.spaces/sendActivityNotificationpayload:{“topic”: {“source”: “entityUrl”,”value”: “https://graph.microsoft.com/v1.0/chats/19:email address removed for privacy reasons.spaces”},”activityType”: “taskCreated”,”previewText”: {“content”: “New Task Created”},”recipient”: {“@odata.type”: “microsoft.graph.aadUserNotificationRecipient”,”userId”: “f80482f7-ad6c-487a-aa67-c84539b487e1″},”templateParameters”: [{“name”: “taskId”,”value”: “Task 12322”}]}Error message:{“error”: {“code”: “Forbidden”,”message”: “Application with AAD App Id ‘6c67b54d-866d-4405-876a-0d99323a0e86’ is not authorized to generate notifications about ‘https://graph.microsoft.com/v1.0/chats/19:email address removed for privacy reasons.spaces’ to the recipient. Ensure that the expected Teams app is installed in the target scope (user, team, or chat).”,”innerError”: {“date”: “2024-05-29T07:03:26″,”request-id”: “5350c32f-5f62-400c-9970-6ca8b5d47c88″,”client-request-id”: “5350c32f-5f62-400c-9970-6ca8b5d47c88”}}}manifest file as follow: {
“$schema”: “https://developer.microsoft.com/en-us/json-schemas/teams/v1.17/MicrosoftTeams.schema.json”,
“version”: “1.0.1”,
“manifestVersion”: “1.17”,
“id”: “26d59d9a-fce9-4640-b553-e0f07971381e”,
“name”: {
“short”: “notice”,
“full”: “notice”
},
“developer”: {
“name”: “notice”,
“mpnId”: “”,
“websiteUrl”: “https://localhost/test”,
“privacyUrl”: “https://localhost/test”,
“termsOfUseUrl”: “https://localhost/test”
},
“description”: {
“short”: “notice”,
“full”: “notice”
},
“icons”: {
“outline”: “outline.png”,
“color”: “color.png”
},
“accentColor”: “#FFFFFF”,
“staticTabs”: [
{
“entityId”: “index0”,
“name”: “Personal Tab”,
“contentUrl”: “https://localhost/test”,
“websiteUrl”: “https://localhost/test”,
“scopes”: [
“personal”
]
}
],
“validDomains”: [
“localhost”
],
“webApplicationInfo”: {
“id”: “6c67b54d-866d-4405-876a-0d99323a0e86”
},
“activities”: {
“activityTypes”: [
{
“type”: “taskCreated”,
“description”: “Task Created Activity”,
“templateText”: “{actor} created task {taskId} for you”
},
{
“type”: “approvalRequired”,
“description”: “Deployment requires your approval”,
“templateText”: “{actor} created a new deployment {deploymentId}”
}
]
},
“authorization”: {
“permissions”: {
“resourceSpecific”: [
{
“name”: “TeamsActivity.Send.User”,
“type”: “Application”
},
{
“name”: “TeamsActivity.Send.Group”,
“type”: “Application”
},
{
“name”: “TeamsActivity.Send.Chat”,
“type”: “Application”
}
]
}
}
} @MicrosoftTeams Read More
Best practices needed – new DC, migrate mailboxes from Exchange 2010 to exchange online
Dear community,
one of my customers is running a DC on Windows 2010 and Exchange 2010.
(Pls don’t make any comments why these old unsupported products are not migrated yet.)
My plan is to setup a new DC on Windows 2022, add all AD users on the new AD, connect it with Entra ID, purchase O365 subcriptions, assign licenses to each user, migrate the Exchange 2010 mailboxes to Exchange online. From my persepective this should work.
I just wanted to know, if this way is really best practice. If you have other recommendation please let me know. As we don’t know how “the old stuff” is configured, we better don’t want to touch or migrate it. Only the mailboxes from the old exchange 2010 should be in the cloud at the end.
Thanks for your recommendations.
Dear community, one of my customers is running a DC on Windows 2010 and Exchange 2010.(Pls don’t make any comments why these old unsupported products are not migrated yet.) My plan is to setup a new DC on Windows 2022, add all AD users on the new AD, connect it with Entra ID, purchase O365 subcriptions, assign licenses to each user, migrate the Exchange 2010 mailboxes to Exchange online. From my persepective this should work.I just wanted to know, if this way is really best practice. If you have other recommendation please let me know. As we don’t know how “the old stuff” is configured, we better don’t want to touch or migrate it. Only the mailboxes from the old exchange 2010 should be in the cloud at the end.Thanks for your recommendations. Read More
What are common solutions for resolving QuickBooks TLS errors?
I’m encountering a TLS error in QuickBooks while trying to access online features. How can I fix this issue and ensure uninterrupted access to QuickBooks services?
I’m encountering a TLS error in QuickBooks while trying to access online features. How can I fix this issue and ensure uninterrupted access to QuickBooks services? Read More
How to Fix QuickBooks Sync Manager Not Working error?
I’m experiencing issues with QuickBooks Sync Manager not working. Whenever I try to sync data, it fails. How can I troubleshoot this problem?
I’m experiencing issues with QuickBooks Sync Manager not working. Whenever I try to sync data, it fails. How can I troubleshoot this problem? Read More
Setting up multi app kiosk -Windows11
I created an assigned access configuration XML file to set up a multi-app kiosk using PowerShell. My approach works perfectly on Windows 10, but it doesn’t work on Windows 11. Is there any problem with Windows 11?
I created an assigned access configuration XML file to set up a multi-app kiosk using PowerShell. My approach works perfectly on Windows 10, but it doesn’t work on Windows 11. Is there any problem with Windows 11? Read More
What tool I can use to convert pdf to powerpoint on my windows 11 computer?
Currently, I’m working on a PowerPoint project and have some crucial content stored in a PDF file that I need to incorporate. Does anyone know an easy and reliable way to convert PDF to PowerPoint presentation in bulk on Windows 11? It could be best to preserves the formatting and quality of the original content.
Unfortunately, I’ve tried a couple of online PDF to PPT Converters, but the results were either messy or incomplete. If you have any recommendations for software that you’ve used and trust, I’d love to hear about them. Free options would be great, but I’m also open to paid solutions if they really get the job done well.
Currently, I’m working on a PowerPoint project and have some crucial content stored in a PDF file that I need to incorporate. Does anyone know an easy and reliable way to convert PDF to PowerPoint presentation in bulk on Windows 11? It could be best to preserves the formatting and quality of the original content. Unfortunately, I’ve tried a couple of online PDF to PPT Converters, but the results were either messy or incomplete. If you have any recommendations for software that you’ve used and trust, I’d love to hear about them. Free options would be great, but I’m also open to paid solutions if they really get the job done well. Read More
WIN11_ 24H2
hello,
I’m windows insider program subscriber ( release preview ) channel
but till now i didn’t get the 24H2 update ?
even according to tis link (https://blogs.windows.com/windows-insider/2024/05/22/releasing-windows-11-version-24h2-to-the-release-preview-channel/) it has been released to ( release preview ) channel.
**had troubleshooted windows update but nothing appeared
*win_info
Edition Windows 11 Enterprise
Version 23H2
Installed on 06/04/2023
OS build 22631.3668
Experience Windows Feature Experience Pack 1000.22700.1009.0
hello,I’m windows insider program subscriber ( release preview ) channelbut till now i didn’t get the 24H2 update ? even according to tis link (https://blogs.windows.com/windows-insider/2024/05/22/releasing-windows-11-version-24h2-to-the-release-preview-channel/) it has been released to ( release preview ) channel. **had troubleshooted windows update but nothing appeared *win_infoEdition Windows 11 EnterpriseVersion 23H2Installed on 06/04/2023OS build 22631.3668Experience Windows Feature Experience Pack 1000.22700.1009.0 Read More
