I am trying to set up a spreadsheet in Excel to determine a person’s age in a given year. For example, if I was born on 04/27/1956, how old would I have been in 1994, or how old would I be in 2047? Any help would be greatly appreciated,

Sag771

​I am trying to set up a spreadsheet in Excel to determine a person’s age in a given year. For example, if I was born on 04/27/1956, how old would I have been in 1994, or how old would I be in 2047? Any help would be greatly appreciated,Sag771  Read More

​

We have an issue with reviewers downloading shared files and returning them 3-4 weeks later with markup that is out of sync with the shared version. 

I see how to share for review. I can share for view only – no download. 

Is it possible to share for review and not allow downloading? 

​ We have an issue with reviewers downloading shared files and returning them 3-4 weeks later with markup that is out of sync with the shared version.  I see how to share for review. I can share for view only – no download.  Is it possible to share for review and not allow downloading?   Read More

​

The Microsoft Fabric & AI Learning Hackathon is underway and we’re excited to learn about your project ideas and questions! Join us for an interactive session where we’ll look at recent announcements from the European Microsoft Fabric Community Conference, share tips and best practices for competing in the Hackathon, provide technical and informational support, and connect you with expert resources to support ongoing development of your Hackathon project!

RSVP here!

​ 
The Microsoft Fabric & AI Learning Hackathon is underway and we’re excited to learn about your project ideas and questions! Join us for an interactive session where we’ll look at recent announcements from the European Microsoft Fabric Community Conference, share tips and best practices for competing in the Hackathon, provide technical and informational support, and connect you with expert resources to support ongoing development of your Hackathon project!
 
RSVP here!  Read More

​

