Category: Microsoft
Category Archives: Microsoft
Formatting Issues
Hello – I don’t know how, but I changed something in my document and now every time I type or try to delete i get red type with a line through it – wont let me delete or backspace to delete –
Hello – I don’t know how, but I changed something in my document and now every time I type or try to delete i get red type with a line through it – wont let me delete or backspace to delete – Read More
Latest Dev Update will not download. ISO will not install.
Windows Update reports an update is available (26060) but the download will not start. I also tried to use the ISO for the same version. When I run Setup, it starts, checks for updates and then just quits. Do I have to reset the current version to overcome this?
Windows Update reports an update is available (26060) but the download will not start. I also tried to use the ISO for the same version. When I run Setup, it starts, checks for updates and then just quits. Do I have to reset the current version to overcome this? Read More
Issue Converting (Date) HH:MM:SS to Minutes
Trying to convert HH:MM:SS to minutes
Some cells have dates not needed
See attached example
Thank you for your time
Trying to convert HH:MM:SS to minutesSome cells have dates not neededSee attached exampleThank you for your time Read More
Regression with a variable that has 20 different categories
I need to run a regression with a variable that has 20 different categories. I figured i could make a dummy with 20 different columns with 1 and 0. However when im running my regression i can only use 16 X variables. Does anyone know how i can fix this?
I need to run a regression with a variable that has 20 different categories. I figured i could make a dummy with 20 different columns with 1 and 0. However when im running my regression i can only use 16 X variables. Does anyone know how i can fix this? Read More
Automate Ribbon instead VBA script
Glad find useful resource where can share my best practices , in my case I had data present sr number , emp name , sales , order date , month, week and email id along with other fields untill BB column of excel now wish to see the data in pivot normally we use pivotable manually do a pivot in our excel for me find this call Automate ( Script ) loved to use this used below code find useful result
function main(workbook: ExcelScript.Workbook) {
// Define the range
let dataSheet = workbook.getActiveWorksheet();
let dataRange = dataSheet.getRange(“A1:BB50”);
// Read data into a 2D array
let dataArray = dataRange.getValues();
// Initialize variables for summary
let summary = {};
// Loop through the data to calculate sales by month
dataArray.forEach(row => {
let month = row[0]; // Assuming the month is in the first column
let sales = row[1]; // Assuming sales data is in the second column
if (!summary[month]) {
summary[month] = sales;
} else {
summary[month] += sales;
}
});
// Prepare the summary data for output
let summaryArray = [];
for (let month in summary) {
summaryArray.push([month, summary[month]]);
}
// Output the summary to a new worksheet
let summarySheet = workbook.addWorksheet(“Summary”);
let summaryRange = summarySheet.getRange(“A1:B” + (summaryArray.length + 1));
summary
Range.setValues(summaryArray);
}
If you want to leverage this automate script you can do this is available in my premium account of office 365 you can check :white_heavy_check_mark: yours if it’s available in ribbon :ribbon:
Please note – it’s not macro
Glad find useful resource where can share my best practices , in my case I had data present sr number , emp name , sales , order date , month, week and email id along with other fields untill BB column of excel now wish to see the data in pivot normally we use pivotable manually do a pivot in our excel for me find this call Automate ( Script ) loved to use this used below code find useful result function main(workbook: ExcelScript.Workbook) { // Define the range let dataSheet = workbook.getActiveWorksheet(); let dataRange = dataSheet.getRange(“A1:BB50”); // Read data into a 2D array let dataArray = dataRange.getValues(); // Initialize variables for summary let summary = {}; // Loop through the data to calculate sales by month dataArray.forEach(row => { let month = row[0]; // Assuming the month is in the first column let sales = row[1]; // Assuming sales data is in the second column if (!summary[month]) { summary[month] = sales; } else { summary[month] += sales; } }); // Prepare the summary data for output let summaryArray = []; for (let month in summary) { summaryArray.push([month, summary[month]]); } // Output the summary to a new worksheet let summarySheet = workbook.addWorksheet(“Summary”); let summaryRange = summarySheet.getRange(“A1:B” + (summaryArray.length + 1)); summaryRange.setValues(summaryArray);} If you want to leverage this automate script you can do this is available in my premium account of office 365 you can check :white_heavy_check_mark: yours if it’s available in ribbon :ribbon: Please note – it’s not macro Read More
I can’t change the beginning part
Hello
I see this all the time on the start page, I want another site to open but I couldn’t. how can I do that?
Hello I see this all the time on the start page, I want another site to open but I couldn’t. how can I do that? Read More
Shortcut to zoom in at 90% in microsoft excel for all workbooks without using VBA
Is there any way to zoom at specifically 90% or any other % with using keyboard shortcut keys and not using VBA?
For now, I have kept zoom in my quick access toolbar and manually add 90% at the custom field.
Is there any way to zoom at specifically 90% or any other % with using keyboard shortcut keys and not using VBA?For now, I have kept zoom in my quick access toolbar and manually add 90% at the custom field. Read More
SMTP Settings to enable other app (Acronis TI) to send email via M365
Hi all,
I have recently moved from M365 Personal to Business. I also use Acronis True Image which needs the following SMTP settings to send notifications by email:
Server settings:
Outgoing mail server (SMTP) name
Port
Encryption
SMTP authorisation:
Username and password
Optional – Log on to incoming mail server:
POP3 server and Port
I have found various (conflicting) settings on the web (including adding Authenticated SMTP in the M365 Mail settings for the user) but none work.
Can anyone help?
Hi all,I have recently moved from M365 Personal to Business. I also use Acronis True Image which needs the following SMTP settings to send notifications by email:Server settings:Outgoing mail server (SMTP) namePortEncryption SMTP authorisation:Username and passwordOptional – Log on to incoming mail server:POP3 server and PortI have found various (conflicting) settings on the web (including adding Authenticated SMTP in the M365 Mail settings for the user) but none work.Can anyone help? Read More
Cannot center a bar (macron) accent on top of character.
I am trying to accent a number with a bar (macron?) on top, using strictly the Insert Symbol option. I have read instructions and watched a number of YT videos that successfully do that. But when I follow the instructions, the bar is not centered on top of the character, but always skewed to its right like a superscript. There are already bar-accented letters in the symbols list, but those are not useful to me because I am trying to insert the bar on top of a number, not a letter. I also tried inserting the bar through the Alt+code option, but the bar remains to the right of the number.
I am trying to accent a number with a bar (macron?) on top, using strictly the Insert Symbol option. I have read instructions and watched a number of YT videos that successfully do that. But when I follow the instructions, the bar is not centered on top of the character, but always skewed to its right like a superscript. There are already bar-accented letters in the symbols list, but those are not useful to me because I am trying to insert the bar on top of a number, not a letter. I also tried inserting the bar through the Alt+code option, but the bar remains to the right of the number. Read More
Looking to create policy that excludes users using MS 365 resource on personal mobile phones
Hi. I’m relatively new to admining Intune. I have been set a task to create a policy that excludes users from using any MS 365 resources on their personal mobile phones. I am hitting a wall with how to achieve this. Any help would be appreciated.
Hi. I’m relatively new to admining Intune. I have been set a task to create a policy that excludes users from using any MS 365 resources on their personal mobile phones. I am hitting a wall with how to achieve this. Any help would be appreciated. Read More
Policy Tip is not working in Outlook Client but works in OWA
User A signs into Computer X (and other Computers also), and the policy tip is functional for him in both the Outlook client and OWA.
User B signs into to the same Computer X, policy tip doesn’t work for him on Outlook Client but OWA works.
We have noticed that for User A account policy nudge rule and classification xmls under C:Users<User Profile>AppDataLocalMicrosoftOutlook location and also ComputerHKEY_CURRENT_USERSoftwareMicrosoftoffice16.0outlookPolicyNudges key in registry but these are not getting created for User B on whichever machines he logs on.
The missing xml files in the user profile of User B and missing registry key in HKey current user points to either User account/profile related issue or network glitch.
Operating System – Windows 10/11
Outlook Version – Current channel 2403
Please help.
User A signs into Computer X (and other Computers also), and the policy tip is functional for him in both the Outlook client and OWA.User B signs into to the same Computer X, policy tip doesn’t work for him on Outlook Client but OWA works. We have noticed that for User A account policy nudge rule and classification xmls under C:Users<User Profile>AppDataLocalMicrosoftOutlook location and also ComputerHKEY_CURRENT_USERSoftwareMicrosoftoffice16.0outlookPolicyNudges key in registry but these are not getting created for User B on whichever machines he logs on. The missing xml files in the user profile of User B and missing registry key in HKey current user points to either User account/profile related issue or network glitch. Operating System – Windows 10/11Outlook Version – Current channel 2403 Please help. Read More
Table of Figures formatting
I’m creating a report template for my work, and I’m struggling with formatting the table of figures, for both Tables and Figures.
1. The font in the table is taking the text formatting from the captions. I want to set it to a different style from the captions.
2. I want the position of the page numbers on right hand side of the table to be aligned with my table of contents above it. If I select the table and move the tabs, it moves the page numbers where I want, but if I add another caption to the document and then update the table, the new caption reference is aligned as per the original alignment. Some advice or links to relevant YouTube videos would be much appreciated. Thanks
I’m creating a report template for my work, and I’m struggling with formatting the table of figures, for both Tables and Figures.1. The font in the table is taking the text formatting from the captions. I want to set it to a different style from the captions.2. I want the position of the page numbers on right hand side of the table to be aligned with my table of contents above it. If I select the table and move the tabs, it moves the page numbers where I want, but if I add another caption to the document and then update the table, the new caption reference is aligned as per the original alignment. Some advice or links to relevant YouTube videos would be much appreciated. Thanks Read More
Help with XLookup to change Search Ranges per a Selected Condition
Hello Xcel Pros,
I’ve used XLookup for a number of things, but I can find, figure out, or wrap my head around what I think could be easy enough to do, but I am just missing it, or I’m trying to force the wrong formula to do what I need. I created an example of my much larger workbook that should be sufficient to show what I’m going for, which is to add a Value to a Base Unit Stat Value, dependent upon a selected condition. In short I don’t know how get a Formula to search through the Title, Sub-Title to add that Value based on the Selected Condition and Unit.
Thank you!
Hello Xcel Pros, I’ve used XLookup for a number of things, but I can find, figure out, or wrap my head around what I think could be easy enough to do, but I am just missing it, or I’m trying to force the wrong formula to do what I need. I created an example of my much larger workbook that should be sufficient to show what I’m going for, which is to add a Value to a Base Unit Stat Value, dependent upon a selected condition. In short I don’t know how get a Formula to search through the Title, Sub-Title to add that Value based on the Selected Condition and Unit. Thank you! Read More
Help with Formula to count game points
Hi, I’m a soccer mum with little excel smarts. I’m collecting each game from the team who were the top 3 players for the game and assigning them 3 points for best, 2 points for 2nd best and 1 point for 3rd best. At the end of the season this goes towards awards.
I have set up a table with drop down boxes and I ask each girl who they are allocating the 3 pints to, the 2 pints to and the 1 point.
What I need now is a way to calculate the points each player got each game.
This is what I’m stuck figuring out.
If I can figure this out I can apply this formula to all the subsequent games.
Hi, I’m a soccer mum with little excel smarts. I’m collecting each game from the team who were the top 3 players for the game and assigning them 3 points for best, 2 points for 2nd best and 1 point for 3rd best. At the end of the season this goes towards awards. I have set up a table with drop down boxes and I ask each girl who they are allocating the 3 pints to, the 2 pints to and the 1 point. What I need now is a way to calculate the points each player got each game.This is what I’m stuck figuring out.If I can figure this out I can apply this formula to all the subsequent games. Read More
AI Studio- Index on SQL DB
Hi, I am trying to create index in AI Studio based on Index I created in Azure Search on small SQL DB (300 rows) and it runs forever on create index step and never finishes. Can someone guide how to troubleshoot? I was previously able to create index without any issues which was based on json file.
Thanks,
KK
Hi, I am trying to create index in AI Studio based on Index I created in Azure Search on small SQL DB (300 rows) and it runs forever on create index step and never finishes. Can someone guide how to troubleshoot? I was previously able to create index without any issues which was based on json file. Thanks,KK Read More
What are the pros and cons of using GitHub Copilot?
GitHub Copilot continues to soar to new heights in the two years since its launch. Over the years it has grown to over 1 million paid subscribers across over 37,000 organizations. This makes it the most widely adopted AI developer tool in history and it continues to redefine how developers code.
Let’s analyze the pros of GitHub copilot. It:
Suggests code as you type – You can view and incorporate suggestions from GitHub copilot directly within the browser. You can accept, partially accept, reject, or view alternative suggestions if there are any. Answers coding questions – GitHub Copilot Chat can generate unit test cases, propose code fixes, answer coding questions, and explain your code. But don’t forget your due diligence. Always check and test your code. Refactors and improves code – Copilot suggests refactoring using the context of your codebase and recommends potential improvements to selected code such as improved handling of errors and edge cases, or changes to the logical flow to make the code more readable.Fixes issues – Copilot can suggest possible fixes based on the error message, the code’s syntax, and the surrounding code. Also, when a command fails to run in the terminal, Copilot offers a Quick Fix to explain what happened. Generates commit messages and PR descriptions – Copilot uses AI to describe your code changes. This feature makes writing descriptive and helpful commit messages as easy as clicking a button.
Let’s see the cons of GitHub Copilot. The most evident disadvantage is that developers who heavily rely on Copilot risk being overdependent on automated suggestions. This is a problem, especially for beginners. Additionally, Copilot may generate inaccurate code that appears to be valid.
To mitigate inaccurate code, you should always review and test the code.
Developers must take a thoughtful approach to integrating this tool into their process. GitHub copilot is meant to increase productivity and accelerate the rate of software development, not replace the developer’s decision-making and critical thinking.
GitHub Copilot continues to soar to new heights in the two years since its launch. Over the years it has grown to over 1 million paid subscribers across over 37,000 organizations. This makes it the most widely adopted AI developer tool in history and it continues to redefine how developers code. Let’s analyze the pros of GitHub copilot. It: Suggests code as you type – You can view and incorporate suggestions from GitHub copilot directly within the browser. You can accept, partially accept, reject, or view alternative suggestions if there are any. Answers coding questions – GitHub Copilot Chat can generate unit test cases, propose code fixes, answer coding questions, and explain your code. But don’t forget your due diligence. Always check and test your code. Refactors and improves code – Copilot suggests refactoring using the context of your codebase and recommends potential improvements to selected code such as improved handling of errors and edge cases, or changes to the logical flow to make the code more readable.Fixes issues – Copilot can suggest possible fixes based on the error message, the code’s syntax, and the surrounding code. Also, when a command fails to run in the terminal, Copilot offers a Quick Fix to explain what happened. Generates commit messages and PR descriptions – Copilot uses AI to describe your code changes. This feature makes writing descriptive and helpful commit messages as easy as clicking a button. Let’s see the cons of GitHub Copilot. The most evident disadvantage is that developers who heavily rely on Copilot risk being overdependent on automated suggestions. This is a problem, especially for beginners. Additionally, Copilot may generate inaccurate code that appears to be valid. To mitigate inaccurate code, you should always review and test the code. Developers must take a thoughtful approach to integrating this tool into their process. GitHub copilot is meant to increase productivity and accelerate the rate of software development, not replace the developer’s decision-making and critical thinking. Read More
Partner payment error
The Partner Payment Center payment page does not properly process cards.
The error I am receiving does not seem to be a valid error for credit cards: Payment failed due to insufficient balance. Please check with your bank or try again with a different card.
My Card is in good standing. In the MS store I have no problem, just in the Partner payment page.
I’ve cleared the browser cache and still get the same error.
The Partner Payment Center payment page does not properly process cards.The error I am receiving does not seem to be a valid error for credit cards: Payment failed due to insufficient balance. Please check with your bank or try again with a different card. My Card is in good standing. In the MS store I have no problem, just in the Partner payment page.I’ve cleared the browser cache and still get the same error. Read More
network adapter not there
HI im using a HP 250 G7 Notebook PC and suddenly my network adapter the realtek rtl8822ce 802.11ac pcie adapter. Seems to have just disappeared some times it comes back but not for ever its been 2 days with no internet and ive tried everything wlan command promt all that i even reseted my computer and system restrord pls help and i cant use ethernet.
HI im using a HP 250 G7 Notebook PC and suddenly my network adapter the realtek rtl8822ce 802.11ac pcie adapter. Seems to have just disappeared some times it comes back but not for ever its been 2 days with no internet and ive tried everything wlan command promt all that i even reseted my computer and system restrord pls help and i cant use ethernet. Read More
what formula can i use to count non blank cells
if i have the below spread sheet. i would be very grateful if anyone could let me know what formula i could use to count non blank spaces. i believe it is the if and then the counta formula, but i can’t seem to get it to work.
any help is very welcomed.
Row No Column Column
A B
1 1
2 1 2
3
4 1
5 1
6 1 3
7
8
9 1
10 1
11 1
12 1 4
I am trying to add the non blank cells that are in column A before they are separated by a blank cell, and have this displayed on Column B.
Any help is welcomed.
Thanks
Terence
if i have the below spread sheet. i would be very grateful if anyone could let me know what formula i could use to count non blank spaces. i believe it is the if and then the counta formula, but i can’t seem to get it to work. any help is very welcomed. Row No Column Column A B1 12 1 234 15 16 1 3789 110 111 112 1 4 I am trying to add the non blank cells that are in column A before they are separated by a blank cell, and have this displayed on Column B. Any help is welcomed. Thanks Terence Read More