Category: Microsoft
Category Archives: Microsoft
System Center Service Manager Request Offering populate fields from a SQL database
Hey
I am working on a automation project in System Center Service Manager 2019. I have a Request Offering which have fields I would like to populate from an sql database server. So when user access the form, the drop down would pull data in from an database vs mainly importing it.
HeyI am working on a automation project in System Center Service Manager 2019. I have a Request Offering which have fields I would like to populate from an sql database server. So when user access the form, the drop down would pull data in from an database vs mainly importing it. Read More
Surface Laptop 5 SSD Upgrade issues
Hi all,
I recently upgraded the SSD from 256gb to 1tb in my Surface Laptop 5. I cloned the original SSD since I had a bunch of files and installed software already. It works great, but when I turn on the device, the initial Windows logo restarts around four to five times before it shows the spinning wheel loading Windows. Before the ssd upgrade, this wasn’t happening so I’m pretty sure it’s something talked to the new ssd and the booting. Any thoughts on how to solve this?
Hi all, I recently upgraded the SSD from 256gb to 1tb in my Surface Laptop 5. I cloned the original SSD since I had a bunch of files and installed software already. It works great, but when I turn on the device, the initial Windows logo restarts around four to five times before it shows the spinning wheel loading Windows. Before the ssd upgrade, this wasn’t happening so I’m pretty sure it’s something talked to the new ssd and the booting. Any thoughts on how to solve this? Read More
Exchange Server Vulnerability – Vulnerable Schema Class (CVE-2021-34470)
Howdy ! Exchange Brain Trust,
Working with a customer who’s fully on 365 with no Exchange servers left on-prem but the Vulnerable Schema Class exists from a previous implementation of Exchange.
Even after uninstallation of all Exchange servers, the schema extensions made by Exchange to the Active Directory are not removed. Therefore, customer is currently vulnerable to CVE-2021-34470 and should execute this script to address this vulnerability.
If anyone have dealt with this before or can help me clarifying what implications this change can have to the normal operations and future objects provisioning (or any risk at all to the environment), that’d be really appreciated!.
Changes: Schema Modification
If the -ApplyFix parameter is used, the script modifies the schema by clearing the possSuperiors propertyof the ms-Exch-Storage-Group entry.
Thank you!
Howdy ! Exchange Brain Trust,Working with a customer who’s fully on 365 with no Exchange servers left on-prem but the Vulnerable Schema Class exists from a previous implementation of Exchange. Even after uninstallation of all Exchange servers, the schema extensions made by Exchange to the Active Directory are not removed. Therefore, customer is currently vulnerable to CVE-2021-34470 and should execute this script to address this vulnerability. If anyone have dealt with this before or can help me clarifying what implications this change can have to the normal operations and future objects provisioning (or any risk at all to the environment), that’d be really appreciated!. Changes: Schema ModificationIf the -ApplyFix parameter is used, the script modifies the schema by clearing the possSuperiors propertyof the ms-Exch-Storage-Group entry. Thank you! Read More
Want to go out from insider dev without usb😭😭😭
Hello,
I joined insider on release preview and updated win. 11 24h2 but mistakely i clicked then on Dev channel and now i want to come out from it!
I also restarted my PC / clicked on leave programme but it don’t works and suggesting to reinstall windows……
I don’t have USB so please help me to tell how can i reinstall windows without USB:loudly_crying_face::loudly_crying_face:plzzz help suggesting other method in which usb is not needed i don’t care of wipe data plzzzzzzz:loudly_crying_face::loudly_crying_face:
Hello,I joined insider on release preview and updated win. 11 24h2 but mistakely i clicked then on Dev channel and now i want to come out from it!I also restarted my PC / clicked on leave programme but it don’t works and suggesting to reinstall windows……I don’t have USB so please help me to tell how can i reinstall windows without USB:loudly_crying_face::loudly_crying_face:plzzz help suggesting other method in which usb is not needed i don’t care of wipe data plzzzzzzz:loudly_crying_face::loudly_crying_face: Read More
“Troubleshooting Issue with File Explorer on Windows 10”
When I attempt to open a folder in the file explorer by right-clicking, I encounter the same issue twice before it finally shows the contents:
Error Message: Folder is corrupted and unreadable.
Is there anyone who has faced this issue before or can suggest a solution?
Device: Windows 10 Version 22H2 Build 19045.4651
When I attempt to open a folder in the file explorer by right-clicking, I encounter the same issue twice before it finally shows the contents: Error Message: Folder is corrupted and unreadable. Is there anyone who has faced this issue before or can suggest a solution? Device: Windows 10 Version 22H2 Build 19045.4651 Read More
Can you rephrase this laptop problem for me?
Hello,
When you receive a new laptop, what steps do you take after unboxing it to ensure everything is in working order?
Have you considered creating a full backup using Macrium immediately after unboxing to safeguard against any potential issues in the future? Would you keep this initial backup indefinitely or delete it once it’s no longer needed?
Thank you.
Hello, When you receive a new laptop, what steps do you take after unboxing it to ensure everything is in working order? Have you considered creating a full backup using Macrium immediately after unboxing to safeguard against any potential issues in the future? Would you keep this initial backup indefinitely or delete it once it’s no longer needed? Thank you. Read More
Nightly Restart of Windows Computers
There is no Group Policy Object (GPO) in place to handle this issue. I observed this in my event viewer. This is occurring on both Windows 10 and 11 systems.
Automatic updates are disabled, and the “Do not automatically restart” setting is activated for Windows Update. To investigate further, I have paused the updates for a week, even though no recent updates have been installed. I have not identified any tasks in the Task Scheduler that I personally set up.
Microsoft Windows [Version 10.0.22621.2861]
(c) Microsoft Corporation. All rights reserved.
The system boot time is recorded as July 22, 2024, at 3:03:14 AM.
A restart of the computer was initiated by the process C:Windowssystem32wbemwmiprvse.exe (*******-LT), executed by the user NT AUTHORITYSYSTEM. The reason given for the restart is unknown, with the reason code noted as 0x80070015.
Shutdown Type: Restart.
There is no Group Policy Object (GPO) in place to handle this issue. I observed this in my event viewer. This is occurring on both Windows 10 and 11 systems. Automatic updates are disabled, and the “Do not automatically restart” setting is activated for Windows Update. To investigate further, I have paused the updates for a week, even though no recent updates have been installed. I have not identified any tasks in the Task Scheduler that I personally set up. Microsoft Windows [Version 10.0.22621.2861](c) Microsoft Corporation. All rights reserved. The system boot time is recorded as July 22, 2024, at 3:03:14 AM. A restart of the computer was initiated by the process C:Windowssystem32wbemwmiprvse.exe (*******-LT), executed by the user NT AUTHORITYSYSTEM. The reason given for the restart is unknown, with the reason code noted as 0x80070015. Shutdown Type: Restart. Read More
Error Encountered Upon Launching Explorer?
Greetings everyone,
I’m facing an unusual issue during startup that is interrupting my usual routine. A small blank explorer.exe dialogue box appears, and until I manually click OK using either the mouse or the keyboard, my startup programs such as Logitech G-hub and Sandboxie do not launch. Once I acknowledge the dialogue, I hear a notification sound, and everything proceeds as usual.
This problem surfaced only recently, coinciding with my decision to tidy up my system by deleting old empty folders and some unidentified recently created folders, including a few within the ProgramData directory (an oversight on my part!). I even cleared out the Recycle Bin during this cleanup process.
I attempted to resolve the issue by running SFC/Scannow, which did detect and repair some corrupted files, although none of them seemed related to the areas I was exploring. To further troubleshoot, I uninstalled Windowblinds 11 and Start11 following recommendations from another source.
Although the reliability history doesn’t indicate any specific errors, this issue persists every time I log in, despite using a local account rather than a Microsoft one.
Do any of you have suggestions for addressing this startup hitch?
Other than this inconvenience, my computer appears to be functioning normally.
I appreciate any insights or advice on this matter.
Greetings everyone, I’m facing an unusual issue during startup that is interrupting my usual routine. A small blank explorer.exe dialogue box appears, and until I manually click OK using either the mouse or the keyboard, my startup programs such as Logitech G-hub and Sandboxie do not launch. Once I acknowledge the dialogue, I hear a notification sound, and everything proceeds as usual. This problem surfaced only recently, coinciding with my decision to tidy up my system by deleting old empty folders and some unidentified recently created folders, including a few within the ProgramData directory (an oversight on my part!). I even cleared out the Recycle Bin during this cleanup process. I attempted to resolve the issue by running SFC/Scannow, which did detect and repair some corrupted files, although none of them seemed related to the areas I was exploring. To further troubleshoot, I uninstalled Windowblinds 11 and Start11 following recommendations from another source. Although the reliability history doesn’t indicate any specific errors, this issue persists every time I log in, despite using a local account rather than a Microsoft one. Do any of you have suggestions for addressing this startup hitch? Other than this inconvenience, my computer appears to be functioning normally. I appreciate any insights or advice on this matter. Read More
How to Turn Off the Windows Key Shortcut Guide
Hello everyone! I’m looking for advice on how to enhance the Windows Key Shortcut Guide. This feature appears when you press and hold the Windows key for a few seconds – check out the screenshot below. I’m interested in customizing this guide without affecting any other Windows Shortcut Keys. Any suggestions would be greatly appreciated.
Hello everyone! I’m looking for advice on how to enhance the Windows Key Shortcut Guide. This feature appears when you press and hold the Windows key for a few seconds – check out the screenshot below. I’m interested in customizing this guide without affecting any other Windows Shortcut Keys. Any suggestions would be greatly appreciated. Read More
How to uninstall Copilot Preview?
After upgrading my operating system to 23H2, I noticed a new persistent presence on my taskbar – Copilot Preview. Despite my attempts to remove the icon, it keeps reappearing. Although Copilot does not seem to be actively running, it is located in the Program FilesWindowsApps directory, where I am unable to access or modify its permissions. I am now considering whether it is safe to delete all Copilot files, as the application does not appear in any of my uninstallers. I located all the related files using Everything. Here is a snapshot of some of the files.
After upgrading my operating system to 23H2, I noticed a new persistent presence on my taskbar – Copilot Preview. Despite my attempts to remove the icon, it keeps reappearing. Although Copilot does not seem to be actively running, it is located in the Program FilesWindowsApps directory, where I am unable to access or modify its permissions. I am now considering whether it is safe to delete all Copilot files, as the application does not appear in any of my uninstallers. I located all the related files using Everything. Here is a snapshot of some of the files. Read More
Prevent Microsoft from Accessing My Computer
Undergoing a sudden transition to Windows 11 left me feeling overwhelmed. Despite having disabled all updates and backups, the installation resulted in a catastrophic failure that rendered my computer barely functional. I sought assistance from various Microsoft Support platforms, only to be met with unhelpful responses. The chat option was equally unproductive. Frustrated, I took matters into my own hands by backing up essential files onto a flash drive and initiating a factory reset.
Following the reset, I encountered persistent issues with installing the Office 2019 software that I had purchased. Repeated error messages stating “Something went wrong” plagued my attempts. In the aftermath of the Windows 11 installation, I struggled to locate the product key required for activation, further complicating the situation.
Utilizing a Microsoft tool, I managed to remove the failed Office installations, paving the way for a subsequent reset on 06/19/2024. This time, I resorted to using the Edge browser to successfully download and install Office, raising questions about the browser’s compatibility that had eluded me before.
Reflecting on my experience, I found myself increasingly concerned about the integration of my original Office software with the subscription-based Office 365. This unwelcome tethering of applications, such as OneDrive, infringed upon my sense of control over my computing environment. Despite my efforts to disconnect and disable certain features, unwanted changes continued to manifest themselves, ranging from unexpected desktop backgrounds to intrusive online synchronization of data.
Feeling besieged by the pervasive influence of Microsoft on my device, I contemplated drastic measures like switching to a Mac or seeking support through crowdfunding platforms. The unsettling realization that my autonomy was being eroded prompted me to question the feasibility of reclaiming my standalone Office application and severing ties with Office 365 and OneDrive.
The persistent disruptions and encroachments on my digital space left me fatigued and yearning for a return to a state of stability and privacy. I reached out for assistance in restoring my familiar software and regaining control over my computing experience, recognizing the fine line between legitimate concerns and the perceived indulgence of complaints.
Undergoing a sudden transition to Windows 11 left me feeling overwhelmed. Despite having disabled all updates and backups, the installation resulted in a catastrophic failure that rendered my computer barely functional. I sought assistance from various Microsoft Support platforms, only to be met with unhelpful responses. The chat option was equally unproductive. Frustrated, I took matters into my own hands by backing up essential files onto a flash drive and initiating a factory reset. Following the reset, I encountered persistent issues with installing the Office 2019 software that I had purchased. Repeated error messages stating “Something went wrong” plagued my attempts. In the aftermath of the Windows 11 installation, I struggled to locate the product key required for activation, further complicating the situation. Utilizing a Microsoft tool, I managed to remove the failed Office installations, paving the way for a subsequent reset on 06/19/2024. This time, I resorted to using the Edge browser to successfully download and install Office, raising questions about the browser’s compatibility that had eluded me before. Reflecting on my experience, I found myself increasingly concerned about the integration of my original Office software with the subscription-based Office 365. This unwelcome tethering of applications, such as OneDrive, infringed upon my sense of control over my computing environment. Despite my efforts to disconnect and disable certain features, unwanted changes continued to manifest themselves, ranging from unexpected desktop backgrounds to intrusive online synchronization of data. Feeling besieged by the pervasive influence of Microsoft on my device, I contemplated drastic measures like switching to a Mac or seeking support through crowdfunding platforms. The unsettling realization that my autonomy was being eroded prompted me to question the feasibility of reclaiming my standalone Office application and severing ties with Office 365 and OneDrive. The persistent disruptions and encroachments on my digital space left me fatigued and yearning for a return to a state of stability and privacy. I reached out for assistance in restoring my familiar software and regaining control over my computing experience, recognizing the fine line between legitimate concerns and the perceived indulgence of complaints. Read More
Windows 11 – Outlook instance is already running when computer starts up.
When Windows boots up, sometimes I can’t open Outlook 365. Typically, ending the process and restarting Outlook works. I started checking the task manager immediately on boot up, and there are times when Outlook is already running and times when it is not. If Outlook is already running, it isn’t possible to open Outlook unless the process is ended. If Outlook is not running, there are no problems.
Is there a reason Outlook is sometimes already running when first booting up Windows? I tried searching for an answer but didn’t get very far; a lot on disabling add-ons and resetting the nav pane, which doesn’t apply to my issue.
I did run a repair, and it didn’t fix this issue.
Thanks for your help.
When Windows boots up, sometimes I can’t open Outlook 365. Typically, ending the process and restarting Outlook works. I started checking the task manager immediately on boot up, and there are times when Outlook is already running and times when it is not. If Outlook is already running, it isn’t possible to open Outlook unless the process is ended. If Outlook is not running, there are no problems. Is there a reason Outlook is sometimes already running when first booting up Windows? I tried searching for an answer but didn’t get very far; a lot on disabling add-ons and resetting the nav pane, which doesn’t apply to my issue. I did run a repair, and it didn’t fix this issue. Thanks for your help. Read More
Formula to look at the dates given a condition
Hello!
I am stuck with this problem for quite some time now and I really need help.
I have this pivot table that has the product on the rows and the shipment dates on the column and the quantity in the shipment as values.
Basically, what I want to create is a formula that will get the next shipment date for each product. If the date is past then it should tell me the next date. Or there is a better way of doing this, please do share. Thank you!
Hello!I am stuck with this problem for quite some time now and I really need help. I have this pivot table that has the product on the rows and the shipment dates on the column and the quantity in the shipment as values. Basically, what I want to create is a formula that will get the next shipment date for each product. If the date is past then it should tell me the next date. Or there is a better way of doing this, please do share. Thank you! Read More
Azure Integration Services Quarterly Highlights and Insights 2024’Q2
Welcome to the second installment of our quarterly blog series featuring the latest updates and highlights from Azure Integration Services. Over the past few months, we’ve witnessed several exciting developments, from new product releases to insightful customer stories, all showcasing the continued innovation and impact of Azure Integration Services in driving digital transformation.
In this edition, we’ll revisit the key milestones and achievements that have shaped the integration landscape, empowering organizations to seamlessly connect their systems, data, and processes.
Product Announcements
Now in general availability, Azure API Center is a centralized solution that offers a unified API inventory for seamless discovery, consumption, and governance of APIs, regardless of their type, lifecycle stage, or deployment location. Looking to learn more about Azure API Center? Our introductory learning module provides a comprehensive overview, exploring the core functionalities of API Center.
With the rise in Gen AI app usage, there’s an urgent need for enterprise-wide, federated access to manage and secure endpoints. At Build, we announced the GenAI Gateway capabilities in Azure API Management to tackle these challenges for Azure OpenAI Services endpoints. As a first step, we’ve simplified the onboarding process so you can now import all Azure OpenAI endpoints into the Azure API Management platform with a single click. These endpoints will be protected by Azure API Management’s built-in managed identity authentication. For scaled workloads, we provide load balancing, rate limiting, and out-of-box observability support.
By simplifying and automating how you connect and integrate various applications, services, and data sources in the cloud, Azure Logic Apps users can create and run automated workflows with little to no code. Recent updates to the platform include new features that enhance seamless management of integration flows, simplify legacy integration, and enable efficient B2B integration. We’ve added support for zero downtime deployment scenarios in the portal (public preview for Logic Apps Standard), EDI (X12/EDIFACT) processing with built in actions (general availability), Improved Onboarding Experience on VS Code for Logic Apps Standard (general availability), and more. Click here for more technical details.
Azure Service Bus is a fully managed enterprise message broker that ensures secure and efficient delivery of data messages between different parts of your system, even when they’re disconnected or processing tasks at different speeds. Currently in preview, batch delete feature empowers customers to delete messages on the service side from an entity or the dead letter queue in batches of up to 4,000 messages.
Like an event dispatcher for your cloud, Azure Event Grid triggers actions across your applications and services in near real-time whenever something significant happens. New features are generally available that are tailored to customers who are looking for a pub-sub message broker that can enable Internet of Things (IoT) solutions using MQTT protocol and can help build event-driven applications. For more technical details on these announcements, click here.
Customer Stories: Real-world Impact, Real-world Solutions
Over the past few months, we’ve showcased inspiring customer stories highlighting the real-world impact of Azure Integration Services. These testimonials not only celebrate our users’ successes but also offer valuable insights to help you envision how our solutions can address your specific needs and deliver tangible benefits for your organization.
Kantar, a global data and consulting company, faced the challenge of a fragmented IT landscape due to multiple divisions operating independently with diverse legacy systems. This resulted in operational inefficiencies and hindered innovation. By adopting Azure Integration Services, Kantar was able to unify its IT operations, streamlining processes and data flows across divisions. This modernization effort led to increased business agility, faster time-to-market, and a more cohesive technology ecosystem.
Össur, a global leader in non-invasive orthopedic technology, aimed to consolidate its manufacturing operations onto a unified platform to improve efficiency and scalability. By leveraging Azure Integration Services, Össur successfully migrated its legacy systems to the cloud, enabling seamless data integration and automation across its manufacturing processes. This transformation resulted in a more agile and cost-effective production environment, empowering Össur to respond faster to market demands and deliver innovative products to its customers.
Events
We recently hosted a 90-minute webinar on how Azure Integration Services can empower organizations in the rapidly changing tech landscape, highlighting the essential role of seamless integration in driving innovation and growth across industries. It delved into Azure API Management’s robust security measures to protect against cyber threats while ensuring compliance. We also explored the transformative power of AI-driven integration and how Azure Integration Services can harness AI capabilities to automate tasks, unlock new opportunities, and drive innovation.
Microsoft’s Build 2024 conference, held in Seattle and online in May, showcased the GenAI Gateway Capabilities in Azure API Management. Demos showcased how API Management can be configured for authentication and authorization for OpenAI endpoint, enforcing rate limits based on OpenAI tokens used, load balancing across multiple OpenAI endpoints and more.
Shortly after Build, at the Integrate 2024 conference the Microsoft Azure Integration Services team highlighted advancements in generative AI, API management, and developer productivity.
Take Action
Azure Logic Apps Integration Service Environment (ISE) is being retired on August 31, 2024. To ensure uninterrupted service, migrate your ISE instances to Azure Logic Apps Standard as soon as possible. Check this blog for resources to help with the transition.
August 31st is also the deadline to upgrade your Azure API Management to stv2! For a detailed guide on the migration process, you can refer to our official documentation.
Stay informed on all things integration!
Stay up-to-date with the latest product announcements, events, and customer stories—check out everything going on with Azure Integration Services by following our blog!
Microsoft Tech Community – Latest Blogs –Read More
New Teams – Windows Server 2019 for remote users – Banner – ‘Please sign in again. This could be…’
New Teams – Windows Server 2019 for remote users – Banner – ‘Please sign in again. This could be a request from your IT department or Teams, or the result of a password update.’
Does anyone know how to resolve this issue? Although it says to Sign into New Teams, you can still send messages, see status and add Teams Meetings in Outlook.
I followed the MS VDI install instructions as per the below link, FSlogix is on the latest, Webview2 is installed, redirections added to xml file. Any ideas?
New Microsoft Teams for Virtualized Desktop Infrastructure (VDI) – Microsoft Teams | Microsoft Learn
New Teams – Windows Server 2019 for remote users – Banner – ‘Please sign in again. This could be a request from your IT department or Teams, or the result of a password update.’ Does anyone know how to resolve this issue? Although it says to Sign into New Teams, you can still send messages, see status and add Teams Meetings in Outlook.I followed the MS VDI install instructions as per the below link, FSlogix is on the latest, Webview2 is installed, redirections added to xml file. Any ideas?New Microsoft Teams for Virtualized Desktop Infrastructure (VDI) – Microsoft Teams | Microsoft Learn Read More
Email account with Apple mail
Using Apple Mail on iMac Somona 14.5
Continually being asked to enter password for email account. Have followed the instructions sent out with new authentication procedures several times and no success.
Instructions given appear to show the iPhone/iPad option and not iMac
On iMac the ‘Outlook’ icon does not come up when adding new account and have to use “Other” option to add my outlook account.
Please advise
Using Apple Mail on iMac Somona 14.5 Continually being asked to enter password for email account. Have followed the instructions sent out with new authentication procedures several times and no success.Instructions given appear to show the iPhone/iPad option and not iMacOn iMac the ‘Outlook’ icon does not come up when adding new account and have to use “Other” option to add my outlook account.Please advise Read More
Highlight series of cells if 1st or last row contains text
Hello, I have a worksheet that contains a few rows for each employee. The ID # is in column A, and column E will contain a calculated numeric value. For each employee, I would like to highlight all rows of Column A, if any rows in column E for that employee are > 0. Note that the number of rows for each employee may vary.
I’m fine doing this with either conditional formatting or a formula.
So, in the attached:
# 111 has a value of 1 in the first row, so I would like to highlight all rows in column A for that person
# 666 has a value of 2 in the last row, so I would also like to highlight all rows for that person
IDs 222,444, and 555 don’t have 0 in all rows, so nothing is highlighted for them
Hello, I have a worksheet that contains a few rows for each employee. The ID # is in column A, and column E will contain a calculated numeric value. For each employee, I would like to highlight all rows of Column A, if any rows in column E for that employee are > 0. Note that the number of rows for each employee may vary. I’m fine doing this with either conditional formatting or a formula. So, in the attached: # 111 has a value of 1 in the first row, so I would like to highlight all rows in column A for that person# 666 has a value of 2 in the last row, so I would also like to highlight all rows for that personIDs 222,444, and 555 don’t have 0 in all rows, so nothing is highlighted for them Read More
Pivot Table Date Grouping
I am trying to group dates in my PivotTable. All or most of the videos I’ve watched have said to right click & the option for grouping/ungrouping should be there. It’s not. I believe the dates are correctly formatted but I could be wrong (I did double check by going to the home tab & in the number section date was selected but I chose general & then long date & switch the country to UK). Still, I’m not getting the option. I also went to the data tab & clicked on group. Still, no option to group.
For reference I am using the web-based version of Excel via Microsoft365.
Any help would be appreciated.
I am trying to group dates in my PivotTable. All or most of the videos I’ve watched have said to right click & the option for grouping/ungrouping should be there. It’s not. I believe the dates are correctly formatted but I could be wrong (I did double check by going to the home tab & in the number section date was selected but I chose general & then long date & switch the country to UK). Still, I’m not getting the option. I also went to the data tab & clicked on group. Still, no option to group.For reference I am using the web-based version of Excel via Microsoft365.Any help would be appreciated. Read More
Admin Center is inaccessible due to a pop-up from Business Advisor
Hello community members,
Is anyone aware of the Microsoft 365 admin centre issue where Business Advisor pop-up is blocking everything. The pop-up cannot be closed and any selections within the pop-up causes a page refresh, after which the pop-up presents itself again. I have tried reaching out at answers.microsoft.com, where others have also written about it, but no solution has been seen so far.
Post 1-
Post 2-
Who will be able to provide help with this? Microsoft US support is a bot voice agent who is unable to understand the issue. Could someone in this community point me in the right direction?
Kind regards,
-Harsh
Hello community members,Is anyone aware of the Microsoft 365 admin centre issue where Business Advisor pop-up is blocking everything. The pop-up cannot be closed and any selections within the pop-up causes a page refresh, after which the pop-up presents itself again. I have tried reaching out at answers.microsoft.com, where others have also written about it, but no solution has been seen so far.Post 1-https://answers.microsoft.com/en-us/msoffice/forum/all/cant-access-ms365-account-because-business-advisor/17df0f63-8216-4346-ac01-356d5a74850f Post 2-https://answers.microsoft.com/en-us/msoffice/forum/all/microsoft-admin-center-is-stuck-on-the-intro/03e6f02e-6168-4b92-95e6-d6271b864ac1 Post 3-https://answers.microsoft.com/en-us/msoffice/forum/all/how-to-stop-business-advisor-from-locking-out-of/b3957ad2-9573-4f2c-a012-e6c348f15994 Who will be able to provide help with this? Microsoft US support is a bot voice agent who is unable to understand the issue. Could someone in this community point me in the right direction? Kind regards,-Harsh Read More
Highlight Date Cell based on proximity to todays date AND another controlling cell
Hello Everyone,
I’ve read multiple posts on this topic but did not find one that exactly worked for me so I would appreciate everyone’s help.
My workbook currently uses conditional formatting to color-fill rows based on the value of column H. I also want to add the following date cell highlights into the mix if possible.
If employee is on “LOA-Active” (column H), I want date in column L to highlight YELLOW 1 week prior to their return date (column L) to show employee will be returning back from leave in the next week.
If employee is on “LOA – Active” (column H), I want date in column L to highlight RED once the date listed in column L has passed to show employee has not returned from leave
If employee is scheduled for a future leave “LOA – Future” (column H), I want date in column K to highlight yellow 1 week prior to date in K to show they will be going out on leave soon.
I need the controlling cell to be column H as “LOA-Active” highlights Column L whereas “LOA-Future” highlights column K. Once an employee returns from leave column H is marked as “LOA-Returned”, then moved to the very bottom of the spreadsheet. I want the column L highlights to then disappear.
That sounds like a lot once I typed it all out…….Your help is so much appreciated.
Hello Everyone, I’ve read multiple posts on this topic but did not find one that exactly worked for me so I would appreciate everyone’s help. My workbook currently uses conditional formatting to color-fill rows based on the value of column H. I also want to add the following date cell highlights into the mix if possible. If employee is on “LOA-Active” (column H), I want date in column L to highlight YELLOW 1 week prior to their return date (column L) to show employee will be returning back from leave in the next week.If employee is on “LOA – Active” (column H), I want date in column L to highlight RED once the date listed in column L has passed to show employee has not returned from leaveIf employee is scheduled for a future leave “LOA – Future” (column H), I want date in column K to highlight yellow 1 week prior to date in K to show they will be going out on leave soon. I need the controlling cell to be column H as “LOA-Active” highlights Column L whereas “LOA-Future” highlights column K. Once an employee returns from leave column H is marked as “LOA-Returned”, then moved to the very bottom of the spreadsheet. I want the column L highlights to then disappear. That sounds like a lot once I typed it all out…….Your help is so much appreciated. Read More