Category: Microsoft
Category Archives: Microsoft
Excel VBA move row up once status is marked “DONE” above a merged row and put in numerical order.
I am having problems figuring out how to code the following. Once the column ‘Status’ is marked “DONE” need to move the row up above a merged row and put it in numerical order based off ‘Workorder Number’ and keep the conditional formatting that is applied and remove the marching ants from the row that was cut.
I am having problems figuring out how to code the following. Once the column ‘Status’ is marked “DONE” need to move the row up above a merged row and put it in numerical order based off ‘Workorder Number’ and keep the conditional formatting that is applied and remove the marching ants from the row that was cut. Read More
How to Use Copilot with Microsoft Word
Microsoft Word, a staple in the world of word processing, has continuously evolved to meet the demands of modern users. One of the latest advancements is the integration of AI-powered tools like Copilot, which promises to revolutionize the way we write and edit documents. In this blog, we’ll explore how to use Copilot with Microsoft Word to enhance your productivity and streamline your writing process.
What is Copilot?
Copilot, developed by OpenAI and integrated into various Microsoft products, is an AI assistant designed to help users with a range of tasks, from generating text to offering suggestions and corrections. In Microsoft Word, Copilot acts as a virtual assistant, providing real-time assistance as you write.
Getting Started with Copilot in Microsoft Word
To use Copilot with Microsoft Word, you need to ensure you have an active Microsoft 365 subscription and the latest version of Word. Here’s how to get started:
Update Microsoft Word: Make sure your Word application is updated to the latest version to access Copilot features.
Sign in to Microsoft 365: Use your Microsoft 365 credentials to sign in and unlock the full potential of Copilot.
Enable Copilot: In Word, navigate to the “Help” or “Tools” menu to enable Copilot. This may vary slightly depending on your version of Word.
Using Copilot to Enhance Your Writing
Once Copilot is enabled, you can start leveraging its capabilities to improve your writing workflow. Here are some key features and how to use them:
Generating Text: If you’re struggling with writer’s block or need inspiration, Copilot can help generate text based on your prompts. Simply type a brief description of what you need, and Copilot will provide suggestions. For example, type “Write an introduction for a blog about productivity tools,” and Copilot will generate a few paragraphs to get you started.
Editing and Proofreading: Copilot excels at catching grammatical errors, typos, and stylistic issues. Highlight a section of text and ask Copilot to review it. You’ll receive suggestions for corrections and improvements, ensuring your document is polished and professional.
Research and Information Retrieval: Need facts or references? Copilot can help you find relevant information without leaving Word. Ask Copilot a question or request data on a specific topic, and it will pull in information from reliable sources.
Formatting Assistance: Struggling with document formatting? Copilot can offer tips and automatically adjust formatting to ensure consistency. Whether it’s creating bullet points, adjusting headings, or setting up tables, Copilot has you covered.
Language Translation: Writing for a global audience? Copilot can translate sections of your document into different languages, making it easier to communicate with diverse audiences.
Tips for Maximizing Copilot’s Potential
Be Specific with Prompts: The more specific you are with your prompts, the better Copilot can assist you. Clearly state what you need to get the most accurate and helpful responses.
Review Suggestions Carefully: While Copilot is powerful, it’s not infallible. Always review its suggestions to ensure they align with your intent and make necessary adjustments.
Explore Advanced Features: Don’t hesitate to explore advanced features and settings in Copilot. Customizing its behavior can further enhance your writing experience.
Sum up
Integrating Copilot with Microsoft Word is a game-changer for anyone looking to boost their writing efficiency and quality. By leveraging AI assistance, you can overcome common writing challenges, enhance your productivity, and create compelling, error-free documents with ease. Give Copilot a try and discover how it can transform your writing process in Microsoft Word.
Mastering Copilot with Microsoft WordMicrosoft Word, a staple in the world of word processing, has continuously evolved to meet the demands of modern users. One of the latest advancements is the integration of AI-powered tools like Copilot, which promises to revolutionize the way we write and edit documents. In this blog, we’ll explore how to use Copilot with Microsoft Word to enhance your productivity and streamline your writing process.What is Copilot?Copilot, developed by OpenAI and integrated into various Microsoft products, is an AI assistant designed to help users with a range of tasks, from generating text to offering suggestions and corrections. In Microsoft Word, Copilot acts as a virtual assistant, providing real-time assistance as you write.Getting Started with Copilot in Microsoft WordTo use Copilot with Microsoft Word, you need to ensure you have an active Microsoft 365 subscription and the latest version of Word. Here’s how to get started:Update Microsoft Word: Make sure your Word application is updated to the latest version to access Copilot features.Sign in to Microsoft 365: Use your Microsoft 365 credentials to sign in and unlock the full potential of Copilot.Enable Copilot: In Word, navigate to the “Help” or “Tools” menu to enable Copilot. This may vary slightly depending on your version of Word.Using Copilot to Enhance Your WritingOnce Copilot is enabled, you can start leveraging its capabilities to improve your writing workflow. Here are some key features and how to use them:Generating Text: If you’re struggling with writer’s block or need inspiration, Copilot can help generate text based on your prompts. Simply type a brief description of what you need, and Copilot will provide suggestions. For example, type “Write an introduction for a blog about productivity tools,” and Copilot will generate a few paragraphs to get you started.Editing and Proofreading: Copilot excels at catching grammatical errors, typos, and stylistic issues. Highlight a section of text and ask Copilot to review it. You’ll receive suggestions for corrections and improvements, ensuring your document is polished and professional.Research and Information Retrieval: Need facts or references? Copilot can help you find relevant information without leaving Word. Ask Copilot a question or request data on a specific topic, and it will pull in information from reliable sources.Formatting Assistance: Struggling with document formatting? Copilot can offer tips and automatically adjust formatting to ensure consistency. Whether it’s creating bullet points, adjusting headings, or setting up tables, Copilot has you covered.Language Translation: Writing for a global audience? Copilot can translate sections of your document into different languages, making it easier to communicate with diverse audiences.Tips for Maximizing Copilot’s PotentialBe Specific with Prompts: The more specific you are with your prompts, the better Copilot can assist you. Clearly state what you need to get the most accurate and helpful responses.Review Suggestions Carefully: While Copilot is powerful, it’s not infallible. Always review its suggestions to ensure they align with your intent and make necessary adjustments.Explore Advanced Features: Don’t hesitate to explore advanced features and settings in Copilot. Customizing its behavior can further enhance your writing experience.Sum upIntegrating Copilot with Microsoft Word is a game-changer for anyone looking to boost their writing efficiency and quality. By leveraging AI assistance, you can overcome common writing challenges, enhance your productivity, and create compelling, error-free documents with ease. Give Copilot a try and discover how it can transform your writing process in Microsoft Word. Read More
How to install WMIC Feature on Demand on Windows 11
Do you need to continue using Windows Management Instrumentation Command (WMIC) line? Though this feature is currently being deprecated, there is a temporary solution to help your organization while you finish migrating to PowerShell or a similar tool. This solution is brought to you by Features on Demand (FoDs).
WMIC has been available as a FoD for Windows 11 since 2022. It will be disabled by default later this year, but it will remain available for those who need it. In preparation for this next deprecation stage, let’s review the steps you’ll need to take to use this optional feature a bit longer.
Symptoms of a missing WMIC FoD
If WMIC.exe is missing from your setup, you’ll see this error message when you attempt a WMIC command in the command prompt: ‘wmic’ is not recognized as an internal or external command, operable program, or batch file.
That’s expected behavior if WMIC is missing, disabled, or uninstalled from your system. If you still need to use WMIC, you’ll need to install it as a FoD. Let’s see how.
Locate optional features in Windows Settings
FoDs are listed as optional features in Windows Settings. You can view the history of optional features that have been installed on the system and manage these components by adding, removing, or altering existing features.
There are two easy ways to locate optional features:
Option 1. Search for “Optional features” directly from the taskbar’s search menu.
Option 2. Locate optional features in Windows System settings. To do this:
Select Start (or the Windows icon on your keyboard or the taskbar).
Select the Settings app to open it.
Select the System tab.
Locate and select Optional features toward the bottom of all system features.
Install and manage WMIC FoD
From the Optional features menu, you’re ready to view, install, uninstall, and manage FoDs like WMIC. Not sure if WMIC is already installed? Search through or sort the Installed features section to find WMIC.
If WMIC is already one of your optional features, you’ll see it in the list of Installed features with an option to Uninstall or Remove it.
If WMIC isn’t on the list of Installed features, you can easily add it by taking these steps:
At the top of the Optional features tab, locate Add an optional feature.
In that field, select View features. This will open a pop-up window.
In the pop-up window to Add an optional feature, type “WMIC” into the search box.
When WMIC appears in the results below, select it by checking the box next to it. (Note: WMIC will not appear in the results if it’s already installed.)
Select Next to install WMIC feature in the same pop-up window.
You should now see WMIC among your features in Windows Settings > System > Optional features > Installed features. That’s also where you can uninstall it when you’ve migrated to PowerShell or other supported solutions.
Ready for the next steps in WMIC deprecation?
As we’ve previously announced, the next step in WMIC deprecation is coming later this year. WMIC will be disabled by default on the next version of Windows 11 and Windows Server.
Please refer to the following documentation for more guidance and examples:
WMI command line (WMIC) utility deprecation: Next steps
Using WMI – Win32 apps
Creating WMI Clients – Win32 apps
Creating a WMI Application or Script – Win32 apps
Creating a WMI Application Using C++ – Win32 apps
WMI C++ Application Examples – Win32 apps
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
black screen after wake up from sleep or hibernate
win11 newest beta version, before reinstall whole system works fine.
But after reinstall, schedule to sleep then wake up get black screen. HDD works a while then auto hibernate.
click mouse or keyboard when black screen can back to lockscreen.
googled whole 3 days unable to work out.
win11 newest beta version, before reinstall whole system works fine.But after reinstall, schedule to sleep then wake up get black screen. HDD works a while then auto hibernate.click mouse or keyboard when black screen can back to lockscreen.googled whole 3 days unable to work out. Read More
How to embed Microsoft Teams into my own Electron application
Dear all,
I am currently working on an Electron application to integrate Microsoft Teams into it. I want to provide users with the ability to access Microsoft Teams meeting directly from within the Electron app with customized UI and Microsoft Teams meeting experience.
I have done some research and found a few potential approaches, such as using an iframe to embed the Teams web client or leveraging the Microsoft Graph API. However, I’m not entirely sure which method would be the most effective and if there are any specific considerations or limitations I should be aware of, also not sure how to handle the user authorization.
Has anyone here successfully embedded Microsoft Teams into an Electron application? If so, could you please share your approach, any challenges you faced, and how you resolved them? Additionally, any code snippets or resources would be greatly appreciated.
Thank you in advance for your help!
Sincerely,
James from Shared Studios
Dear all,I am currently working on an Electron application to integrate Microsoft Teams into it. I want to provide users with the ability to access Microsoft Teams meeting directly from within the Electron app with customized UI and Microsoft Teams meeting experience.I have done some research and found a few potential approaches, such as using an iframe to embed the Teams web client or leveraging the Microsoft Graph API. However, I’m not entirely sure which method would be the most effective and if there are any specific considerations or limitations I should be aware of, also not sure how to handle the user authorization.Has anyone here successfully embedded Microsoft Teams into an Electron application? If so, could you please share your approach, any challenges you faced, and how you resolved them? Additionally, any code snippets or resources would be greatly appreciated.Thank you in advance for your help!Sincerely,James from Shared Studios Read More
Outlook Mobile Continues to set Standard for Microsoft 365 Email Mobility
It’s common to be asked which is the best mobile email client for Exchange Online. My view is that Outlook Mobile is the only client to use (if possible). I know that this opinion is unpopular with devotees of clients like the Apple iOS mail client, but the simple facts are that Outlook mobile is more functional and better integrated into the Microsoft 365 ecosystem. That’s the defining factor for many.
https://office365itpros.com/2024/07/12/outlook-mobile-standard/
It’s common to be asked which is the best mobile email client for Exchange Online. My view is that Outlook Mobile is the only client to use (if possible). I know that this opinion is unpopular with devotees of clients like the Apple iOS mail client, but the simple facts are that Outlook mobile is more functional and better integrated into the Microsoft 365 ecosystem. That’s the defining factor for many.
https://office365itpros.com/2024/07/12/outlook-mobile-standard/ Read More
Now that I’ve secured approval for the Nonprofit Granted Offerings, what should be my next steps?
Now that you have been approved for the Nonprofit Granted Offerings, you may be eager to know what your next steps should be. It is a common question we hear: ‘What’s next?’ If you have successfully completed the eligibility process and received approval for our granted offerings, this blog is tailored just for you. Let us delve into how M365 serves as the gateway to the Microsoft ecosystem.
M365 goes beyond being a suite of productivity tools—it represents the gateway to a comprehensive ecosystem of interconnected solutions and endless opportunities. By embracing M365, organizations gain access to essential tools such as Microsoft Word, Excel, and Teams. More importantly, they integrate into a unified platform that offers cloud services, robust security features, collaborative capabilities, and advanced analytics.
This unified platform leverages robust cloud services, offering scalable storage and computing power to meet diverse organizational needs. It incorporates advanced security features, ensuring the protection of sensitive data and compliance with regulatory requirements. Additionally, M365 facilitates seamless collaboration among teams, enabling real-time communication, file sharing, and project management across various departments and locations.
|
Now that we understand how M365 serves as the foundational framework, let us explore how to get started with activating, assigning, or removing M365 licenses effectively.
Activate, assign, or remove your M365 licenses.
Accessing and assigning licenses for the first time:
In order to activate, assign, or remove your M365, we will need to start by accessing the Nonprofit Portal at https://nonprofit.microsoft.com/en-us/getting-started.
Once you have clicked on the link, you will need to sign into your account by clicking the “Sign in” button at the top right-hand corner of the screen.
To successfully sign in you will need to have your .onmicrosoft.com username handy and the password you used to create your Nonprofit Portal Account.
After signing in you will reach your nonprofit homepage. You will need to click on “I am looking for” at the top and select “M365.”
This will take you to a page titled, “Compare our Microsoft 365 Plans”, you will need to scroll to the bottom of the page and click the “admin portal” link under “(2) Activate your licenses.”
First, we are going to start by claiming your granted M365 Business Premium Licenses. To claim your licenses, expand the “Billing” dropdown on the far-left hand side and click on “Purchase Services.”
Scroll down to “Microsoft 365 Business Premium (Nonprofit Staffing Donation)” licenses. These licenses should say “Free.” Click on “Details” change the number of licenses from 1 to 10 and click, “Buy Now.”
You will be required to complete the Billing information and to invoice option before clicking the “Place your order” button. Once you have completed claiming the licenses, you will be directed to go back to the admin center.
To Add Users:
Now that we have claimed your M365 Business Premium Licenses, we will need to assign your licenses to your users.
To assign licenses, expand the “Users” dropdown on the left side of the page. Under Users, select “Active Users.”
On the next page, please click “Add a User” at the top of the page.
Once you click “Add a User” you will need to set up the basics by completing the user information.
Be sure that all three of the boxes are checked and that you email the user’s temporary credentials to their organization email address. Be sure you are NOT emailing it to your .onmicrosoft.com email address.
On the next screen you will assign licenses to your users by selecting the appropriate box for the product you wish to assign. Please note: As you check the box, the number of licenses available will decrease. Once you have assigned all licenses click “Next” at the bottom of the screen.
On the next screen, you will have the option to decide what roles you would like to assign the user. You have the option to select as many roles as you like. You can also understand what each role entails by clicking the “i icon” next to the role.
On the last screen, you will need to confirm that the information you entered is correct and click “Finish adding” at the bottom to finalize the adding of the user.
To remove a user:
Go to Users > Active users’ page
Select the box next to the name(s) of the user(s) you want to delete
Click “Delete User” at the top of the page
Please note” If needed, you can restore deleted users, and recover their data with the exception of calendar items and alias for up to 30 days from the deleted users list.
A few things to note while in the Admin Center:
To see what products you have previously claimed, you can click on “Billing” > “your products.”
Anytime you want to purchase or add new products, you will click on “Billing”> purchase services and select the appropriate tab under “view by category” of the product you wish to purchase.
Adding additional licenses/users in the future:
To add more licenses or users in the future, please follow these steps:
Go to Office.com and click on the Admin icon.
Select ‘Users’ to add new users or ‘Purchase Services’ to acquire additional licenses.”
Now that you have added users to your organization and assigned licenses, your team will be able to collaborate on work from multiple device types, across many different applications. Congratulations on taking the first step in your M365 journey!
Microsoft Tech Community – Latest Blogs –Read More
Increasing Security for SQL Server Enabled by Azure Arc
Back in November 2023, the least privileges deployment model was introduced as a public preview. After thorough testing, we are excited to announce that the least privileges deployment mode for SQL Server enabled by Azure Arc will be become automatically available in the coming months if your Azure Extension for SQL Server is on the June, 2024 release or later. Starting in the August release, if there are any new Azure Arc-enabled SQL Servers which are automatically onboarded, they it will come with least privileges enabled as the default. This blog covers the details about the least privilege mode and describes details of the configuration changes to the SQL Servers that will be Arc-enabled.
What is least privileges?
The least privilege principle states that accounts and applications should only have access to the data and operations required. Now, with SQL Server enabled by Azure Arc, you can run the agent extension service with least privileges to perform the required tasks as per your Arc configuration, thus satisfying any requirements you may have to run the Azure Extension for SQL Server in the most secure manner.
The Current Default State
For releases prior to the February 2024 release of the Arc extension for SQL Server, when you install the Azure Arc extension for SQL Server, the installation creates a server-level role in SQL Server called SQLArcExtensionServerRole and a database-level role called SQLArcExtensionUserRole. It then adds NT_AUTHORITYSYSTEM to each role while granting permissions to enable features required by Azure Arc.
In some enterprises, it is against policy to add NT AUTHORITYSYSTEM account to SQL Server roles even if it is scoped down to specific roles and permissions. If you are installing Azure Arc, you should make sure it abides by your organization’s IT policies. The least privilege mode has been designed to meet the permissions restrictions of such environments.
The Least Privilege Mode
This section describes the configuration changes made to Arc-enabled SQL Server when least privileges mode is deployed. In least privileges mode, SQL Server enabled by Azure Arc creates a new local Windows virtual account: NT ServiceSQLServerExtension.
This account is granted the minimum required privileges to run the Azure extension for SQL Server service on the Windows operating system and it only has access to folders and directories used for reading and storing configuration or writing logs. Additionally, it is granted permission to connect and query in SQL Server with a new login for that service account with the minimum permissions required by assigning that login to the SQLArcExtensionUserRole database-level roles.
Prerequisites for running least privilege
Windows Server 2012 or later
SQL Server 2012 or later
Linux is not supported today
How to Validate if Least Privilege is Enabled in Your Environment
Please reference the documentation to validate if least privileges is enabled for your SQL Server: https://learn.microsoft.com/en-us/sql/sql-server/azure-arc/configure-least-privilege?view=sql-server-ver16.
Where Can I Find Details on the Roles, Permissions and Files
For details on the permissions granted for the NT ServiceSQLServerExtension account, please reference this documentation link: https://learn.microsoft.com/en-us/sql/sql-server/azure-arc/configure-windows-accounts-agent?view=sql-server-ver16.
How will the Public Preview of Least Privileges Mode impact your current environment
We are automatically rolling out least privilege mode to all customers in the coming months. There is no action that you need to take to enable least privileges as it will be automatically enabled in the environment when deployed.
If you would like to see the log file for the changes that are occurring when least privileges is enabled,this is the deployer log file where least privileges logs are present: C:ProgramDataGuestConfigextension_logsMicrosoft.AzureData.WindowsAgent.SqlServer<extension_version>deployer.log
Can Least Privileges mode be disabled? How can I control deployment of least privileges mode?
If you would like to control when least privileges rolls out, you can block the extension upgrade to version 1.1.2717.190. If you do not block the extension upgrade, then least privileges will roll out automatically in your environment. Once least privileges is rolled out, it cannot be disabled. We are doing this to enhance security for all customers and do not recommend disabling the mode.
Nikita Takru
Product Manager at Microsoft, Azure Data
Microsoft Tech Community – Latest Blogs –Read More
User Authentication Method last used date
We have an issue with our users getting the latest iPhone and never notifying IT that they have turned in the old one. This means that the old device is still registered in our system as a valid MFA method for the user. I would like to run a script that would tell me per user, their MFA methods and the last time they used it, Or even better the last time that device checked in. The goal would be to delete any devices that have not been used or checked in for over a year as a starting point.
Running Get-MgBetaUserAuthenticationMethod -Userld $UserID I Select • -ExpandProperty AdditionalProperties
There is only Create date / Time not usage. Do I need to be looking anywhere else?
We have an issue with our users getting the latest iPhone and never notifying IT that they have turned in the old one. This means that the old device is still registered in our system as a valid MFA method for the user. I would like to run a script that would tell me per user, their MFA methods and the last time they used it, Or even better the last time that device checked in. The goal would be to delete any devices that have not been used or checked in for over a year as a starting point. Running Get-MgBetaUserAuthenticationMethod -Userld $UserID I Select • -ExpandProperty AdditionalProperties There is only Create date / Time not usage. Do I need to be looking anywhere else? Read More
Any Idea on How to Monetize Azure Stack HCI?
We’d love to hear your thoughts! Share your suggestions in the comments or join the live session to collaborate and discuss how to monetize Azure Stack HCI.
https://www.cloudassert.com/Resources/Webinar/monetize-your-azure-stack-hci-for-business-growth
We’d love to hear your thoughts! Share your suggestions in the comments or join the live session to collaborate and discuss how to monetize Azure Stack HCI. https://www.cloudassert.com/Resources/Webinar/monetize-your-azure-stack-hci-for-business-growth Read More
Has anyone ever done a refund check workflow?
Currently struggling with this. We currently have If Invoice:Balance Due < 0.00, then people within our org are sent an email notifying us that someone needs a refund/has requested a refund. This is to help avoid people overpaying on accident. The workflow starts when a record status changes, and it’s meant to be an automatic process. It’s running in the background as well.
Can anyone lend some assistance? TIA.
Addition: We are using classic workflow.
Currently struggling with this. We currently have If Invoice:Balance Due < 0.00, then people within our org are sent an email notifying us that someone needs a refund/has requested a refund. This is to help avoid people overpaying on accident. The workflow starts when a record status changes, and it’s meant to be an automatic process. It’s running in the background as well. Can anyone lend some assistance? TIA. Addition: We are using classic workflow. Read More
SQL job keeps failing!
I have a SQL where jobs keep failing due to index being already present.
[SQLSTATE 01000] (Message 50000) Creating CRM_CreateChangeCompany [SQLSTATE 01000] (Message 50000) if not exists (select * from [Replication].[SysIndexes] where name = ‘CRM_CreateChangeCompany’) begin create index CRM_CreateChangeCompany on [PROD_Replica].[dbo].[COMPANY] (CREATE_DATE, CHANGE_DATE, COMPANY_NO) exec LogMessage @procedure = ‘EnsureIndexExists’, @message = ‘Created Index CRM_CreateChangeCompany’ end
Any help and assistance would be great!
I have a SQL where jobs keep failing due to index being already present.[SQLSTATE 01000] (Message 50000) Creating CRM_CreateChangeCompany [SQLSTATE 01000] (Message 50000) if not exists (select * from [Replication].[SysIndexes] where name = ‘CRM_CreateChangeCompany’) begin create index CRM_CreateChangeCompany on [PROD_Replica].[dbo].[COMPANY] (CREATE_DATE, CHANGE_DATE, COMPANY_NO) exec LogMessage @procedure = ‘EnsureIndexExists’, @message = ‘Created Index CRM_CreateChangeCompany’ end Any help and assistance would be great! Read More
Change Primary Key/Title Column in SharePoint List
Hello!
I was wondering if it’s possible to change the primary key/title column in a SharePoint list. When I made the list I renamed this default title column to another name but I was unaware that it would be used as the identifying column in the list. This is giving me issues because when users search for an item in the list in a SharePoint site, the name of the entry that pops up is this title column – which I’m presuming is because it is the primary key column – but I would like it to show another field instead. See in the attached image: the blue text is the value of the title column but it is not a very efficient identifier for users performing the search.
Thus, the only way I can think of fixing my issue is by switching the column that SharePoint considers the title/primary column. Or if I hide this column, would the value that appears in the blue text be different?
Hello! I was wondering if it’s possible to change the primary key/title column in a SharePoint list. When I made the list I renamed this default title column to another name but I was unaware that it would be used as the identifying column in the list. This is giving me issues because when users search for an item in the list in a SharePoint site, the name of the entry that pops up is this title column – which I’m presuming is because it is the primary key column – but I would like it to show another field instead. See in the attached image: the blue text is the value of the title column but it is not a very efficient identifier for users performing the search. Thus, the only way I can think of fixing my issue is by switching the column that SharePoint considers the title/primary column. Or if I hide this column, would the value that appears in the blue text be different? Read More
ctfmon.exe – System error
Upon booting into safe mode on my machine I’m getting a pop up box error reading:
ctfmon.exe – System error
The system detected an overrun of a stack-based buffer in this application. This overrun could potentially allow a malicious user to gain control of this application.
My current OS version is 23H2 Build 22631.3880
Has anyone else encountered this error recently?
Upon booting into safe mode on my machine I’m getting a pop up box error reading:ctfmon.exe – System errorThe system detected an overrun of a stack-based buffer in this application. This overrun could potentially allow a malicious user to gain control of this application.My current OS version is 23H2 Build 22631.3880Has anyone else encountered this error recently? Read More
emails going straight to recover items in deleted folder
i have been having this problem for months. certain emails go straight to my deleted/deleted folder (the recovery folder) as read. the only way to access this folder is from a computer browser. i have listed emails as safe and added to contact list and it still happens. three chats with microsoft support brought me here. i am beyond annoyed and frustrated!
i have been having this problem for months. certain emails go straight to my deleted/deleted folder (the recovery folder) as read. the only way to access this folder is from a computer browser. i have listed emails as safe and added to contact list and it still happens. three chats with microsoft support brought me here. i am beyond annoyed and frustrated! Read More
Integrating Logic App with Semantic Kernel: A Detailed Guide and Demo
Overview
Microsoft Tech Community – Latest Blogs –Read More
Prioritizing circular If statements?
When creating an amortization table in Excel I tried to place conditions on two of my columns using IF statements to return values based on other columns. When placing the second condition which involves the value of the cell of the first IF statement, I got a warning about a circular reference. This was fine as that’s what I needed it to do so I turned on allow multiple iterations. Now I get values returned but it completes the second IF statement before the first causing the first statement to return true when it should be returning false in turn messing up my numbers. I tried managing rules under conditional formatting but nothing showed up, I also tried rearranging my values to no avail. I believe my logic is sound and I would like to try and use this method, so I’m wondering is there a way to prioritize one IF statement over the other or will I need to find another way to achieve this.
When creating an amortization table in Excel I tried to place conditions on two of my columns using IF statements to return values based on other columns. When placing the second condition which involves the value of the cell of the first IF statement, I got a warning about a circular reference. This was fine as that’s what I needed it to do so I turned on allow multiple iterations. Now I get values returned but it completes the second IF statement before the first causing the first statement to return true when it should be returning false in turn messing up my numbers. I tried managing rules under conditional formatting but nothing showed up, I also tried rearranging my values to no avail. I believe my logic is sound and I would like to try and use this method, so I’m wondering is there a way to prioritize one IF statement over the other or will I need to find another way to achieve this. Read More
getpivotdata to fill out table
I am trying to use the numbers on the right as a key to get the value from the matching “Dinstinct Count of Rma Number” in the pivot table. I am not sure about how to use this function and the videos I have watched have not helped. I also want it to output a zero, but I should be able to do that with an isna()
Here are the pivot table fields if that helps.
Any help would be appreciated.
I am trying to use the numbers on the right as a key to get the value from the matching “Dinstinct Count of Rma Number” in the pivot table. I am not sure about how to use this function and the videos I have watched have not helped. I also want it to output a zero, but I should be able to do that with an isna()Here are the pivot table fields if that helps.Any help would be appreciated. Read More
Windows 11 blocks
Hello everybody. I have a very strange problem. Till yesterday my laptop with Windows 11 worked well but today all is blocking. I do not know if I give some command with the keyboard but suddenly I have a black screenshot. I shut PC off and then on but from this point on I can work only with CTRL key pressed down : if I leave this key a black screenshot reappear and my PC goes off. Restarting is quite normal but very soon black screenshot again and so on. I can work normally only if I press down the CTRL key. Maybe somethig goes wrong during power on ? Maybe the start configuration is corrupted ? May be my PC has some cruel hardware problem ? Could someone help me in solving this awful problem ?
Thank you in advace Jerry
Hello everybody. I have a very strange problem. Till yesterday my laptop with Windows 11 worked well but today all is blocking. I do not know if I give some command with the keyboard but suddenly I have a black screenshot. I shut PC off and then on but from this point on I can work only with CTRL key pressed down : if I leave this key a black screenshot reappear and my PC goes off. Restarting is quite normal but very soon black screenshot again and so on. I can work normally only if I press down the CTRL key. Maybe somethig goes wrong during power on ? Maybe the start configuration is corrupted ? May be my PC has some cruel hardware problem ? Could someone help me in solving this awful problem ?Thank you in advace Jerry Read More
Rule of thumb for number of champions
Wondering if anyone uses or knows of a heuristic for determining the ideal number of champions for Teams adoption or any other app. I assume number of users would be the denominator. Maybe nuances like use cases and scenarios for Teams use come into play. Would appreciate any thoughts on this.
Wondering if anyone uses or knows of a heuristic for determining the ideal number of champions for Teams adoption or any other app. I assume number of users would be the denominator. Maybe nuances like use cases and scenarios for Teams use come into play. Would appreciate any thoughts on this. Read More