Hi.  We currently update a SP list using an Excel spreadsheet that compares new stuff to what’s already in the list.  Anything new in the spreadsheet that isn’t in the list gets copied/pasted to the bottom of the list.  That still works.  But we also identify anything that needs to be removed (i.e., it’s in the SP list but not in the updated Excel sheet, and the only way to transfer that info to the SharePoint list is to copy from the Excel sheet and paste into the SP list (grid view).  Then the list can be filtered on flagged items to remove them.  That part is no longer working.  

Prior to June 2024, that process did work, albeit very slowly and poorly; could paste in only ~100 records at a time.  Then in June, something changed with SP, and the look of list changed, but so did the performance – to the better!  Still not 100% great, but way better than before.  But, sometime during the first week of September, Microsoft rolled SharePoint back, and now I don’t seem to be able to paste in anything.  At all. 

This is a major impact and setback to our processes.  Does anyone have any information on what MS did and why?  I’ve even got a ticket in with a Microsoft Support Escalation Engineer, and she said, “I have not found anything indicating why they made the change but I know they made a lot of changes to the Lists recently.”.  I appreciate any information folks may have – including a better way to update a SP list.  Thank you!

​Hi.  We currently update a SP list using an Excel spreadsheet that compares new stuff to what’s already in the list.  Anything new in the spreadsheet that isn’t in the list gets copied/pasted to the bottom of the list.  That still works.  But we also identify anything that needs to be removed (i.e., it’s in the SP list but not in the updated Excel sheet, and the only way to transfer that info to the SharePoint list is to copy from the Excel sheet and paste into the SP list (grid view).  Then the list can be filtered on flagged items to remove them.  That part is no longer working.   Prior to June 2024, that process did work, albeit very slowly and poorly; could paste in only ~100 records at a time.  Then in June, something changed with SP, and the look of list changed, but so did the performance – to the better!  Still not 100% great, but way better than before.  But, sometime during the first week of September, Microsoft rolled SharePoint back, and now I don’t seem to be able to paste in anything.  At all.  This is a major impact and setback to our processes.  Does anyone have any information on what MS did and why?  I’ve even got a ticket in with a Microsoft Support Escalation Engineer, and she said, “I have not found anything indicating why they made the change but I know they made a lot of changes to the Lists recently.”.  I appreciate any information folks may have – including a better way to update a SP list.  Thank you!  Read More

​

I work in a manufacturing warehouse and we are moving from a handheld scanner Windows mobile to an ipad with a bluetooth scanner. I dont want to configure these as a shared device in intune , but a managed device in intune that will run at most 3 apps. I’m trying to understand the best way to configure the device with a single account and then the ipad will be locked down with a wifi connection and run the apps internally, mostly a url in a browser. The plan is to configure these devices in fully supervised mode in intune

​I work in a manufacturing warehouse and we are moving from a handheld scanner Windows mobile to an ipad with a bluetooth scanner. I dont want to configure these as a shared device in intune , but a managed device in intune that will run at most 3 apps. I’m trying to understand the best way to configure the device with a single account and then the ipad will be locked down with a wifi connection and run the apps internally, mostly a url in a browser. The plan is to configure these devices in fully supervised mode in intune  Read More

​

We’re using MS teams to record our meetings and autimatically generate transcripts in spanish (Mexico) which teams automatically sets to spanish(spain) and butchers the entire conversation. It works well, great even, when spanish (Mexico) is set manually, but Its a massive hassle to do that every single meeting. I want to know if theres a way to set the language of the meeting to be spanish (Mexico) and have it stay that way unless its manually changed.

​We’re using MS teams to record our meetings and autimatically generate transcripts in spanish (Mexico) which teams automatically sets to spanish(spain) and butchers the entire conversation. It works well, great even, when spanish (Mexico) is set manually, but Its a massive hassle to do that every single meeting. I want to know if theres a way to set the language of the meeting to be spanish (Mexico) and have it stay that way unless its manually changed.  Read More

​

Hello everyone,

I’ve been running into a peculiar issue where actions we have configured to be blocked via our Endpoint DLP policies do not apply to the Microsoft Edge browser. Currently, we have a DLP policy configured to block attempts to access protected files by a list of restricted apps. Our restricted apps include “firefox.exe”, “chrome.exe”, “msedge.exe” and “msedgewebview2.exe“. When the sensitive content is accessed by either Chrome or Firefox, the DLP policy works correctly (Block with override), but the policy completely refuses to work in any scenario that involves Edge. The data we are using as an example is able to be accessed by the Edge executables without restriction.

Has anyone else run into this issue? It’s strange to me that for some reason Edge is just completely exempt from the DLP policy actions we have implemented.

Thank you!

​Hello everyone, I’ve been running into a peculiar issue where actions we have configured to be blocked via our Endpoint DLP policies do not apply to the Microsoft Edge browser. Currently, we have a DLP policy configured to block attempts to access protected files by a list of restricted apps. Our restricted apps include “firefox.exe”, “chrome.exe”, “msedge.exe” and “msedgewebview2.exe”. When the sensitive content is accessed by either Chrome or Firefox, the DLP policy works correctly (Block with override), but the policy completely refuses to work in any scenario that involves Edge. The data we are using as an example is able to be accessed by the Edge executables without restriction. Has anyone else run into this issue? It’s strange to me that for some reason Edge is just completely exempt from the DLP policy actions we have implemented. Thank you!  Read More

​

You can now better find and troubleshoot devices that aren’t reporting Windows update progress in Microsoft Intune reports. It might not have been evident before, but devices that aren’t sending diagnostic data to Microsoft can’t show detailed device status in the deployment process.

Two new alerts will give you better insights into these issues: DeviceDiagnosticDataNotReceived and MinimumOSBuildNotMet. You can find them integrated into Intune reporting just as they are in Windows Update for Business reports and Log Analytics. Let’s learn what these alerts mean, where to find them, and how to troubleshoot and remediate the underlying issues.

Reporting issues and causes

Have you ever faced any of the following issues while monitoring Windows update deployment?

Devices appear “offline,” preventing the update installation process, while other times they are updated successfully.
Devices in a deployment appear stuck in the “scheduled” or “offer-ready” states for a prolonged period, sometimes even after the update has been successfully installed. That is, they never show correct progress, such as “installing,” “waiting for a restart,” etc.
Devices don’t appear in Windows Update for Business reports after enrollment. This happens if the device never communicated diagnostic data in the first place or had not done so in more than 28 days.

These issues occur when a device fails to communicate client data. Some of the top causes are device inactivity or misconfigured client data settings. Another possible cause is that the device may not be on the required minimum OS build to qualify for report enrollment. You can gauge deployment success and monitor the overall health of your organization more effectively with device compliance alerts related to diagnostic data.

Device compliance alerts

Whatever reporting tool you use, it’s critical to see the true state of devices in your organization. Windows diagnostic data allows you to pinpoint a device’s progress through the deployment process and detect any issues that trigger alerts. Alerts provide details about what prevents devices from updating and give clear guidance on resolving these issues with targeted solutions. Here are the insights you can get with the two new alerts and the existing alert in Microsoft Intune.

New DeviceDiagnosticDataNotReceived alert

The DeviceDiagnosticDataNotReceived alert identifies devices that fail to send diagnostic data and thus their client status appears incorrectly in reports.

Meaning: Device is not communicating diagnostic data. This is a generic signal, and the reasons include but are not limited to:

Incorrect diagnostic data configuration
No configuration to send diagnostic data
Blocked network endpoints

Recommended action: Make sure that the device is correctly configured to share diagnostic data. Enable use of Windows diagnostic data by Intune and see the troubleshooting and remediation section below.
Reporting availability: Microsoft Intune (new), Windows Update for Business reports

Note: The DeviceDiagnosticDataNotReceived alert does not mean that the device is incapable of installing the updates offered to it. The report simply cannot represent the true state of the device since it’s dependent on receiving diagnostic data from the device.

New MinimumOSBuildNotMet alert

The MinimumOSBuildNotMet identifies a subset of missing devices that fail to qualify for report enrollment.

Meaning: Device does not meet the minimum servicing requirement for enrollment into reports due to the missing Windows diagnostic data processor configuration.
Recommended action: Ensure that the device has at least the January 2023 non-security update or February 2023 cumulative update installed. Learn more about Windows diagnostic processor support.
Reporting availability: Microsoft Intune (new), Windows Update for Business reports (new)

Important: The minimum OS build requirement is the January 2023 non-security update or later cumulative update for clients to enroll into Intune reports and Windows Update for Business reports.

Existing InsufficientUpdateConnectivity alert

A related alert that you might be more familiar with is InsufficientUpdateConnectivity. While not new, it complements the understanding of the bigger picture.

Meaning: Device is inactive, or its diagnostic data is not enough to validate sufficient activity to successfully update the device.
Recommended action: Make sure that the device is active and connected to the internet.
Reporting availability: Microsoft Intune, Windows Update for Business reports

The three alerts are mutually exclusive. An active DeviceDiagnosticDataNotReceived alert only provides a general overview of devices missing from reports for a variety of unspecified reasons. Devices with a known reason, such as not meeting the OS build prerequisite, would be instead identified by an active MinimumOSBuildNotMet alert. Likewise, the InsufficientUpdateConnectivity alert is more specific than the generic alert. These specific alerts would never appear as active together with DeviceDiagnosticDataNotReceived on the same device.

Let’s see how you can use these alerts in Microsoft Intune just as you do in Windows Update for Business reports or Log Analytics.

Integration with Microsoft Intune reporting

Whether you’re managing a few devices or thousands, Microsoft Intune helps you ensure that Windows update deployments run smoothly. Imagine that you want to monitor groups of devices associated with specific deployment policies. You can do so for the active devices that meet the prerequisites for enrollment to reports and consistently communicate diagnostic data. Here’s how you can locate and troubleshoot these scenarios with the new alerts.

Like all other alerts in Intune, view these alerts in the main status report and failure reports in Intune.

Log in to the Microsoft Intune admin center.
Navigate to Reports.
Under Device management, select Windows updates.
Switch to the Reports tab.

A screenshot of the Reports tab in the Microsoft Intune admin center.
Select to open the desired report from the available tile list. Note: We’re using an expedited updates report as an example here, but you can apply the following steps to the feature update and driver update reports as well.
Select the desired Update policy and Update aggregated status.
Select the Generate report button to view the results.

A screenshot of the Windows update status report in Microsoft Intune.

Failure reports bring together devices under specific policies that have errors or alerts. To view the failure reports:

Start in the Microsoft Intune admin center.
Navigate to Devices.
Under Manage updates, select Windows updates.
Switch to the Monitor tab.
Select the KPI card of the desired policy for a detailed view.

A screenshot of the consolidated view of update policies with active alerts in Microsoft Intune.
Select a profile from the list.

A screenshot of the policy profiles that contain devices with active errors in Microsoft Intune.
Select any of the policy profiles to view its list of devices with an active alert.

A screenshot of the devices with an active alert in the update failures report.
(Optional) Select specific alerts from the Alert filter.
Select the alert message for a specific device to view the error description, relevant details, and recommendations.

A screenshot of the Error devices full details flyout for a selected alert message.

Other reports to use these alerts

Using Windows Update for Business reports? You can also find these alerts there using Azure Workbooks or Log Analytics. Both alerts are currently available in the Azure Workbook Overview tab, within the Total devices KPI card. Just select View details and then Missing devices, as shown.

A screenshot of missing devices in Windows Update for Business reports, showing the two new alerts.

Use the following query if you’d like to view the data from the Windows Update for Business reports workbooks in Log Analytics:

UCDeviceAlert
| where AlertSubtype in (“DeviceDiagnosticDataNotReceived”, “MinimumOSBuildNotMet”)
| project DeviceName, AzureADDeviceId, AlertSubtype, StartTime, AlertData, Description, Recommendation

For more guidance on these reporting options, follow the instructions in Missing devices in Windows Update for Business reports?.

Troubleshoot and remediate diagnostic data issues

Please ensure that devices with these alerts are active and correctly configured to send Windows diagnostic data. To do that, verify that the following settings are configured correctly:

Default Windows diagnostic data settings. Check your Windows diagnostic data settings. In most cases, the default settings of “Required” or “Basic” are sufficient. If you’ve previously configured these settings to anything other than the default, check whether that configuration might affect diagnostic data behavior.
Intune diagnostic data settings. Check that you’ve correctly enabled Intune setting for diagnostic data.
Group Policy settings. Check any Group Policy settings you’re deploying. If the required settings are incorrectly set via Group Policy, they’ll override Intune settings. Pay special attention to any leftover Group Policies on the device. To resolve any conflicts, follow instructions in Allow diagnostic data Group Policy.
Configuration Manager co-management. If using Configuration Manager co-management, check your Diagnostic data settings in System Center Operations Manager.
OneSettings service. Make sure that the DisableOneSettingsDownload is enabled. The default is to never disable this configuration policy. To learn more and double-check this policy, visit System Policy CSP.

Important: If you have not enabled Windows diagnostic data or have other policies that disable this data for all devices, you’ll likely see this alert for all devices in your tenants. This is intentional. If you don’t intend to enable these settings, you can still use the reports to know when the update was made ready for devices or any service side alerts, like for Microsoft Entra-registered or other devices that don’t meet prerequisites for Windows Update for Business deployment service.

Start using the new alerts in Microsoft Intune today

Collecting and utilizing diagnostic data is essential for enhancing overall system reliability and efficiency.

Gain a more comprehensive view of Windows update deployment success using the two new alerts, DeviceDiagnosticDataNotReceived and MinimumOSBuildNotMet. This new capability within Microsoft Intune builds on the existing functionality in Windows Update for Business reports and Log Analytics, offering even more flexibility and control over your device management strategy.

In the spirit of continually making improvements, we’re happy to help you gain more insight into the subset of devices that were not easily identifiable before. Try out these new reporting enhancements and check out these additional resources:

Missing devices in Windows Update for Business reports?
Microsoft Intune troubleshooting

Continue the conversation. Find best practices. Bookmark the Windows Tech Community, then follow us @MSWindowsITPro on X and on LinkedIn. Looking for support? Visit Windows on Microsoft Q&A.

​Microsoft Tech Community – Latest Blogs –Read More 

In SharePoint (classic)  you can still create a Tasks list,  link it to Outlook and update / view / sort tasks in either location. Very powerful. 

These Sharepoint tasks assigned to me, do not show in Planner.

Will there be a Planner linked tasks list coming to SharePoint in the future, or will planner read SharePoint Tasks?

Or am  I not looking in the correct spot? 

​In SharePoint (classic)  you can still create a Tasks list,  link it to Outlook and update / view / sort tasks in either location. Very powerful.  These Sharepoint tasks assigned to me, do not show in Planner. Will there be a Planner linked tasks list coming to SharePoint in the future, or will planner read SharePoint Tasks? Or am  I not looking in the correct spot?      Read More

​

Hello Partners,

Join us for the Microsoft Nonprofit Virtual Partner Summit on September 30th, 7:30 AM – 9:30 AM PST where you’ll have the opportunity to hear directly from Microsoft nonprofit industry leaders about the latest updates in the nonprofit sector.

Open to all partners, this is your opportunity to:

Hear about nonprofit sector updates directly from Microsoft nonprofit industry leaders.
Gain insights into Tech for Social Impact FY25 Solution Plays directly from our Subject Matter Experts on Azure, BizApps, and Modern Work
Learn strategies for collaboration and growth for your nonprofit business practice: Tips for working with Sales, TSI ISV Digital Natives: How they can help your business grow, and Steps to build your nonprofit practice 

REGISTER HERE

​ 
Hello Partners,
 
Join us for the Microsoft Nonprofit Virtual Partner Summit on September 30th, 7:30 AM – 9:30 AM PST where you’ll have the opportunity to hear directly from Microsoft nonprofit industry leaders about the latest updates in the nonprofit sector.
 
Open to all partners, this is your opportunity to:
 

Hear about nonprofit sector updates directly from Microsoft nonprofit industry leaders.
Gain insights into Tech for Social Impact FY25 Solution Plays directly from our Subject Matter Experts on Azure, BizApps, and Modern Work
Learn strategies for collaboration and growth for your nonprofit business practice: Tips for working with Sales, TSI ISV Digital Natives: How they can help your business grow, and Steps to build your nonprofit practice 

 
REGISTER HERE  Read More

​