Tag Archives: microsoft
Excel Macro coding help
Im new on this platform and I am trying to set up a new Excel document where I can transfer rows from one table to another table if one column reads a particular word.
Can anyone help me?
Thanks in advance
Im new on this platform and I am trying to set up a new Excel document where I can transfer rows from one table to another table if one column reads a particular word. Can anyone help me? Thanks in advance Read More
How to transcribe a Windows Media Player audio file to text in Word
Hello, I work for a company in which it would be extremely valuable to be able to transcribe voicemail messages from my Avaya IP phone to text. The I.T. department says these phones do not have this ability. However, I know the voicemail messages can be converted to a Windows Media player audio file, and that file can be emailed to an employee. I’m wondering if anyone has step by step instructions for converting a Windows Media Player audio file to transcribed text ???
That would be so helpful! Thank you if you can offer any advice.
Hello, I work for a company in which it would be extremely valuable to be able to transcribe voicemail messages from my Avaya IP phone to text. The I.T. department says these phones do not have this ability. However, I know the voicemail messages can be converted to a Windows Media player audio file, and that file can be emailed to an employee. I’m wondering if anyone has step by step instructions for converting a Windows Media Player audio file to transcribed text ???That would be so helpful! Thank you if you can offer any advice. Read More
Permissions per person in sharepoint
Hello, I hope you are well.
I would like to know if there is a way to see all the permissions a person has on all sites, folders, lists, etc. in sharepoint, without having to go site by site looking at that person’s permissions.
I hope I have explained myself and that you can help me! Thank you so much.
Hello, I hope you are well.I would like to know if there is a way to see all the permissions a person has on all sites, folders, lists, etc. in sharepoint, without having to go site by site looking at that person’s permissions.I hope I have explained myself and that you can help me! Thank you so much. Read More
Accessibility checker doesn’t recognize my custom heading styles
I’ve recently reformatted a large document and applied custom heading styles throughout. I was able to generate a TOC just fine, but the accessibility checker tells me that there are no headings in the document. Any ideas as to why?
I do not want to use the built-in styles for this document. I created new styles because I want a completely different look than the built-in styles. The document also includes a custom multi-level list where each level is already associated with the custom styles I created. Any help would be appreciated!
I’ve recently reformatted a large document and applied custom heading styles throughout. I was able to generate a TOC just fine, but the accessibility checker tells me that there are no headings in the document. Any ideas as to why? I do not want to use the built-in styles for this document. I created new styles because I want a completely different look than the built-in styles. The document also includes a custom multi-level list where each level is already associated with the custom styles I created. Any help would be appreciated! Read More
“None” option missing from Teams background options
Hi,
Our teams “none” background option is missing. Forcing users to use a background or the blur backgrounds.
I have tried to revert back to classic teams to see if that is a fix, but I am unable to toggle it off and it takes me to download the classic teams which is just the new teams download.
We are not disabling this option as an organization.
Hi, Our teams “none” background option is missing. Forcing users to use a background or the blur backgrounds. I have tried to revert back to classic teams to see if that is a fix, but I am unable to toggle it off and it takes me to download the classic teams which is just the new teams download. We are not disabling this option as an organization. Read More
Why are my Adobe preferences saving to my One Drive – Documents folder?
Hey there,
I have a basic one drive account. I don’t really need it but I like having the option of backing certain things up if need be, so don’t want to disable it. You can see in the screenshot below, there’s a bunch of media encoder files in the “Documents” folder of my Personal one drive. Anyone know why this is? It seems like One Drive is hi-jacking my main C: Documents folder for whatever reason. Feel like it’s forcing me to upgrade when I don’t want to.
Hey there,I have a basic one drive account. I don’t really need it but I like having the option of backing certain things up if need be, so don’t want to disable it. You can see in the screenshot below, there’s a bunch of media encoder files in the “Documents” folder of my Personal one drive. Anyone know why this is? It seems like One Drive is hi-jacking my main C: Documents folder for whatever reason. Feel like it’s forcing me to upgrade when I don’t want to. Read More
Find and replace multiple update in same colum
Ho I can find and replace of costallow, Monthly and share of column-Add_code_claculation using SELECT command. I want to update costallow to 10, Monthly to 15 and Share to 30 using find and replace function using SELECT or any other function to get the expected result.
Create table #ABC ( Tid char(10), Add_code_Calculation varchar(255))
insert into #ABC values (’11’,'(A+B+C)/(costallow * Monthly – Share)’
Expected result:
Tid Add_code_Calculation
11 (A+B+C)/(10 * 15 – 30)
Ho I can find and replace of costallow, Monthly and share of column-Add_code_claculation using SELECT command. I want to update costallow to 10, Monthly to 15 and Share to 30 using find and replace function using SELECT or any other function to get the expected result. Create table #ABC ( Tid char(10), Add_code_Calculation varchar(255))insert into #ABC values (’11’,'(A+B+C)/(costallow * Monthly – Share)’ Expected result:Tid Add_code_Calculation11 (A+B+C)/(10 * 15 – 30) Read More
JSON Type & Aggregates Public Preview in Azure SQL Database | Data Exposed
The native JSON type allows JSON documents to be stored in a binary format. This binary format allows for efficient query processing and in-place modifications of JSON documents. The JSON aggregates – JSON_OBJECTAGG & JSON_ARRAYAGG enable easy aggregation of relational data into a JSON document. Learn more in this episode of Data Exposed with Anna Hoffman and Umachandar Jayachandran.
Resources:
JSON data type (preview) – SQL Server | Microsoft Learn
JSON_OBJECTAGG (Transact-SQL) – SQL Server | Microsoft Learn
JSON_ARRAYAGG (Transact-SQL) – SQL Server | Microsoft Learn
View/share our latest episodes on Microsoft Learn and YouTube!
Microsoft Tech Community – Latest Blogs –Read More
Event Planner Template no longer macro enabled
I used this Event Planner template last year to create a custom October to September department calendar. The current version of the template is only for 2024. This template does not have any macros or fields. It no longer allows me to create a custom calendar.
I still have the old calendar and it apparently uses Document Variable Fields but the set start date macro has disappeared. Does anyone know how to turn the calendar update controls back on, or update the document variables manually, or get a macro enabled version of the template?
Template URL: https://create.microsoft.com/en-us/template/event-planner-3b23a074-fdbd-4280-8ebd-852016c1bb60
I used this Event Planner template last year to create a custom October to September department calendar. The current version of the template is only for 2024. This template does not have any macros or fields. It no longer allows me to create a custom calendar. I still have the old calendar and it apparently uses Document Variable Fields but the set start date macro has disappeared. Does anyone know how to turn the calendar update controls back on, or update the document variables manually, or get a macro enabled version of the template? Template URL: https://create.microsoft.com/en-us/template/event-planner-3b23a074-fdbd-4280-8ebd-852016c1bb60 Read More
Excel sharepoint formula
Hi, I need assistance with the “Bandwidth” tab, specifically cells B2
. In the “Raw Data” tab, if an employee’s name appears in column C, the formula for B2 should be 1 minus the sum of values in column D for that employee. For example, if Jeff has values 0.20 and 0.45 in the “Raw Data” tab, then in the “Bandwidth” tab, B2 should be calculated as 1 minus 0.20 plus 0.45.
https://ceridian.sharepoint.com/:x:/r/teams/MAUPayrollProject/_layouts/15/Doc.aspx?sourcedoc=%7B7af44531-abf9-49db-8450-d3b88165af8f%7D&action=edit&wdPreviousSession=47b9aa35-8172-d667-505d-c2e9b89d566d Hi, I need assistance with the “Bandwidth” tab, specifically cells B2. In the “Raw Data” tab, if an employee’s name appears in column C, the formula for B2 should be 1 minus the sum of values in column D for that employee. For example, if Jeff has values 0.20 and 0.45 in the “Raw Data” tab, then in the “Bandwidth” tab, B2 should be calculated as 1 minus 0.20 plus 0.45. Read More
Read only without a password.
Occasionally excel will make my spreadsheet a read-only, but I don’t do that. I have never created a password. How do I correct this issue? I have tried all such as F12, I’ve gone down to Tools to general options {but it prompts me to put in a password, I’ve never created a password.} Excel did this once before, and the same issues. I must edit this sheet. It also says notify the person, the person is me, that is trying to correct it. I had a co-worker go to his laptop, and try to get in that way, same thing. What gets me a password was never created. I need help please.
Occasionally excel will make my spreadsheet a read-only, but I don’t do that. I have never created a password. How do I correct this issue? I have tried all such as F12, I’ve gone down to Tools to general options {but it prompts me to put in a password, I’ve never created a password.} Excel did this once before, and the same issues. I must edit this sheet. It also says notify the person, the person is me, that is trying to correct it. I had a co-worker go to his laptop, and try to get in that way, same thing. What gets me a password was never created. I need help please. Read More
How to create a workbook where the master data filters to a specific worksheet
Hello, can anyone provide guidance on how to set up a housing verification workbook where the master list filters automatically to the specific housing community worksheet when entered?
Hello, can anyone provide guidance on how to set up a housing verification workbook where the master list filters automatically to the specific housing community worksheet when entered? Read More
How to set Different Backgrounds & Desktop icons Between Desktops in Windows 11
Hello,
I am trying to set my PC up so that it is easier to transition between work and personal activities. I read in several places online that this was doable via the Windows 11 task view tool (creating multiple desktops).
I have been able to set up different desktops with different apps running in each, but I cannot find a way to differentiate either the desktop backgrounds or the desktop shortcuts. Help appreciated.
Hello, I am trying to set my PC up so that it is easier to transition between work and personal activities. I read in several places online that this was doable via the Windows 11 task view tool (creating multiple desktops).I have been able to set up different desktops with different apps running in each, but I cannot find a way to differentiate either the desktop backgrounds or the desktop shortcuts. Help appreciated. Read More
Video interactivity gets a boost with new Microsoft Stream features
If videos are a part of your marketing strategy – and they should be – you’ll be happy to know that Microsoft Stream has just rolled out several new features to help you boost your content. We’ve put a summary of Stream’s new capabilities below.
Creating useful and compelling video content is a difficult task if you’re creating from scratch. Fortunately, with Microsoft Clipchamp and Stream, you’ve got an end-to-end video creation ecosystem already baked into your Microsoft 365 business license. Clipchamp became generally available to Microsoft 365 customers in 2023 and has already established itself as one of the most intuitive and powerful video editors on the market. Stream addresses the other half of the video experience: delivery. Stream is a powerful video management service that allows the people in your organization to store, share, and view your videos securely. Because it’s deeply integrated with the Microsoft 365 app portfolio, viewers can consume video content through multiple apps, like Microsoft PowerPoint, SharePoint, or Teams to name a few. And now we’ve added several new features to make the Stream experience even more engaging for users.
Copilot in Microsoft Stream
AI has arrived to make the video engagement experience enhanced for viewers. Copilot in Stream can help you get new insight into your videos. It can quickly summarize videos you’ve got stored on SharePoint so you can get the most out of your content. For example, you can have Copilot summarize a speaker’s comments to create a fast how-to list for an upcoming product demonstration. It’s an easy way to get the most out of every video you make. To use Copilot in Stream, you’ll need to purchase Copilot for Microsoft 365 for your business. Check out the following announcement to dive deep into Copilot in Stream use cases.
Microsoft 365 content callouts and interactivity analytics
Adding things like surveys, quizzes, or other forms of data gathering to your videos has always been difficult. Stream now makes adding such components easier and more effective. You can use Microsoft Forms and other links in callouts directly from your video. This lets your viewers search and find additional content easily from inside the Stream player. You’ll be able to see which callouts were the most effective using Stream’s new interactivity analytics. They let you gather non-personal data on your audience, like their responses to Microsoft Form polls or their average attention time. Metrics like these make it much easier to understand which of your videos and interactive elements landed the best and why.
Video reactions
Video reactions allow your audience to react to your content. You can enable reactions for the video, but you can also turn them into an interactive element that viewers can respond to several times as they go through the content. That gives you immediate feedback on how well your video landed and which parts were most effective. You can see reactions in the video’s Stream timeline, which lets you mark key reaction moments. Then you can use them as a best-practice reference when creating similar content in the future. Reactions can be used for individuals and teams, and viewers can choose to turn the feature off.
Stream video recordings in the new Outlook for Windows and Web
You can now integrate Stream video recording capabilities into Microsoft Outlook on the web and the new version of Outlook for Windows. You’ll be able to record a video message, capture your screen, or both, directly from Outlook. Screen recordings are great to highlight product demos, business reviews or improve your business culture.
These are just some of the new features that make Microsoft Stream an engaging video platform for your viewers. Whether you want to create, share, or interact with video content, Clipchamp and Stream have the features and integrations you need to tell your brand’s story.
Resources
Find the right Microsoft 365 business plan for your business.
Get Copilot for Microsoft 365 – Business Plans | Microsoft 365
Learn more about how to set up and use your Microsoft 365 subscription and find tips and templates to help you accomplish your business tasks.
Join the Microsoft SMB Tech Community to network with other professionals and business’ using Microsoft 365
Get free resources, tech training, and guidance to keep your business thriving and growing.
Partners can access training resources, customer decks and deployment checklists to do more with Microsoft 365.
Microsoft Tech Community – Latest Blogs –Read More
New UI messed up my list sections
All of a sudden overnight my json creating my list sections doesn’t work. Is this a result of the new UI? Do the sections just not work anymore?
{
“sections”: [
{
“displayname”: “Administration & Communication”,
“fields”: [
“Title”,
“Multiple Lines”,
“another column”,
“last column”,
“Choice column”
]
},
{
“displayname”: “”,
“fields”: [
“webex”
]
}
]
}
All of a sudden overnight my json creating my list sections doesn’t work. Is this a result of the new UI? Do the sections just not work anymore?{ “sections”: [ { “displayname”: “Administration & Communication”, “fields”: [ “Title”, “Multiple Lines”, “another column”, “last column”, “Choice column” ] }, { “displayname”: “”, “fields”: [ “webex” ] } ]} Read More
Event PlannerTemplate can no longer be customized
I used this Event Planner template last year to create a custom October to September department calendar. The current version of the template is only for 2024. This template does not have any macros or fields. It no longer allows me to create a custom calendar.
I still have the old calendar and it apparently uses Document Variable Fields but the set start date macro has disappeared. Does anyone know how to turn the calendar update controls back on or update the document variables?
Template URL: https://create.microsoft.com/en-us/template/event-planner-3b23a074-fdbd-4280-8ebd-852016c1bb60
I used this Event Planner template last year to create a custom October to September department calendar. The current version of the template is only for 2024. This template does not have any macros or fields. It no longer allows me to create a custom calendar. I still have the old calendar and it apparently uses Document Variable Fields but the set start date macro has disappeared. Does anyone know how to turn the calendar update controls back on or update the document variables? Template URL: https://create.microsoft.com/en-us/template/event-planner-3b23a074-fdbd-4280-8ebd-852016c1bb60 Read More
Lot of scans going to “queued” mode
We observed that lot of scans that are scheduled going to “queued” mode. Its not getting picked up and not moving further. We have to cancel these scans in order to run them again. Otherwise these are getting stayed in “queued” mode for ever.
We observed that lot of scans that are scheduled going to “queued” mode. Its not getting picked up and not moving further. We have to cancel these scans in order to run them again. Otherwise these are getting stayed in “queued” mode for ever. Read More
Recent Edge upgrades seem to clear saved cookies
Hello
I noticed that recent Edge upgrades seem to clear all cookies which cause to reenter all saved logging informaion in various websites. That’s quite annoying.
Is there any setting that changed or something to be done to avoid this please?
Many thanks for advice
Best regards
HelloI noticed that recent Edge upgrades seem to clear all cookies which cause to reenter all saved logging informaion in various websites. That’s quite annoying. Is there any setting that changed or something to be done to avoid this please?Many thanks for adviceBest regards Read More
PowerApps Form for SharePoint Dependent Fields
Hello all,
I’m very new to PowerApps; just started yesterday kind of new. I was hoping the solve would be simple but I’ve been going down the rabbit hole of solutions for hours now and I’m no closer to fixing the issue.
I’ve built a form starting from my SharePoint list page and and choosing PowerApps from the Integrate menu. The form has pulled all of the fields correctly. The form is only to submit new items and I have it defaulted to “New” for the mode. Nearly every field is restricted to numbers only.
My problem is that I want certain fields to only show if there is a value input in another field while the user is filling out the form. IsBlank and =0 are not working for me. I’ve been reading that the number restriction can cause issues for this function and I am hoping for some assistance.
I want “Cold Calling Contacts” and “Cold Calling Installs” to only show if a number greater than 0 is entered into “Hours Spent Cold Calling”.
Any help is greatly appreciated.
Hello all,I’m very new to PowerApps; just started yesterday kind of new. I was hoping the solve would be simple but I’ve been going down the rabbit hole of solutions for hours now and I’m no closer to fixing the issue. I’ve built a form starting from my SharePoint list page and and choosing PowerApps from the Integrate menu. The form has pulled all of the fields correctly. The form is only to submit new items and I have it defaulted to “New” for the mode. Nearly every field is restricted to numbers only. My problem is that I want certain fields to only show if there is a value input in another field while the user is filling out the form. IsBlank and =0 are not working for me. I’ve been reading that the number restriction can cause issues for this function and I am hoping for some assistance. I want “Cold Calling Contacts” and “Cold Calling Installs” to only show if a number greater than 0 is entered into “Hours Spent Cold Calling”.Any help is greatly appreciated. Read More
DNS.EXE Multiple UDP inbound connections on Windows
I am facing an issue regarding multiple open UDP connections on my Windows Server 2022. After running the netstat -an command in the command prompt, I noticed that there are a significant number of UDP ports listed. Apparently these ports are associated with the dns.exe process.
I am facing an issue regarding multiple open UDP connections on my Windows Server 2022. After running the netstat -an command in the command prompt, I noticed that there are a significant number of UDP ports listed. Apparently these ports are associated with the dns.exe process. Read More