Tag Archives: microsoft
VLOOKUP Issue
Hi,Â
Â
My apologies as this is a very basic VLOOKUP question but I can’t figure it out. I have data where every person has a research partner. I’m trying to create a Partner_ID variable that contains the ID of the person the participant is partnered with. I’m pretty sure VLOOKUP is the best way to do this but it isn’t working for me. I have put an example with fake data in the screenshot below. Essentially, I want VLOOKUP to search for the name “Cox” in the Table and find the name under the LastName column, then print the ID that is next to it (in this case, cell D2 should print a 3, indicating that Perry’s Partner is ID#3). As you can see, however, Excel is returning error messages that it can’t find the expected value. I’ve looked at various tutorials and I can’t figure out what I’m doing wrong. Thank you!Â
Â
The formula I’m using is =VLOOKUP(C2,$A$2:$B$7,1,FALSE)
Â
​Hi,  My apologies as this is a very basic VLOOKUP question but I can’t figure it out. I have data where every person has a research partner. I’m trying to create a Partner_ID variable that contains the ID of the person the participant is partnered with. I’m pretty sure VLOOKUP is the best way to do this but it isn’t working for me. I have put an example with fake data in the screenshot below. Essentially, I want VLOOKUP to search for the name “Cox” in the Table and find the name under the LastName column, then print the ID that is next to it (in this case, cell D2 should print a 3, indicating that Perry’s Partner is ID#3). As you can see, however, Excel is returning error messages that it can’t find the expected value. I’ve looked at various tutorials and I can’t figure out what I’m doing wrong. Thank you!  The formula I’m using is =VLOOKUP(C2,$A$2:$B$7,1,FALSE)   Read More
​
Why do I have to have AI?
I want the latest speed and memory of the latest surface pro, but I don’t want anything to do with AI. can I purchase a surface pro without AI?
​I want the latest speed and memory of the latest surface pro, but I don’t want anything to do with AI. can I purchase a surface pro without AI?  Read More
​
Cannot add a gmail account as a POP account to Outlook Pro Plus 2021
I am trying to get my 6 email accounts into one inbox by having them all be POP accounts. One of my oldest gmail accounts will not recognize my gmail password. I’ve gone into my Gmail and enabled POP, saved it to no avail. It will only add the account as an IMAP account which separates the inbox and defeats my purpose. TIA for your assistance!
​I am trying to get my 6 email accounts into one inbox by having them all be POP accounts. One of my oldest gmail accounts will not recognize my gmail password. I’ve gone into my Gmail and enabled POP, saved it to no avail. It will only add the account as an IMAP account which separates the inbox and defeats my purpose. TIA for your assistance!  Read More
​
Sharing with unlicensed members of my team
I’m a new MS Project user. I’m attempting to share a roadmap with other members of my team, who do not have access to MS Projects. How do I do this?Â
​I’m a new MS Project user. I’m attempting to share a roadmap with other members of my team, who do not have access to MS Projects. How do I do this?   Read More
​
we couldnot save your tab settings.
Hi All
i am using M365 E5 license. I am unable to add the “Planner” app as a new tab in a channel. i am the owner of the teams. i am getting error we couldn’t save your tab settings. please try again.
​Hi Alli am using M365 E5 license. I am unable to add the “Planner” app as a new tab in a channel. i am the owner of the teams. i am getting error we couldn’t save your tab settings. please try again.  Read More
​
I lost all my documents and images stored on my one drive account
Hello,
Â
I lost all my documents and images stored on my one drive account at email address removed for privacy reasons.Â
It is a school alumni account.Â
Â
I would hereby appreciate your help in retrieving this as quickly as possible, as many of these documents have professional use and personal value. You can contact me by email.
Â
Kind regards,
Â
Hong Ducruet
​Hello, I lost all my documents and images stored on my one drive account at email address removed for privacy reasons. It is a school alumni account.  I would hereby appreciate your help in retrieving this as quickly as possible, as many of these documents have professional use and personal value. You can contact me by email.  Kind regards,  Hong Ducruet  Read More
​
Chapter page formatting for novel
I’m formatting a manuscript (my novel) in Word V 16.8 and need to have each new chapter start in the middle of the page without using the enter key or returns. I’m ignorant about most of Word. I only enough to start typing. Can you help?
​I’m formatting a manuscript (my novel) in Word V 16.8 and need to have each new chapter start in the middle of the page without using the enter key or returns. I’m ignorant about most of Word. I only enough to start typing. Can you help?  Read More
​
tally scores over several sheets
I am trying to create a summary score sheet to find a High point winner. The program has an Entries sheet where names are entered and marked as to which ‘classes’ they are participating in. (there are 12 classes) Each class has it’s own sheet. The competitors receive a set of scores for each class which is totaled and sorted High to Low. Of a total of 30 competitors maybe 10 are in one class, they can enter several classes.Â
I want to create a summary of their scores. A summary page uses this formula (=IF(Entries!$A4<>””,Entries!B4,””) to copy their names to the summary. The problem is for ‘Class A’ when the scores are tallied and sorted, the total does not match the competitor input line anymore. I can total a score if I chose a specific cell (=’#1 (Saturday)’!T6) but it does not relate to that competitor…Â Is there a way to sort that out?
​I am trying to create a summary score sheet to find a High point winner. The program has an Entries sheet where names are entered and marked as to which ‘classes’ they are participating in. (there are 12 classes) Each class has it’s own sheet. The competitors receive a set of scores for each class which is totaled and sorted High to Low. Of a total of 30 competitors maybe 10 are in one class, they can enter several classes. I want to create a summary of their scores. A summary page uses this formula (=IF(Entries!$A4<>””,Entries!B4,””) to copy their names to the summary. The problem is for ‘Class A’ when the scores are tallied and sorted, the total does not match the competitor input line anymore. I can total a score if I chose a specific cell (=’#1 (Saturday)’!T6) but it does not relate to that competitor… Is there a way to sort that out?  Read More
​
Dissertation Footnotes
I need the numerical footnote reference to be a size 12 font in the body of the text and a size 10 font in the footnote at the bottom of the page. Right now, I insert the footnote at the end of the sentence and have to change each individual one to size 12. I am about to combine all of my individual chapters with over 1,000 footnotes. When I cut and paste it, I am concerned that I will need to go back and individually change every one of the numbers in the body back to size 12. Â
Â
Since I will continue to produce scholarly work, I would like to know how to do set this up where these will display correctly. I am working in CMS/Turabian for the formatting of the dissertation.
​I need the numerical footnote reference to be a size 12 font in the body of the text and a size 10 font in the footnote at the bottom of the page. Right now, I insert the footnote at the end of the sentence and have to change each individual one to size 12. I am about to combine all of my individual chapters with over 1,000 footnotes. When I cut and paste it, I am concerned that I will need to go back and individually change every one of the numbers in the body back to size 12.   Since I will continue to produce scholarly work, I would like to know how to do set this up where these will display correctly. I am working in CMS/Turabian for the formatting of the dissertation.  Read More
​
Sharing data with a community
Hi all,
I’m an admin for a small group of volunteers in our community. As such, we’ve signed up for Microsoft’s non profit program.Â
I would like to accomplish the following: create a simple sharepoint site (document library?) in which members of my organisation can upload data (leaflets, promo material etc.). This data should be public available over the internet to everyone in our community, without the need for people in the community to sign in first.
Is there any way we can accomplish this?
Thanks for your answers 🙂
​Hi all,I’m an admin for a small group of volunteers in our community. As such, we’ve signed up for Microsoft’s non profit program. I would like to accomplish the following: create a simple sharepoint site (document library?) in which members of my organisation can upload data (leaflets, promo material etc.). This data should be public available over the internet to everyone in our community, without the need for people in the community to sign in first.Is there any way we can accomplish this?Thanks for your answers 🙂  Read More
​
Network Scan Agent – installation/registration error
During the installation of Network Scan Agent, after entering the device login code, the agent tries to register. The registration fails with an error:
Â
Internal server error > AadConfiguration has unexpected empty issuer
Â
Have you ever encountered this error , or do you have any idea what to check and where ?
I have attached a printscreen with the error.
Â
Thank you for your help.
Â
​During the installation of Network Scan Agent, after entering the device login code, the agent tries to register. The registration fails with an error: Internal server error > AadConfiguration has unexpected empty issuer Have you ever encountered this error , or do you have any idea what to check and where ?I have attached a printscreen with the error. Thank you for your help.   Read More
​
Word can now convert pdfs to docx online – how private/secure is this?
I’ve just noticed this new function – what service does Word use to do this and how private/secure is this?
​I’ve just noticed this new function – what service does Word use to do this and how private/secure is this?  Read More
​
Link to Excel on Jump Drive
I have a Word 2013 file with links to various ranges on an Excel file. I had them all on my computer, but now they are on a Jump Drive. Unfortunately with them now on a jump drive, the drive letter can change. Both files are in the same directory. Is there any way to edit the links without the full path?
That is, I want to go fromÂ
F:SecretaryMinutesTables.xlsx
to
Tables.xlsx
​I have a Word 2013 file with links to various ranges on an Excel file. I had them all on my computer, but now they are on a Jump Drive. Unfortunately with them now on a jump drive, the drive letter can change. Both files are in the same directory. Is there any way to edit the links without the full path?That is, I want to go from F:SecretaryMinutesTables.xlsxtoTables.xlsx  Read More
​
Utilizing Azure Storage and Runbooks for scheduled automated backups of Azure SQL Databases
In this article, we are going to provide detailed steps to create a scheduled Azure SQL Database backup to storage account using automation. This is a useful technique for maintaining regular backups of your database and storing them in a secure and accessible location. You will get an actual backup of Azure SQL Database stored in a storage account in .bacpac format, which you can restore or migrate as needed. The automation process involves creating an automation account that triggers a PowerShell script through a runbook to run the backup command and save the output to a blob container.
Â
Prerequisites
Azure Storage account: The storage account is needed to host the database backups. You are required to set up a container within this account to store the backups.
Â
Azure SQL Database and Server: This is the database you will back up, along with its hosting server. Ensure that you grant Azure services permission to access the server where this database is hosted by selecting “Allow Azure services and resources to access this server” within the networking section, as illustrated in the following documentation: Network Access Controls – Azure SQL Database & Azure Synapse Analytics | Microsoft Learn
Â
Azure Automation account and PowerShell Workflow runbook: These components are utilized to set up automatic backups and their scheduling. make sure to using a PowerShell version 7.2 or above when creating the runbook. To learn more about setting up a PowerShell Workflow runbook in Azure Automation, please check the following documentation: Tutorial – Create a PowerShell Workflow runbook in Azure Automation | Microsoft Learn
Setup
Once all the necessary prerequisites are in place, you should navigate to the runbook and click on “Edit.” Then choose the “Edit in portal” option as illustrated below:
Â
Â
 The editor interface for the runbook will launch, displaying the runbook you created earlier. Enter the following code into the editor area:
Â
Â
Â
# Connect to Azure with system-assigned managed identity
Connect-AzAccount -Identity
# set and store context
$AzureContext = Set-AzContext –SubscriptionId “*****”
# Resource group name
$resourceGroup = “*****”
# Storage account name that will have the backups
$storageAccountName = “*****”
# Storage account access key that will have the backups
$storageKey = “*****”
# Container name that will have the backups
$containerName = “*****”
# storage blob uri with the datetime
$storageUri = “https:// *****.blob.core.windows.net/*****/db-$(Get-Date -UFormat “%Y-%m-%d_%H-%m-%S”).bacpac”
#Storage access key type
$storageKeyType = “StorageAccessKey”
#SQL server name
$server_name =”*****”
#Database name to be exported
$SQL_db = “*****”
#SQL Auth Username
$SQL_username = “*****”
#SQL Auth Password
$SQL_secure_secret = ConvertTo-SecureString -String “*****” -AsPlainText -Force
# Run the Export job with the required parameters
New-AzSqlDatabaseExport -ResourceGroupName $resourceGroup -ServerName $server_name -DatabaseName $SQL_db -StorageKeyType $storageKeyType -StorageKey $storageKey -StorageUri $storageUri -AdministratorLogin $SQL_username -AdministratorLoginPassword $SQL_secure_secret
Â
Â
Â
Â
Ensure you fill in all the ***** with the appropriate values for the step you’ve designed, then press the “Save” button located at the top left corner. The parameters given relate to details on subscription and resource group, as well as information on the SQL database, server, and storage account. You’ll find explanations for each parameter in the code snippet provided above.Â
Â
Â
Select the test button on the toolbar, which will display the test pane allowing you to test the script prior to scheduling. Hit the start button and monitor the requests; if the run is successful, you should observe an outcome like this:
Â
Â
Â
Â
You can monitor the progress of backups and access the export history through the SQL server in the “Import/Export history” section, as illustrated below:
Â
Â
Â
After the backup finishes, it will appear in the storage account with the datetime suffix provided by the script:
Â
Â
Â
After verifying the script operates correctly, you may go ahead with publishing the runbook and link it to a schedule based on your requirements according to the following documentation:
Manage schedules in Azure Automation | Microsoft Learn
Â
You can initiate the automation by pressing the start button, schedule it to run automatically, or set a webhook to trigger the process. Remember that you can only run one export job at a time. If you attempt to run two jobs simultaneously, one will not succeed and you’ll receive an error message stating that another export job is already in progress.
Â
Recommendations
Establishing a routine backup schedule for a large database over an undefined timeframe can lead to substantial storage consumption and potentially significant costs. It’s important to regularly monitor your storage account and remove unnecessary backups, or consider relocating them to more cost-effective storage tiers, such as cold or archive.
Â
It might be beneficial to consider implementing a storage lifecycle management policy to manage data within the storage account and decrease the costs associated with storing database backups. Lifecycle management can help you in creating an automated schedule to delete blobs or transition blobs to a different tier that is less expensive like cold or archive tiers based on creation date. For additional details on storage lifecycle management and instructions for configuration, please consult the provided documentation:
Configure a lifecycle management policy – Azure Blob Storage | Microsoft Learn
Â
If you have soft delete enabled on the storage account, make sure that the retention period is set appropriately to avoid incurring additional charges for retaining soft-deleted data over an extended period.
Â
​Microsoft Tech Community – Latest Blogs –Read MoreÂ
Compatibilité Excel2010 2021
Bonjour, j’adresse ce message aux experts d’Excel, après avoir obtenu le lien de ce site d’un conseillerMicrosoft en ligne, seuls vraiment susceptibles de pouvoir m’aider.
Le fichier Excel joint sur PC est autonome. Il permet, dans une grilleA1 à AK27 ; d’afficher des nombres croissants de 1 à 999 au maximum dans un emplacement aléatoire de la grille. A la fin, les 999 cellules de la grille sont renseignées et mémorisées dans le second onglet. Le calcul itératif est actif. Pour ce faire, retirer le « x » Reset grill on et mettre un « x » dans Start. Le remplissage commence.
Le problème précis est le suivant :
Développé sur Excel 2010, il fonctionne très bien. C’est è dire que pendant que les itérations s’écoulent, l’affichage des nombres , dans la grille est visible. A la fin d’un cycle d’itérations, un re calcul d’Excel,  le fait poursuivre.
Depuis peu, sur un autre PC, ce logiciel est lancé par Excel 2021. Et là , petit problème dérangeant.
En effet, les mêmes manipulations ne provoquent l’affichage des nombres , dans la grille, qu’à la fin du cycle d’itérations en cours, seulement à la fin,  et la progression d’affichage n’est pas visible, tant que le cycle n’est pas terminé, ce qui est dérangeant, surtout en configurant un nombre important d’itérations.
Malgré des comparaisons des 2 config d’Excel et multiples essais, en ce sens, je ne sais pas ce qu’il faut modifier, pour supprimer ce problème.
Les lieux d’action sont les suivants : BG35/36/37 pour créer les emplacements aléatoires et la colonne BL pour les placer dans l’ordre de création.
Il y a probablement une configuration d’Excel 2021 qui doit permettre de visualiser cette progression, je l’espère.
Les onglets sont protégés sans mot de passe.
Merci d’avance de votre précieuse aide.
Je n’ai pas vu ici comment vous envoyer le fichier Excel 376Ko. Me contacter pour le recevoir
​Bonjour, j’adresse ce message aux experts d’Excel, après avoir obtenu le lien de ce site d’un conseillerMicrosoft en ligne, seuls vraiment susceptibles de pouvoir m’aider.Le fichier Excel joint sur PC est autonome. Il permet, dans une grilleA1 Ă AK27 ; d’afficher des nombres croissants de 1 Ă 999 au maximum dans un emplacement alĂ©atoire de la grille. A la fin, les 999 cellules de la grille sont renseignĂ©es et mĂ©morisĂ©es dans le second onglet. Le calcul itĂ©ratif est actif. Pour ce faire, retirer le « x » Reset grill on et mettre un « x » dans Start. Le remplissage commence.Le problème prĂ©cis est le suivant :DĂ©veloppĂ© sur Excel 2010, il fonctionne très bien. C’est è dire que pendant que les itĂ©rations s’écoulent, l’affichage des nombres , dans la grille est visible. A la fin d’un cycle d’itĂ©rations, un re calcul d’Excel,  le fait poursuivre.Depuis peu, sur un autre PC, ce logiciel est lancĂ© par Excel 2021. Et lĂ , petit problème dĂ©rangeant.En effet, les mĂŞmes manipulations ne provoquent l’affichage des nombres , dans la grille, qu’à la fin du cycle d’itĂ©rations en cours, seulement Ă la fin,  et la progression d’affichage n’est pas visible, tant que le cycle n’est pas terminĂ©, ce qui est dĂ©rangeant, surtout en configurant un nombre important d’itĂ©rations.MalgrĂ© des comparaisons des 2 config d’Excel et multiples essais, en ce sens, je ne sais pas ce qu’il faut modifier, pour supprimer ce problème.Les lieux d’action sont les suivants : BG35/36/37 pour crĂ©er les emplacements alĂ©atoires et la colonne BL pour les placer dans l’ordre de crĂ©ation.Il y a probablement une configuration d’Excel 2021 qui doit permettre de visualiser cette progression, je l’espère.Les onglets sont protĂ©gĂ©s sans mot de passe.Merci d’avance de votre prĂ©cieuse aide.Je n’ai pas vu ici comment vous envoyer le fichier Excel 376Ko. Me contacter pour le recevoir  Read More
​
How does a duplicate photo remover identify similar images?
Hi folks,
I’m having a problem. Is there a solution that can help me find duplicate and similar photos?
Thanks!
​Hi folks,I’m having a problem. Is there a solution that can help me find duplicate and similar photos?Thanks!  Read More
​
Install error – 0x800f0900
can any one help i have done all the seps and got help from windows chat and no lookÂ
​can any one help i have done all the seps and got help from windows chat and no look   Read More
​
MDE deployment with Intune and SCCM client
Hello All,
Â
We want to deploy MDE with Intune. All devices are having SCCM client installed and configured. In this scenerio, enabling co-management is a must?Â
Please guide. Thanks
​Hello All, We want to deploy MDE with Intune. All devices are having SCCM client installed and configured. In this scenerio, enabling co-management is a must? Please guide. Thanks  Read More
​
Failed while patching to KB5040948
Hi all
I have faced this issue while patching upgrade version on SQL Server to CU27+GDR (KB5040948).
Does any one used to see this issue type before?
=============Issue Logs=================================
2024-08-11 12:13:30.89 spid12s Error: 912, Severity: 21, State: 2.
2024-08-11 12:13:30.89 spid12s Script level upgrade for database ‘master’ failed because upgrade step ‘ssis_discovery’ encountered error 35262, state 4, severity 10. This is a serious error condition which might interfere with regular operation and the database will be taken offline. If the error happened during upgrade of the ‘master’ database, it will prevent the entire SQL Server instance from starting. Examine the previous error log entries for errors, take the appropriate corrective actions and re-start the database so that the script upgrade steps run to completion.
2024-08-11 12:13:30.90 spid12s Error: 3417, Severity: 21, State: 3.
2024-08-11 12:13:30.90 spid12s Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. For more information about how to rebuild the master database, see SQL Server Books Online.
2024-08-11 12:13:30.90 spid12s SQL Trace was stopped due to server shutdown. Trace ID = ‘1’. This is an informational message only; no user action is required.
​Hi allI have faced this issue while patching upgrade version on SQL Server to CU27+GDR (KB5040948).Does any one used to see this issue type before?=============Issue Logs=================================2024-08-11 12:13:30.89 spid12s Error: 912, Severity: 21, State: 2.2024-08-11 12:13:30.89 spid12s Script level upgrade for database ‘master’ failed because upgrade step ‘ssis_discovery’ encountered error 35262, state 4, severity 10. This is a serious error condition which might interfere with regular operation and the database will be taken offline. If the error happened during upgrade of the ‘master’ database, it will prevent the entire SQL Server instance from starting. Examine the previous error log entries for errors, take the appropriate corrective actions and re-start the database so that the script upgrade steps run to completion.2024-08-11 12:13:30.90 spid12s Error: 3417, Severity: 21, State: 3.2024-08-11 12:13:30.90 spid12s Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. For more information about how to rebuild the master database, see SQL Server Books Online.2024-08-11 12:13:30.90 spid12s SQL Trace was stopped due to server shutdown. Trace ID = ‘1’. This is an informational message only; no user action is required.  Read More
​
Cell reference
Hi need help have a darts scoring program i created some years ago and cannot find how i got o enter data into single cell and each entry appeared consecutively in a column so as i entered each score it progressively wrote to scoresheets any help appreciated ( i think i already posted this but site says i haven’ hmmm
​Hi need help have a darts scoring program i created some years ago and cannot find how i got o enter data into single cell and each entry appeared consecutively in a column so as i entered each score it progressively wrote to scoresheets any help appreciated ( i think i already posted this but site says i haven’ hmmm  Read More
​