Tag Archives: microsoft
API cant find my list
I keep getting the below error when trying to use the API.
The list exists.
What Am i doing wrong? Im trying to follw a guide on how to export the Image columns to a word template and I cant get past the API section.
I keep getting the below error when trying to use the API. The list exists. What Am i doing wrong? Im trying to follw a guide on how to export the Image columns to a word template and I cant get past the API section. Read More
Wireless Gaming Headset Sounds Bad
I have a Razer Blackshark V2 BT headset, and it comes with 2 operating modes. In Razer’s Hyperspeed wireless, with included USB dongle, everything works fine. It sounds good and I am able to use the microphone. However, when I use bluetooth mode, Windows recognizes my device as a “headset” instead of “headphones,” causing the sound to change and become much worse. I know about disabling “handsfree telephony” in device manager to disable the microphone, which reverts the sound, but I need to use the mic. How do I fool Windows into giving me the proper “headphones” sound without disabling the microphone? I have already disabled sound enhancements, reconnected the device, updated drivers, and restarted my computer.
I have a Razer Blackshark V2 BT headset, and it comes with 2 operating modes. In Razer’s Hyperspeed wireless, with included USB dongle, everything works fine. It sounds good and I am able to use the microphone. However, when I use bluetooth mode, Windows recognizes my device as a “headset” instead of “headphones,” causing the sound to change and become much worse. I know about disabling “handsfree telephony” in device manager to disable the microphone, which reverts the sound, but I need to use the mic. How do I fool Windows into giving me the proper “headphones” sound without disabling the microphone? I have already disabled sound enhancements, reconnected the device, updated drivers, and restarted my computer. Read More
Run as admin on intune devices – role
Hi all,
What role can I give a user if we want to allow them to be able to run as admin on intune managed devices without giving global admin?
Hi all, What role can I give a user if we want to allow them to be able to run as admin on intune managed devices without giving global admin? Read More
What causes the QuickBooks abort error and how can it be resolved effectively?
I encountered a ‘QuickBooks abort error’ while working on my accounting tasks. What could be causing this issue, and how can I resolve it? I need a comprehensive guide to troubleshoot this problem effectively.
I encountered a ‘QuickBooks abort error’ while working on my accounting tasks. What could be causing this issue, and how can I resolve it? I need a comprehensive guide to troubleshoot this problem effectively. Read More
Solve QuickBooks Desktop 2022 won’t Open After Update?
I’ve been using QuickBooks Desktop 2022 without any issues, but recently it won’t open at all. Every time I try to launch it, nothing happens or it freezes on the loading screen. I’ve tried restarting my computer and ensuring all updates are installed, but the problem persists. Can anyone help me troubleshoot this issue?
I’ve been using QuickBooks Desktop 2022 without any issues, but recently it won’t open at all. Every time I try to launch it, nothing happens or it freezes on the loading screen. I’ve tried restarting my computer and ensuring all updates are installed, but the problem persists. Can anyone help me troubleshoot this issue? Read More
How to Fix QuickBooks Not Responding When Opening Company File?
I’m encountering an issue with QuickBooks Not Responding When Opening Company File. It’s causing delays in my work. What could be causing this problem, and how can I troubleshoot it to get QuickBooks running smoothly again?
I’m encountering an issue with QuickBooks Not Responding When Opening Company File. It’s causing delays in my work. What could be causing this problem, and how can I troubleshoot it to get QuickBooks running smoothly again? Read More
European Union Lines up Anti-Trust Charges Against Microsoft Over Teams
The Financial Times reported that the EU is lining up new charges against Microsoft for Teams anti-competive behavior. Given that Microsoft has already unbundled Teams from Office 365 products, it’s hard to know what remedy the EU will seek. If it’s a fine, then Microsoft could be charged up to 10% of their worldwide revenues. That’s unlikely, but the issue highlights how hard it is to compete against an integrated solution.
https://office365itpros.com/2024/05/20/teams-anti-competitive-complaints/
The Financial Times reported that the EU is lining up new charges against Microsoft for Teams anti-competive behavior. Given that Microsoft has already unbundled Teams from Office 365 products, it’s hard to know what remedy the EU will seek. If it’s a fine, then Microsoft could be charged up to 10% of their worldwide revenues. That’s unlikely, but the issue highlights how hard it is to compete against an integrated solution.
https://office365itpros.com/2024/05/20/teams-anti-competitive-complaints/ Read More
How to resolve QuickBooks cannot send invoice in quickbooks desktop?
I’m encountering an issue in QuickBooks cannot send invoice in quickbooks desktop. Every time I try, it fails. What could be causing this problem, and how can I fix it?
I’m encountering an issue in QuickBooks cannot send invoice in quickbooks desktop. Every time I try, it fails. What could be causing this problem, and how can I fix it? Read More
What to do when can’t open your company file in QuickBooks Desktop?
I’m encountering an issue where I Can’t Open Your Company File in QuickBooks Desktop. Every time I try, I get an error message. What could be causing this problem, and how can I resolve it?
I’m encountering an issue where I Can’t Open Your Company File in QuickBooks Desktop. Every time I try, I get an error message. What could be causing this problem, and how can I resolve it? Read More
Add timezone names on top in outlook calender
I think adding the timezone names on the top will be much more helpful.. #microsoft #outlook #Calender #timezone
I think adding the timezone names on the top will be much more helpful.. #microsoft #outlook #Calender #timezone Read More
Optimizing Cloud Management: Leveraging Azure Update Manager with Pre and Post Events
Introduction
As Azure Update Manager becomes the go-to solution for patching Azure VMs, it’s crucial to integrate efficient pre and post tasks to enhance reliability and control. This blog outlines a systematic approach to setting up these tasks, starting with initiating specific VMs based on their tags, and creating snapshots of the OS disk before updates. This preemptive measure ensures that if updates cause issues, restoring the system is straightforward and quick. Additional tasks will be integrated as needed to adapt to evolving requirements.
Requirements
To effectively implement the steps outlined, you should have:
A good understanding of Azure Automation Account.
An active Azure Automation Account.
A basic understanding of Runbooks and PowerShell.
Familiarity with Azure Update Manager and its functionalities.
Steps to Implement Pre and Post Events in Azure Update Manager
1. Set Up Maintenance Configuration Schedules: Start by configuring the maintenance schedules within Azure Update Manager to define when the updates should occur. Below a very basic example of how I set up mine.
2. Import Runbooks into Azure Automation Account: Import the necessary runbooks into your Azure Automation Account. These runbooks will automate the pre and post tasks.
You can find the runbooks in this Git Repo –> UpdateManagerStartSnapshotPatch
3. Create Webhooks for Runbooks: Establish webhooks for each runbook. These webhooks provide a way to trigger runbooks externally, facilitating seamless automation during the update process. As you can see in below screenshots I use a tag called Patch with a value of Yes to let the script know which servers to patch. Feel free to make any changes as required.
EXAMPLE OF MY VM TAGS
4. Establish an Event Grid System Topic: Set up an Event Grid System Topic, which will serve as the central hub for managing event notifications related to the update processes.
Subscribe to the Event Grid Topic: The subscription will automatically be created for you upon completion of the previous steps. We can also come back here to view how many times the event has fired.
If everything was setup correctly you will be able to view how many times the event has occured. Please see below example from one of the other schedules.
I hope this article could provide some guidance on how to use the pre and post actions for Azure Update Management.
Disclaimer
The sample scripts are not supported under any Microsoft standard support program or service. The sample scripts or Power BI Dashboards are provided AS IS without warranty of any kind. Microsoft further disclaims all implied warranties including, without limitation, any implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample scripts and documentation remains with you. In no event shall Microsoft, its authors, or anyone else involved in the creation, production, or delivery of the scripts or Power BI Dashboards be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample scripts or documentation, even if Microsoft has been advised of the possibility of such damages. This blog post was written with the help of generative AI.
Microsoft Tech Community – Latest Blogs –Read More
How useful are the top 10 most popular Excel functions
On the official Microsoft website covering every single function in Excel, they have a list of the 10 most popular Excel functions: https://support.microsoft.com/en-gb/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb
They are: SUM, IF, LOOKUP, VLOOKUP, MATCH, CHOOSE, DATE, DAYS, FOND & INDEX.
Here’s what they do.
SUM: Adds all the numbers in a range of cells. For example, =SUM(A1:A10) calculates the total of values from A1 to A10.
IF: Performs a logical test and returns one value if the test is true and another if it is false. For example, =IF(A1>B1, “Over Budget”, “OK”) checks if A1 is greater than B1 and returns “Over Budget” if true, otherwise “OK”.
LOOKUP: Searches for a value in a vector or array and returns a value from the same position in another vector or array. For example, =LOOKUP(4.19, A2:A6, B2:B6) looks for 4.19 in the range A2:A6 and returns the corresponding value from B2:B6
VLOOKUP: Searches for a value in the first column of a table and returns a value in the same row from a specified column. For example, =VLOOKUP(A1, B1:D10, 2, FALSE) looks for A1 in the first column of the range B1:D10 and returns the value in the second column of the found row.
MATCH: Searches for a specified value in a range and returns the relative position of that value within the range. For example, =MATCH(39, B1:B10, 0) returns the position of 39 in the range B1:B10.
CHOOSE: Returns a value from a list of values based on an index number. For example, =CHOOSE(2, “Apple”, “Banana”, “Cherry”) returns “Banana” because it is the second item in the list.
DATE: Creates a date from individual year, month, and day components. For example, =DATE(2024, 5, 20) returns the date May 20, 2024.
DAYS: Calculates the number of days between two dates. For example, =DAYS(“2024-12-31”, “2024-01-01”) returns 364.
FIND: Locates one string within another and returns the starting position of the found string. For example, =FIND(“e”, “Excel”) returns 1, since “e” is the first character in “Excel”.
INDEX: Returns the value of an element in a table or array, selected by the row and column number indexes. For example, =INDEX(A1:C10, 2, 3) returns the value in the second row and third column of the range A1:C10.
Here’s a video explanation on all of these functions, ranked based on how useful they are: https://www.youtube.com/watch?v=COVxc8e8AO4
I believe most of these functions are a bit outdated and more modern alternatives exists that are just a lot better, such as: XLOOKUP, SWITCH, TEXTAFTER, …
How often do you still use these functions? Do you think they still deserve to be the most popular ones?
On the official Microsoft website covering every single function in Excel, they have a list of the 10 most popular Excel functions: https://support.microsoft.com/en-gb/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb They are: SUM, IF, LOOKUP, VLOOKUP, MATCH, CHOOSE, DATE, DAYS, FOND & INDEX. Here’s what they do. SUM: Adds all the numbers in a range of cells. For example, =SUM(A1:A10) calculates the total of values from A1 to A10. IF: Performs a logical test and returns one value if the test is true and another if it is false. For example, =IF(A1>B1, “Over Budget”, “OK”) checks if A1 is greater than B1 and returns “Over Budget” if true, otherwise “OK”. LOOKUP: Searches for a value in a vector or array and returns a value from the same position in another vector or array. For example, =LOOKUP(4.19, A2:A6, B2:B6) looks for 4.19 in the range A2:A6 and returns the corresponding value from B2:B6 VLOOKUP: Searches for a value in the first column of a table and returns a value in the same row from a specified column. For example, =VLOOKUP(A1, B1:D10, 2, FALSE) looks for A1 in the first column of the range B1:D10 and returns the value in the second column of the found row. MATCH: Searches for a specified value in a range and returns the relative position of that value within the range. For example, =MATCH(39, B1:B10, 0) returns the position of 39 in the range B1:B10. CHOOSE: Returns a value from a list of values based on an index number. For example, =CHOOSE(2, “Apple”, “Banana”, “Cherry”) returns “Banana” because it is the second item in the list. DATE: Creates a date from individual year, month, and day components. For example, =DATE(2024, 5, 20) returns the date May 20, 2024. DAYS: Calculates the number of days between two dates. For example, =DAYS(“2024-12-31”, “2024-01-01”) returns 364. FIND: Locates one string within another and returns the starting position of the found string. For example, =FIND(“e”, “Excel”) returns 1, since “e” is the first character in “Excel”. INDEX: Returns the value of an element in a table or array, selected by the row and column number indexes. For example, =INDEX(A1:C10, 2, 3) returns the value in the second row and third column of the range A1:C10. Here’s a video explanation on all of these functions, ranked based on how useful they are: https://www.youtube.com/watch?v=COVxc8e8AO4 I believe most of these functions are a bit outdated and more modern alternatives exists that are just a lot better, such as: XLOOKUP, SWITCH, TEXTAFTER, … How often do you still use these functions? Do you think they still deserve to be the most popular ones? Read More
How To fix QuickBooks Web Connector Error QBWC1085
I’m encountering a QuickBooks Web Connector Error QBWC1085 issue. It says there’s a problem with the log file or a web service. How can I fix this error and ensure it doesn’t happen again?
I’m encountering a QuickBooks Web Connector Error QBWC1085 issue. It says there’s a problem with the log file or a web service. How can I fix this error and ensure it doesn’t happen again? Read More
Copilot for M365
i am using Microsoft 365 but nit getting the copilot option available.
i am using Microsoft 365 but nit getting the copilot option available. Read More
Adjusting position of sentence
Hi
I have used ‘Word’ to write some history. All of a sudden when I highlight a sentence that I want to have in ‘bold’, the whole document is put in ‘bold’. I then have use ‘undo’ to get my document as it was, then I find that the document is as I wanted, and the sentence is in ‘bold’.
The same happens whe I want to centralise a sentence. I highlight the words, and all the words in the document is centalised.
I ‘undo’ and the document is back as it should be and the words are centralised.
So annoying and time consuming. What has happened?
Thanks in advance.
Hi I have used ‘Word’ to write some history. All of a sudden when I highlight a sentence that I want to have in ‘bold’, the whole document is put in ‘bold’. I then have use ‘undo’ to get my document as it was, then I find that the document is as I wanted, and the sentence is in ‘bold’.The same happens whe I want to centralise a sentence. I highlight the words, and all the words in the document is centalised.I ‘undo’ and the document is back as it should be and the words are centralised. So annoying and time consuming. What has happened?Thanks in advance. Read More
How to Resolve QuickBooks American Express Not Syncing Issue
I’m having trouble with my QuickBooks account – it won’t sync with my American Express card. I keep getting error messages, and my transactions aren’t updating. How can I fix this issue?
I’m having trouble with my QuickBooks account – it won’t sync with my American Express card. I keep getting error messages, and my transactions aren’t updating. How can I fix this issue? Read More
Tips To Resolve QuickBooks administrator permissions needed on windows 11
I keep encountering a QuickBooks Administrator Permissions Needed error on my Windows 11 system, which prevents me from accessing certain features. How can I resolve this issue?
I keep encountering a QuickBooks Administrator Permissions Needed error on my Windows 11 system, which prevents me from accessing certain features. How can I resolve this issue? Read More
Error failed to save the network connectivity report
Unable to save the Microsoft 365 network connection scan report. error screenshot file attached. Can someone, help.
Unable to save the Microsoft 365 network connection scan report. error screenshot file attached. Can someone, help. Read More
What To Do When QuickBooks won’t Open without update?
I’ve been using QuickBooks for my small business accounting, but suddenly it won’t open on my computer. I’ve tried restarting my system and even reinstalling the software, but nothing seems to work. I’m getting frustrated because I need access to my financial data urgently. Can you provide a step-by-step troubleshooting guide to resolve the issue where QuickBooks won’t open?
I’ve been using QuickBooks for my small business accounting, but suddenly it won’t open on my computer. I’ve tried restarting my system and even reinstalling the software, but nothing seems to work. I’m getting frustrated because I need access to my financial data urgently. Can you provide a step-by-step troubleshooting guide to resolve the issue where QuickBooks won’t open? Read More
How can I resolve the issue of QuickBooks unable to backup company file?
I’m encountering an issue with QuickBooks unable to backup company file. Every time I try, it gives me an error message. What could be causing this problem, and how can I resolve it?
I’m encountering an issue with QuickBooks unable to backup company file. Every time I try, it gives me an error message. What could be causing this problem, and how can I resolve it? Read More