Tag Archives: microsoft
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
Windows Explorer Local Network issues
Windows 11 has problems connecting to my Linux Mint NAS box. It sees it just fine but when I click on it to try to connect to it a diagnostic dialog box pops up and will not let me connect until I run the diagnostic. Of course the diagnostic can’t find anything because the is actually nothing work, then it says it will be replaced soon but this has been going on for over a year. After one of the many updates it worked correctly for a day and then reverted to this issue.Why does Windows 11 not understand local networks??
Windows 11 has problems connecting to my Linux Mint NAS box. It sees it just fine but when I click on it to try to connect to it a diagnostic dialog box pops up and will not let me connect until I run the diagnostic. Of course the diagnostic can’t find anything because the is actually nothing work, then it says it will be replaced soon but this has been going on for over a year. After one of the many updates it worked correctly for a day and then reverted to this issue.Why does Windows 11 not understand local networks?? Read More
Intune – Remote Help – Licensing and Unattended Control
Greetings,
First: Like others on the interweb I am struggling to find the value of this solution when it is necessary to license both the helper and sharer. ScreenConnect and/or other secure solutions offer more control and value – IMO. Microsoft – please reconsider the addin license structure and cost.
Second Question: The Remote Help claims to offer unattended control. My expectation of this would be – the helper connects to the endpoint when there’s no one (as sharer) logged in to approve the connection. Is this possible or not?
Thank you,
Greetings,First: Like others on the interweb I am struggling to find the value of this solution when it is necessary to license both the helper and sharer. ScreenConnect and/or other secure solutions offer more control and value – IMO. Microsoft – please reconsider the addin license structure and cost. Second Question: The Remote Help claims to offer unattended control. My expectation of this would be – the helper connects to the endpoint when there’s no one (as sharer) logged in to approve the connection. Is this possible or not? Thank you, Read More
value changes sheet
Hi everyone, I’m not very expert in office script, I wrote this code but I would like the script to start when a value changes in another sheet.
for now I can only activate it via button.
Thank you
function main(workbook: ExcelScript.Workbook) {
// Refresh all data connections
workbook.refreshAllDataConnections();
// Row height
workbook.getWorksheet(“Matrice”).getRange(“A4”).getFormat().setRowHeight(200 * 3 / 4);
workbook.getWorksheet(“Matrice”).
getRange(“F5:F1000”).getEntireColumn().getFormat().setHorizontalAlignment(ExcelScript.HorizontalAlignment.left);
}
Hi everyone, I’m not very expert in office script, I wrote this code but I would like the script to start when a value changes in another sheet.for now I can only activate it via button.Thank youfunction main(workbook: ExcelScript.Workbook) {// Refresh all data connectionsworkbook.refreshAllDataConnections();// Row heightworkbook.getWorksheet(“Matrice”).getRange(“A4”).getFormat().setRowHeight(200 * 3 / 4);workbook.getWorksheet(“Matrice”).getRange(“F5:F1000”).getEntireColumn().getFormat().setHorizontalAlignment(ExcelScript.HorizontalAlignment.left);} Read More
Win 11 22631.3527 Bridge Connection from Ethernet to Thunderbolt Connection is broken
Bridging a thunderbolt connection to an ethernet connection on Windows 11 in an ‘unidentified error’ dialog.
Is this also true in prior public release builds?
Bridging a thunderbolt connection to an ethernet connection on Windows 11 in an ‘unidentified error’ dialog. Is this also true in prior public release builds? Read More
Is it possible to customize the Task cost calculation?
I have a question on how to customize the calculation of Task costs.
A bit of context: in my research organization, most of our research projects are funded by institutions (European Commission, regional agencies, …), which funding rates differ between each other. Example: the EC reimburses all direct costs (i.e. personnel + equipment + travel) and adds 25% of indirect costs rate; a regional agency reimburses only 10% of indirect costs and they only apply to the personnel costs.
I have created a Project custom field for the funding scheme (EC, …) and some custom fields for our resources (Manpower, Equipment, Travel, …). My objective is to create a custom Cost1 field which would test the type of funding scheme and the cost category, and apply the corresponding formula.
The problem is that I don’t see how to access the resource individual costs under the Task Usage view, it seems the formulas only apply to the total cost of the Task.
Does anyone have a clue of how I could achieve what I need? I hope the explanations above were clear enough.
Thanks in advance!
Christophe.
I have a question on how to customize the calculation of Task costs. A bit of context: in my research organization, most of our research projects are funded by institutions (European Commission, regional agencies, …), which funding rates differ between each other. Example: the EC reimburses all direct costs (i.e. personnel + equipment + travel) and adds 25% of indirect costs rate; a regional agency reimburses only 10% of indirect costs and they only apply to the personnel costs. I have created a Project custom field for the funding scheme (EC, …) and some custom fields for our resources (Manpower, Equipment, Travel, …). My objective is to create a custom Cost1 field which would test the type of funding scheme and the cost category, and apply the corresponding formula.The problem is that I don’t see how to access the resource individual costs under the Task Usage view, it seems the formulas only apply to the total cost of the Task. Does anyone have a clue of how I could achieve what I need? I hope the explanations above were clear enough. Thanks in advance! Christophe. Read More
Permanently delete users
Hello
Please i need your help on this issue.
I would know to know how to permanently delete users from their list without waiting for the usual 30-day period.
I would like all of my deleted users to be removed immediately from the list, rather than waiting 30 days.
Hello Please i need your help on this issue. I would know to know how to permanently delete users from their list without waiting for the usual 30-day period. I would like all of my deleted users to be removed immediately from the list, rather than waiting 30 days. Read More
Time vs Date Plots Help Please
Hello,
I have a long series of data that look like this sample:
Residual ValueDateTime025/01/202419:01:36026/01/202401:45:24026/01/202407:13:15026/01/202416:33:29026/01/202420:31:30027/01/202402:09:11027/01/202407:42:02027/01/202415:09:28027/01/202420:37:51028/01/202402:36:39028/01/202410:21:07028/01/202415:03:29028/01/202421:57:21029/01/202403:19:17029/01/202411:50:38029/01/202412:13:03030/01/202401:20:39
When I try to plot the times vs dates this on a scatter excel is doing this and I can’t seem to alter it:
I would like it to display like this (borrowed from another post):
Can anyone help me with this please is it’s extremely frustrating?
Thank you in advance
Seb
Hello,I have a long series of data that look like this sample:Residual ValueDateTime025/01/202419:01:36026/01/202401:45:24026/01/202407:13:15026/01/202416:33:29026/01/202420:31:30027/01/202402:09:11027/01/202407:42:02027/01/202415:09:28027/01/202420:37:51028/01/202402:36:39028/01/202410:21:07028/01/202415:03:29028/01/202421:57:21029/01/202403:19:17029/01/202411:50:38029/01/202412:13:03030/01/202401:20:39When I try to plot the times vs dates this on a scatter excel is doing this and I can’t seem to alter it: I would like it to display like this (borrowed from another post):Can anyone help me with this please is it’s extremely frustrating?Thank you in advance Seb Read More
Two certification id’s under the same email address
I have completed my Microsoft Security, Compliance, and Identity Fundamentals exam on Pearson VUE . But the mcids in the mail received after completion and the Microsoft learn tab which is under the same email is different . So I m not able to access any of my certifications . Can somebody help me to merge these to two id’s and get the certifications as I have to submit it at the earliest
I have completed my Microsoft Security, Compliance, and Identity Fundamentals exam on Pearson VUE . But the mcids in the mail received after completion and the Microsoft learn tab which is under the same email is different . So I m not able to access any of my certifications . Can somebody help me to merge these to two id’s and get the certifications as I have to submit it at the earliest Read More
Ordinateur
Hello, can you tell me how to force an update, thank you
Hello, can you tell me how to force an update, thank you Read More