Category: Microsoft
Category Archives: Microsoft
Powershell Script not running on Client
Hello,
I had created a powershell script in Endpoint Manager / Inutne.
But the script will not load and run a my Windows 10 test client. When I look on my test client i do not see the EnterpriseDesktopAppManagement CSP by Intune. I see only logs.
When I create a configuration policies it will push ( also apps) to the client.
What can I do to run ps scripts on the client via Intune?
Regards
Stefan
Hello,I had created a powershell script in Endpoint Manager / Inutne. But the script will not load and run a my Windows 10 test client. When I look on my test client i do not see the EnterpriseDesktopAppManagement CSP by Intune. I see only logs.When I create a configuration policies it will push ( also apps) to the client. What can I do to run ps scripts on the client via Intune? RegardsStefan Read More
SharePoint Doc link broken
One of my users links a URL to a SharePoint site, but this link gets encoded incorrectly, resulting in a broken link that removes some filters. The encoding for ‘%3F’ is being changed to ‘?’, which removes the filters from the link. Please guide me.
https://test1.constoso.com/[shortened]/list.do%3F
https://test1.constoso.com/[shortened]/list.do%?
One of my users links a URL to a SharePoint site, but this link gets encoded incorrectly, resulting in a broken link that removes some filters. The encoding for ‘%3F’ is being changed to ‘?’, which removes the filters from the link. Please guide me.https://test1.constoso.com/[shortened]/list.do%3Fhttps://test1.constoso.com/[shortened]/list.do%? Read More
Sum of subtotal cell from multiple workbooks
Hi Folks,
I do the invoicing for my wife’s physio business. I downloaded a simple invoice template and have been using this for the past few years.
On OneDrive, I have a directory with my wife’s business name and then sub-directories of years and within each year, months. So, for instance, a directory 2022, with all the months of the year Jan-Dec, and within each month a patient’s invoice for that month.
Each workbook contains a worksheet invoice with a cell in each worksheet containing the sum of the number of visits for that month in $. What I would like to do is add up all the subtotals for each patient for each month and a total for the year.
For example, 2022 would have directories of Jan to Dec, with a workbook containing an invoice worksheet for each patient. I would like to get a total of all the patients’ subtotals included in each monthly directory, and then a grand total for the year. So essentially, I am trying to sum one cell from one worksheet found in multiple workbooks.
I am not a power user so the easier the better even if it may not be the most efficient method. I just do not want to have to open up every workbook containing the invoice and manually add the subtotal of each patient’s charges.
Can this be done through a power query or macro. I am not very good with Excel but I am willing to give it a try.
Thanks!!
Best regards,
Rich
Hi Folks, I do the invoicing for my wife’s physio business. I downloaded a simple invoice template and have been using this for the past few years. On OneDrive, I have a directory with my wife’s business name and then sub-directories of years and within each year, months. So, for instance, a directory 2022, with all the months of the year Jan-Dec, and within each month a patient’s invoice for that month. Each workbook contains a worksheet invoice with a cell in each worksheet containing the sum of the number of visits for that month in $. What I would like to do is add up all the subtotals for each patient for each month and a total for the year. For example, 2022 would have directories of Jan to Dec, with a workbook containing an invoice worksheet for each patient. I would like to get a total of all the patients’ subtotals included in each monthly directory, and then a grand total for the year. So essentially, I am trying to sum one cell from one worksheet found in multiple workbooks. I am not a power user so the easier the better even if it may not be the most efficient method. I just do not want to have to open up every workbook containing the invoice and manually add the subtotal of each patient’s charges. Can this be done through a power query or macro. I am not very good with Excel but I am willing to give it a try. Thanks!! Best regards,Rich Read More
Captions in Word
I am trying to place a caption under Tables and Figures that include chapter numbers as follows: Figure 1.1, Figure 1.2, Figure 2.1. I follow all instructions but when I enter the caption it returns it as Figure 0.1, which means it is not picking up the chapter number. Since I am using custom headers that are not reflected in the Caption dialogue box, I go back and set up a new header style (Header 6) that is not used anywhere else in the document. Then when I apply that to the Chapter number header, it applies it to all section headers in the document. Anyone know what I am doing wrong?
I am trying to place a caption under Tables and Figures that include chapter numbers as follows: Figure 1.1, Figure 1.2, Figure 2.1. I follow all instructions but when I enter the caption it returns it as Figure 0.1, which means it is not picking up the chapter number. Since I am using custom headers that are not reflected in the Caption dialogue box, I go back and set up a new header style (Header 6) that is not used anywhere else in the document. Then when I apply that to the Chapter number header, it applies it to all section headers in the document. Anyone know what I am doing wrong? Read More
Laptop OneDrive files not visible on the desktop
I have one drive on my desktop, works fine. I have a laptop and it can see the OneDrive files from my desktop but when I add files from my laptop they show up in OneDrive on the laptop but are not visible from the desktop. I will quickly get my files out of sync at this rate. I want the files I modify or change on my laptop to be visible and up to date on my desktop. How do I fix this? Otherwise, I will need to move off OneDrive.
I have one drive on my desktop, works fine. I have a laptop and it can see the OneDrive files from my desktop but when I add files from my laptop they show up in OneDrive on the laptop but are not visible from the desktop. I will quickly get my files out of sync at this rate. I want the files I modify or change on my laptop to be visible and up to date on my desktop. How do I fix this? Otherwise, I will need to move off OneDrive. Read More
MY PROFILE ON OUTLOOK
Dear Friends and Cousins
My profile on Outlook.com email is going through a lot. I was trying to fix this. However. Women and their husbands/family got in my Account. These aliens DONT have **bleep** or Vegina. They cant be horny. Iam afraid. I have a Vegina just fine. I need my boyfriends. Fiancee. Family/Friends. Call me guys. However. Remove these aliens from California who DONT HAVE **bleep**/VEGINA.
From JULIA R. 40 YEARS OLD
Dear Friends and Cousins My profile on Outlook.com email is going through a lot. I was trying to fix this. However. Women and their husbands/family got in my Account. These aliens DONT have **bleep** or Vegina. They cant be horny. Iam afraid. I have a Vegina just fine. I need my boyfriends. Fiancee. Family/Friends. Call me guys. However. Remove these aliens from California who DONT HAVE **bleep**/VEGINA. From JULIA R. 40 YEARS OLD Read More
Scaling a Letter-size document to A4
I created a document using a tri-fold brochure template. Only when I printed did I realise it was a “Letter (8.5″ x 11” document) and I am printing on A4. When I change the page size to A4 it completely messes up my layouts and I spent hours trying to adjust them with no luck. It seems the template is made using multiple tables for the layout, as I couldn’t select the whole table to enlarge it. Is there an easy way to do this? Unfortunately I am printing wirelessly so I there’s nothing i can do in print settings
I created a document using a tri-fold brochure template. Only when I printed did I realise it was a “Letter (8.5″ x 11” document) and I am printing on A4. When I change the page size to A4 it completely messes up my layouts and I spent hours trying to adjust them with no luck. It seems the template is made using multiple tables for the layout, as I couldn’t select the whole table to enlarge it. Is there an easy way to do this? Unfortunately I am printing wirelessly so I there’s nothing i can do in print settings Read More
How to trim an mp3 file on Windows 11 in bulk?
Recently, I copied hundreds of songs in mp3 format from old CDs. Many of the mp3 files have very long duration and I am going to trim the mp3 file to get rip the useless prelude. I tried the Windows Media Player but it does not work. Hope someone could suggest a good way to bulk trim mp3 files on Windows 11?
Recently, I copied hundreds of songs in mp3 format from old CDs. Many of the mp3 files have very long duration and I am going to trim the mp3 file to get rip the useless prelude. I tried the Windows Media Player but it does not work. Hope someone could suggest a good way to bulk trim mp3 files on Windows 11? Read More
Best Way to bulk rename files on Windows 11?
When I transferred my photos on my Android phone to Windows 11, I found out the photos are named under the data plus a set of random digits. I NEED to bulk rename the files on Windows 11. Can the Photos app is able to rename files in bulk? It could be so boring to rename it one by one.
Thanks
When I transferred my photos on my Android phone to Windows 11, I found out the photos are named under the data plus a set of random digits. I NEED to bulk rename the files on Windows 11. Can the Photos app is able to rename files in bulk? It could be so boring to rename it one by one. Thanks Read More
Blue Screen w/no response from the settings menu, and all functionality not responding.
The systems been active for 2.5 hrs., when I selected “system” from the task bar, the display was blue textured with vertical lines, the entire display on Lenovo:
Edition Windows 11 Home
Version 23H2
Installed on 2/20/2024
OS build 22631.3593
Serial number PF22E7GD
Experience Windows Feature Experience Pack 1000.22700.1003.0
The systems been active for 2.5 hrs., when I selected “system” from the task bar, the display was blue textured with vertical lines, the entire display on Lenovo:Edition Windows 11 HomeVersion 23H2Installed on 2/20/2024OS build 22631.3593Serial number PF22E7GDExperience Windows Feature Experience Pack 1000.22700.1003.0 Read More
Allocating / Apportioning Challan Amounts to Different Receipts
The attached file contains three Tables
1. Challan : This table contains the data for the Tax deposited via Challan.
2. Receipts : This table contains the data for the Amounts received against which the tax has been deposited.
3. ChallanAllocation : This table contains the mapping (from Challan Table) of challan number and date to all the amounts (in the Receipts Table)
My Request involves creation of ChallanAllocation like Information in an automated way
Here one challan amount might be sufficient to cover multiple receipts
or
One receipt might be sufficient to cover multiple challans
Considering the Receipts Table as base We need to Map (allocate and / or apportion) the Challan amount to all the receipts on FIFO basis, without leaving any balance in challan, and create a new table (Structured Data Table or simple data range). We might need to split the single challan across various receipts OR split the single receipts across several challans and might need to ADD more rows to accommodate such splits.
Notes:
1. Challan date and Receipt Date need to be in ascending order, but Challan Date may be before or after the Receipt Date. I will enter the data in ascending order but appreciate if the proposed solution can sort the data based on ID and CIN Date / Receipt Date.
2. I have given data for only Two IDs (i.e., A01, A02) but there are multiple IDs for which Data is maintained in the same table.
3. Total Challan Amount and Total Receipt Amount is matching in case of A01 but might be different in other cases (like in A02). In case Total Challan Amount is MORE than the Total Receipt Amount, the balance can be ignored. But if the Challan Amount is LESS than the Receipt Amount, the additional row should appear with “Short” in CIN Column in ChallanAllocation Table (like in Cell Q49)
Any solution (VBA, non VBA) to solve this and create the desired data is EQUALLY appreciated.
As I am not very good in VBA, I am trying my best to find a Non VBA solution using Dynamic Array Functions, but I am struggling to add new rows automatically to the existing table.
In real scenario, I am going to use three different sheets (Challan, Receipts, ChallanAllocation) and will be copying the new data on the Challan and Receipts sheet, hoping that the solution will create the desired data in Sheet ChallanAllocation. Here for the sake of easy matching, I have kept the data on one sheet.
and to all the Esteemed Experts
The attached file contains three Tables1. Challan : This table contains the data for the Tax deposited via Challan.2. Receipts : This table contains the data for the Amounts received against which the tax has been deposited.3. ChallanAllocation : This table contains the mapping (from Challan Table) of challan number and date to all the amounts (in the Receipts Table) My Request involves creation of ChallanAllocation like Information in an automated way Here one challan amount might be sufficient to cover multiple receiptsorOne receipt might be sufficient to cover multiple challans Considering the Receipts Table as base We need to Map (allocate and / or apportion) the Challan amount to all the receipts on FIFO basis, without leaving any balance in challan, and create a new table (Structured Data Table or simple data range). We might need to split the single challan across various receipts OR split the single receipts across several challans and might need to ADD more rows to accommodate such splits. Notes:1. Challan date and Receipt Date need to be in ascending order, but Challan Date may be before or after the Receipt Date. I will enter the data in ascending order but appreciate if the proposed solution can sort the data based on ID and CIN Date / Receipt Date.2. I have given data for only Two IDs (i.e., A01, A02) but there are multiple IDs for which Data is maintained in the same table.3. Total Challan Amount and Total Receipt Amount is matching in case of A01 but might be different in other cases (like in A02). In case Total Challan Amount is MORE than the Total Receipt Amount, the balance can be ignored. But if the Challan Amount is LESS than the Receipt Amount, the additional row should appear with “Short” in CIN Column in ChallanAllocation Table (like in Cell Q49) Any solution (VBA, non VBA) to solve this and create the desired data is EQUALLY appreciated. As I am not very good in VBA, I am trying my best to find a Non VBA solution using Dynamic Array Functions, but I am struggling to add new rows automatically to the existing table. In real scenario, I am going to use three different sheets (Challan, Receipts, ChallanAllocation) and will be copying the new data on the Challan and Receipts sheet, hoping that the solution will create the desired data in Sheet ChallanAllocation. Here for the sake of easy matching, I have kept the data on one sheet.@Sergei Baklan@Peter Bartholomew@lori_m@Chris_Grossand to all the Esteemed Experts Read More
How can I send a message between steps
I have a python script to send email from SSIS, which reads the parameter as text and sends it. I’d like to be able to recognize what is the preceding step, instead of creating several repeated send email processes. Thanks!
I have a python script to send email from SSIS, which reads the parameter as text and sends it. I’d like to be able to recognize what is the preceding step, instead of creating several repeated send email processes. Thanks! Read More
Define Patch Approvals in WSUS but pull patches from Internet
We currently use WSUS to distribute Microsoft patches and also use Solarwinds Patch Manager to push 3rd party patches into WSUS. This allows us to fully patch an endpoint with all MS and 3rd party software patches via Windows Update Agent/WSUS. We now have a fleet of laptops connected back to our Datacenter via a VPN and they are consuming a lot of bandwith during patching cycles.
We have the following challanges:
We do use some throttling on BITS/Delivery opitmization but have had mixed resultsWe have MECM but don’t use Cloud Management gatway as was deemed too expensive. we have not moved patching to MECM yet.If we use Windows Update for Business we cannot patch 3rd party updates and loose some control around pilot groups and reporting in our estimation
Q: So is there a way for us to continue to define the approved patches/metadata via WSUS but have the system pull the patches files from the internet (Windows Update) source? Perhaps this is possible with MECM?
We currently use WSUS to distribute Microsoft patches and also use Solarwinds Patch Manager to push 3rd party patches into WSUS. This allows us to fully patch an endpoint with all MS and 3rd party software patches via Windows Update Agent/WSUS. We now have a fleet of laptops connected back to our Datacenter via a VPN and they are consuming a lot of bandwith during patching cycles.We have the following challanges: We do use some throttling on BITS/Delivery opitmization but have had mixed resultsWe have MECM but don’t use Cloud Management gatway as was deemed too expensive. we have not moved patching to MECM yet.If we use Windows Update for Business we cannot patch 3rd party updates and loose some control around pilot groups and reporting in our estimationQ: So is there a way for us to continue to define the approved patches/metadata via WSUS but have the system pull the patches files from the internet (Windows Update) source? Perhaps this is possible with MECM? Read More
Trying to pull specific data from spread sheet to a calendar
Hello,
I’m trying to figure out an easier way to populate specific data totals from a spread sheet to a calendar. i have made a spread sheet similar to what we use (excluding patient data of course). i have to keep track of the type of beds we are needing for each day, i made a calendar to help me at a glance to see the totals but now i am unsure of what formula i could use to total the bed types for each day. I’m sure it is an easy thing but my googling has failed me.
here is the calendar.
Hello,I’m trying to figure out an easier way to populate specific data totals from a spread sheet to a calendar. i have made a spread sheet similar to what we use (excluding patient data of course). i have to keep track of the type of beds we are needing for each day, i made a calendar to help me at a glance to see the totals but now i am unsure of what formula i could use to total the bed types for each day. I’m sure it is an easy thing but my googling has failed me. here is the calendar. Read More
Blank area in the cell when printing.
Row or line break turn to blank area in the cell when printing. Cell size changes from 5 lines to 4 lines and one blank row when printing.
Row or line break turn to blank area in the cell when printing. Cell size changes from 5 lines to 4 lines and one blank row when printing. Read More
Explore Cloud Computing with the New “Azure for Students” Module!
I’m really excited to share a new module that I developed by working with the Microsoft Learn Team: “Introduction to Azure for students.” As students, we often encounter numerous tech challenges, from managing projects and assignments to exploring new fields like AI and data science. This module is designed to help you tackle these challenges head-on by diving into the fascinating world of cloud computing with Azure.
Why Cloud Computing?
Cloud computing might sound complex, but it’s simpler than you think. Imagine it as a giant library where you can borrow books whenever you need them, without the hassle of buying or storing them. Similarly, cloud computing lets you use computing resources whenever you need them, without owning or maintaining the hardware and software. It’s flexible, easy, and often more affordable.
What You’ll Learn
In this module, you’ll discover:
Core Concepts of Cloud Computing: Learn the basics and understand what cloud computing is all about.
Azure in Action: Explore real-world scenarios to see how Azure is used in various fields, from student projects to professional healthcare.
Getting Started with Azure: Find out about the tools and services that will help you begin your Azure journey.
Why Azure Cloud?
Azure is Microsoft’s cloud platform, offering over 200 products and services. Whether you’re into AI, app development, data science, or machine learning, Azure has it all. Here’s how Azure can help you as a student:
Access Powerful Tools: Utilize advanced tools and services without the need for expensive hardware.
Scalability: Easily scale your resources up or down based on your project needs.
Cost-Effective: Pay only for the resources you use and take advantage of free services and a $100 Azure credit with the Azure for Students offer.
How Azure Can Help with College Projects?
Imagine you’re working on a complex college project that involves data analysis and collaboration with classmates. With Azure, you can set up a virtual environment where everyone can work together seamlessly, share resources, and analyze data in real-time. Need to develop a mobile app for your project? Azure provides all the necessary tools and platforms to build, test, and deploy your app efficiently.
Special Offer for Students!
Being a student usually means living on a budget. Good news—Microsoft’s got your back with Azure for Students! Get a $100 Azure credit and access a sea of free services. Learning has never been so cost-effective and fun! Learn more about the Azure for Students offer.
What are you waiting for? Start learning cloud today by going through the module with hands-on experience by claiming the Azure for Students offer. Whether you’re working on a school project, developing an app, or just curious about the cloud, this module will provide you with the foundation to succeed.
Ready to get started? Sign up on Microsoft Learn to save your progress and take the first step towards an exciting career in cloud computing!
Microsoft Tech Community – Latest Blogs –Read More
Removing duplicates and sorting data in columns instead of rows
Hello, one of our software exports data in the following format. I don’t want to touch this file since it will be exported frequently.
I want to create a different Excel file with formulas which is linked to this file and configure it in a way to obtain the results in the following way:
Basically removing the duplicates and sorting the data in columns and leaving blanks when nothing is found.
Thank you!
Hello, one of our software exports data in the following format. I don’t want to touch this file since it will be exported frequently.I want to create a different Excel file with formulas which is linked to this file and configure it in a way to obtain the results in the following way:Basically removing the duplicates and sorting the data in columns and leaving blanks when nothing is found.Thank you! Read More
Automatically replace old data with new data
Hello.
I am trying to create a sheet that averages the last 5 scores.
My idea is to have the input cell at A1, and the average cell at A7.
When a value is entered into A1, it appears in A2.
When a second value is entered into A1, it appears in A2 and the value in A2 moves to A3.
When a third value is entered into A1, it appears in A2, the value in A2 moves to A3 and the value in A3 moves to A4, and so on.
All the while, the value in A7 changes to represent the new mean.
Once A6 is full, a new A1 entry will cause the A6 number to disappear, as the value is now to old and no longer of any use.
Is this possible in excel?
Cheers
Hello. I am trying to create a sheet that averages the last 5 scores.My idea is to have the input cell at A1, and the average cell at A7.When a value is entered into A1, it appears in A2.When a second value is entered into A1, it appears in A2 and the value in A2 moves to A3.When a third value is entered into A1, it appears in A2, the value in A2 moves to A3 and the value in A3 moves to A4, and so on.All the while, the value in A7 changes to represent the new mean.Once A6 is full, a new A1 entry will cause the A6 number to disappear, as the value is now to old and no longer of any use.Is this possible in excel? Cheers Read More
Error – Your windows insider build ran into a problem and needs to restart . We will restart for you
please help me with this problem. I cannot open my laptop!
please help me with this problem. I cannot open my laptop! Read More