Month: July 2024
Is there a way to link cells to generate an alarm?
Hey y’all!
I’m not an Excel expert (barely proficient) but I’m trying to make a spreadsheet for patient medications that will link “Reorder” column to the patient “appointment date” column, and trigger a flag. (I’m using the “Inventory list with highlighting” template.)
Is this doable or do I need to input each time?
Thanks for any and all help!
Hey y’all!I’m not an Excel expert (barely proficient) but I’m trying to make a spreadsheet for patient medications that will link “Reorder” column to the patient “appointment date” column, and trigger a flag. (I’m using the “Inventory list with highlighting” template.) Is this doable or do I need to input each time? Thanks for any and all help! Read More
News link thumbnail displaying old image and Bing API?
We’re seeing odd behavior when creating a News link in SharePoint Online:
Add a News web part to a page. Use the Add > News link option of the News web part.Paste a link to a web public page with an og:image metadata tag that includes a valid URL to an image. This page should also have been indexed by Bing search engine. Here’s one to test with: https://bellinghampubliclibrary.org/summer-readingAccept the default settings and select the Post button.Go to the public page and change the image so the og:image metadata tag value updates to the new image URL. Go back to the News web part and repeat steps 1-4 above.
Our experience is the old image for the public website is pulled in during the process of creating the second News link. We thought maybe this was a Bing search engine caching issue, but when we pull up the cached version of the page, the new image is being displayed. We used Bing’s webmaster tools and requested a recrawl of the page even though the cached version is showing the new image to be sure Bing’s cache was updated.
When you right click and copy the image URL for the thumbnail during the News link creation process above, the URL seems to hint that maybe it’s going out to Bing’s API to get the thumbnail:
https://www.bing.com/th?id=OVP.c4B_14v2FtlHM9FJ3RVJlQEsBl&pid=Api
This is the image that should be displaying:
This is the image that’s being shown (an image that was on the page months ago):
So, we have three questions:
How does the News link process obtain the thumbnail?Why are we getting an old version of the thumbnail when the live and cached versions of the page are showing the new image?How do we fix it? We know we can override the image and manually upload the correct image. But we’d like to make it easier on content editors and have the current image pulled in without extra steps.
Thanks for any tips you can send our way!
We’re seeing odd behavior when creating a News link in SharePoint Online: Add a News web part to a page. Use the Add > News link option of the News web part.Paste a link to a web public page with an og:image metadata tag that includes a valid URL to an image. This page should also have been indexed by Bing search engine. Here’s one to test with: https://bellinghampubliclibrary.org/summer-readingAccept the default settings and select the Post button.Go to the public page and change the image so the og:image metadata tag value updates to the new image URL. Go back to the News web part and repeat steps 1-4 above. Our experience is the old image for the public website is pulled in during the process of creating the second News link. We thought maybe this was a Bing search engine caching issue, but when we pull up the cached version of the page, the new image is being displayed. We used Bing’s webmaster tools and requested a recrawl of the page even though the cached version is showing the new image to be sure Bing’s cache was updated. When you right click and copy the image URL for the thumbnail during the News link creation process above, the URL seems to hint that maybe it’s going out to Bing’s API to get the thumbnail: https://www.bing.com/th?id=OVP.c4B_14v2FtlHM9FJ3RVJlQEsBl&pid=Api This is the image that should be displaying: This is the image that’s being shown (an image that was on the page months ago): So, we have three questions: How does the News link process obtain the thumbnail?Why are we getting an old version of the thumbnail when the live and cached versions of the page are showing the new image?How do we fix it? We know we can override the image and manually upload the correct image. But we’d like to make it easier on content editors and have the current image pulled in without extra steps. Thanks for any tips you can send our way! Read More
Can’t edit Resource Groups Blocks
Hi,
I have actually Global Admin Role on my account, but I still can’t edit blocks on my resource groups.. I always get this error:
Can someone help me, please?
P.S.: The subscription hasn’t any block enabled.
Thanks,
Regards,
Salvatore
Hi,I have actually Global Admin Role on my account, but I still can’t edit blocks on my resource groups.. I always get this error: Can someone help me, please? P.S.: The subscription hasn’t any block enabled. Thanks,Regards,Salvatore Read More
Edge Dev (latest version) crashes when autofill tries to open
Hey there,
Yesterday i spoke with a guy from Microsoft’s Support (the official one ofcourse) for like.. 4 hours… trying to resolve my Microsoft Edge crashing and the autofill on several websites (including microsoft.com itself) to not function, like.. it pops up but i can’t press any of the saved items.
Does anyone.. have a clue at all? The Support person already tried reinstalling, clearing cookies, cache, extensions etc etc.. it’s just not working.
I’m honestly clueless.
Hey there, Yesterday i spoke with a guy from Microsoft’s Support (the official one ofcourse) for like.. 4 hours… trying to resolve my Microsoft Edge crashing and the autofill on several websites (including microsoft.com itself) to not function, like.. it pops up but i can’t press any of the saved items. Does anyone.. have a clue at all? The Support person already tried reinstalling, clearing cookies, cache, extensions etc etc.. it’s just not working. I’m honestly clueless. Read More
How to change child’s multiplayer access on Windows Minecraft
My Daughter’s newly installed Minecraft has the Multiplayer button disabled. I understand this is set somewhere withing MS Family but have not been able to find it. I have read many posts on the forums directing to ‘Enable’ Minecraft, add Minecraft to the underage limit, or change the content settings. The only limit on Windows Minecraft I have access to is to Block or set a time limit.
Thank you
My Daughter’s newly installed Minecraft has the Multiplayer button disabled. I understand this is set somewhere withing MS Family but have not been able to find it. I have read many posts on the forums directing to ‘Enable’ Minecraft, add Minecraft to the underage limit, or change the content settings. The only limit on Windows Minecraft I have access to is to Block or set a time limit. Thank you Read More
How to Update Intuit Data Protect to the Latest Version?
Hi everyone,
I’m currently using Intuit Data Protect for my Quick~Books backups and I’ve been notified that a new update is available. Can anyone guide me through the steps to update Intuit Data Protect to the latest version? Are there any specific precautions or prerequisites I need to be aware of before starting the update process?
Thanks in advance for your help!”
Hi everyone,I’m currently using Intuit Data Protect for my Quick~Books backups and I’ve been notified that a new update is available. Can anyone guide me through the steps to update Intuit Data Protect to the latest version? Are there any specific precautions or prerequisites I need to be aware of before starting the update process?Thanks in advance for your help!” Read More
Quicken Window Has Stopped Working – Any Solutions?
Hi everyone,
I’m having a frustrating issue with Quicken. Every time I try to open the program, I get an error message saying “Quicken window has stopped working.” I’ve tried restarting my computer and reinstalling Quicken, but nothing seems to help. Has anyone else experienced this problem? If so, how did you resolve it? Any suggestions would be greatly appreciated!
Thanks in advance!
Hi everyone,I’m having a frustrating issue with Quicken. Every time I try to open the program, I get an error message saying “Quicken window has stopped working.” I’ve tried restarting my computer and reinstalling Quicken, but nothing seems to help. Has anyone else experienced this problem? If so, how did you resolve it? Any suggestions would be greatly appreciated!Thanks in advance! Read More
Introducing the new file attachment scanner for Microsoft Tech Community
At Microsoft, we are always looking for ways to help our users stay safe and secure online. That’s why we are excited to announce the launch of our new file attachment scanner for the Microsoft Tech Community. This feature will scan any file that you want to upload to the community for viruses and malware, it will then alert you if there is a virus detected and remove the file.
We hope that this feature will help you feel more confident and secure when sharing files with other community members, and when accessing files from other sources. However, we also want to remind you that the file attachment scanner is not a substitute for your own vigilance and you should always treat any file that you download from the Microsoft Tech Community as potentially insecure, and scan it with your own antivirus software before opening it. The file attachment scanner is here to help you, but the ultimate responsibility to check files remains with you.
If you find any files the virus scanner has missed that you believe are malicious or harmful please do use the ‘report inappropriate content’ button next to the post and we will review it and decide what action, if any is needed.
If you have any questions or feedback about the attachment file scanner, please let us know in the comments below. We appreciate your support and participation in the Microsoft Tech Community, and we look forward to hearing from you.
Microsoft Tech Community – Latest Blogs –Read More
Microsoft Purview integrates with ChatGPT Enterprise Compliance API to support compliance
The use of generative AI has nearly doubled in the past six months, with 75% of global knowledge workers now integrating it into their daily tasks [1]. Employees are eager to use AI at work and are not waiting for their employers to catch up – in fact, 78% of employees surveyed admitted to bringing their own AI tools to the workplace [2]. However, this trend poses significant risks to company data, with cybersecurity and data privacy emerging as the top concern for leaders in the coming year [3]. To mitigate these risks, organizations need to adopt enterprise-ready solutions like Microsoft Copilot for Microsoft 365 and OpenAI’s ChatGPT Enterprise.
We’ve previously released Microsoft Purview capabilities to help customers discover, protect and govern data shared across generative AI applications, such as Copilot for Microsoft 365. Copilot is integrated into Microsoft 365 apps so that it understands a user’s work context, is grounded in Microsoft Graph to provide more personalized and relevant responses and can connect to business data sources to reason over all of user’s enterprise data. Copilot inherits Microsoft 365 controls and commitments, providing customers with comprehensive enterprise data protection. And with Microsoft Purview, Copilot customers receive real-time data security and compliance controls seamlessly integrated into their organization’s M365 deployment.
Additionally, we have released Microsoft Purview capabilities to discover, protect and govern data shared with custom-built AI apps built with Copilot Studio, as well as other third-party AI apps, such as Google Gemini, when used from a managed device.
Our goal is to deliver a comprehensive security platform that offers multi-cloud and multi-platform support. And extensibility plays a key part in our strategy to provide security for all leading generative AI applications. Today, we are excited to integrate some of our discovery and governance Microsoft Purview capabilities to OpenAI’s ChatGPT Enterprise Compliance API in private preview.
Discover sensitive data shared with ChatGPT Enterprise
Security teams often find themselves in the dark when it comes to data security risks associated with AI usage. A staggering 80% of leaders cite the leakage of sensitive data as their primary concern [3]. Additionally, more than 30% of decision makers admit they are unaware of the location or the nature of their sensitive, business critical data [4]. As generative AI produces an increasing volume of data, gaining visibility into what enterprise data is being shared with and generated by AI apps becomes crucial.
Microsoft Purview provides out-of-the-box integration with the ChatGPT Enterprise Compliance API, now available in private preview. This integration allows organizations to gain visibility into the prompts and responses from ChatGPT Enterprise, as well as the total number of users interacting with ChatGPT Enterprise and their associated risk level, pulled from Microsoft Purview Insider Risk Management. Based on these insights, customers can apply controls to any sensitive data being shared.
By integrating with ChatGPT Enterprise, Microsoft Purview helps to provide the critical visibility needed for organizations to capture and detect AI prompts and responses containing sensitive data.
Govern the use of ChatGPT Enterprise
In addition to security concerns, there is a growing focus on data compliance and concerns around unethical use of generative AI applications, which could result in regulatory violations and fines. Organizations need to proactively prepare for AI regulations and detect non-compliant use of AI.
This new integration will enable organizations to use Microsoft Purview Audit to capture ChatGPT Enterprise interactions and to configure Microsoft Purview Data Lifecycle Management retention policies for ChatGPT Enterprise prompts and responses.
Microsoft Purview Communication Compliance helps organizations proactively detect and mitigate safety and communication risks associated with ChatGPT Enterprise interactions such as hate or discrimination, corporate sabotage, sharing of credit card numbers or user login credentials, and more. These insights help organizations enforce compliance policies and support regulatory compliance.
Lastly, organizations can leverage Microsoft Purview eDiscovery to conduct legal investigations with the preservation and collection of relevant ChatGPT Enterprise data. This helps organizations manage their legal exposure and more efficiently respond to legal challenges.
Get Started
Reach out to your account manager to gain access to this private preview of OpenAI’s ChatGPT Enterprise Compliance API integration.
Learn more about our Microsoft Purview integrations with Copilot:
Secure your data to confidently take advantage of Copilot with Microsoft Purview
Microsoft Purview strengthens information protection for Copilot
Microsoft Purview supports compliance management for Copilot
Learn more about Microsoft Purview AI Hub here: Microsoft Purview data security and compliance protections for Microsoft Copilot and other generative AI apps | Microsoft Learn
Stay tuned for announcements coming soon on public preview availability.
Microsoft Tech Community – Latest Blogs –Read More
Study guide: GitHub Actions certification
Have you heard about the GitHub Actions certification? It’s a credential that validates your knowledge and skills in using the tool that allows you to automate workflows on GitHub.
In this article, we will learn about the main topics covered in the exam, the resources you can use to study, and the tips that will help you perform well. Are you ready to start your journey towards GitHub Actions certification?!
GitHub Actions is a feature of GitHub that allows you to automate tasks and workflows for your software development projects. You can use GitHub Actions to create, test, deploy, and monitor your code from GitHub. GitHub Actions uses YAML files called workflows to define the steps and triggers for your automation. You can run workflows on GitHub-hosted runners or on your own self-hosted runners. GitHub Actions also supports a rich ecosystem of actions, which are reusable units of code that you can use in your workflows or create and share with others.
The exam is tailored for DevOps engineers, software developers, and IT experts who have a mid-level understanding of GitHub Actions, covering workflows, automation, and managing CI/CD pipelines.
The GitHub Actions exam covers 4 domains:
Domain 1: Author and maintain workflows
Domain 2: Consume workflows
Domain 3: Author and maintain actions
Domain 4: Manage GitHub Actions for the enterprise
GitHub Foundations – your first step
Domains 2, 3, and 4 cover more advanced aspects of using GitHub for project management, developing custom actions, and deploying automated workflows. To achieve these objectives, it is necessary to have a solid understanding of GitHub’s basic concepts and work routines.
If you do not yet fully understand the basic concepts or work routines in GitHub, you can consult the learning path for GitHub Foundations certification on Microsoft Learn. There, you will find interactive modules that will help you understand and apply the essential functionalities of GitHub.
A few weeks ago, we hosted a GitHub Foundations series on the Microsoft Reactor YouTube channel. You can now watch the sessions on demand!
GitHub Actions – Learning path
On Microsoft Learn, we have a learning path for GitHub Actions certification, which includes free learning modules covering:
Automate development tasks by using GitHub Actions
Build continuous integration (CI) workflows by using GitHub Actions
Leverage GitHub Actions to publish to GitHub Packages
Create and publish custom GitHub actions
Build and deploy applications to Azure by using GitHub Actions
Manage GitHub Actions in the enterprise
To prepare for the certification exam, it is beneficial to integrate your studies with the materials available on Microsoft Learn and GitHub Docs.
Below are some useful links to study the four knowledge domains covered by the exam:
Domain 1: Author and maintain workflows
Workflow syntax for GitHub Actions
Events that trigger workflows
Configuring workflows
Using actions in workflows
Managing workflow runs
Workflow commands
Domain 2: Consume workflows
Interpreting the effects of a workflow
Viewing workflow run history and details
Workflow status badges
Domain 3: Author and maintain actions
Creating actions
Action metadata syntax
Domain 4: Manage GitHub Actions in the enterprise
Managing GitHub Actions in your enterprise
Setting up self-hosted runners
Managing access to self-hosted runners
I hope this GitHub Actions Certification Exam Study Guide helps you confidently navigate the exam and excel in implementing automated workflows on GitHub. Best of luck in achieving your certification and advancing your skills in DevOps and automation!
To learn more about the GitHub Certifications, please, visit the GitHub Certification Program FAQs and the Candidate Handbook.
Microsoft Tech Community – Latest Blogs –Read More
How to loop through a folder and convert all the tiff to png?
So I have a folder full of tiff images, and I want to convert all of them into png. How can I acheive this? I imagine that I need to use a for loop to go through every single image, but I am not sure about the converting part.
Excuse me if this is a simple question, I am quite a rookie of Matlab and I have tried searching online but nothing works.So I have a folder full of tiff images, and I want to convert all of them into png. How can I acheive this? I imagine that I need to use a for loop to go through every single image, but I am not sure about the converting part.
Excuse me if this is a simple question, I am quite a rookie of Matlab and I have tried searching online but nothing works. So I have a folder full of tiff images, and I want to convert all of them into png. How can I acheive this? I imagine that I need to use a for loop to go through every single image, but I am not sure about the converting part.
Excuse me if this is a simple question, I am quite a rookie of Matlab and I have tried searching online but nothing works. image processing, for loop MATLAB Answers — New Questions
What norm StepTolerance uses for multivariable?
I want to define a StepTolerance for the lsqnonlin with ‘trust-region-reflective’algorithm to solve a system of 4 variables, so X has dimension 4×1.
The documention Tolerance Details says that this algorithm uses a Absolute Step Tolerance.
In Tolerances and Stopping Criteria I found this:
"StepTolerance is a lower bound on the size of a step, meaning the norm of (xi – xi+1). If the solver attempts to take a step that is smaller than StepTolerance, the iterations end."
Is this norm the same of function norm, the Euclidean norm?I want to define a StepTolerance for the lsqnonlin with ‘trust-region-reflective’algorithm to solve a system of 4 variables, so X has dimension 4×1.
The documention Tolerance Details says that this algorithm uses a Absolute Step Tolerance.
In Tolerances and Stopping Criteria I found this:
"StepTolerance is a lower bound on the size of a step, meaning the norm of (xi – xi+1). If the solver attempts to take a step that is smaller than StepTolerance, the iterations end."
Is this norm the same of function norm, the Euclidean norm? I want to define a StepTolerance for the lsqnonlin with ‘trust-region-reflective’algorithm to solve a system of 4 variables, so X has dimension 4×1.
The documention Tolerance Details says that this algorithm uses a Absolute Step Tolerance.
In Tolerances and Stopping Criteria I found this:
"StepTolerance is a lower bound on the size of a step, meaning the norm of (xi – xi+1). If the solver attempts to take a step that is smaller than StepTolerance, the iterations end."
Is this norm the same of function norm, the Euclidean norm? lsqnonlin, tolerances, norm MATLAB Answers — New Questions
Trying to create a polynomial formula from xyz chart data where x and y equate to a z value.
I’m trying to create a polynomial formula it could be a 3rd degree to a 6th degree it doesn’t matter how long the formula is I just need it to be accurate and be able to extrapolate as accurately as possibly if the x or y data inputted is off the ends of the chart. Attached is the example of the data that I’m referencing I would like to get a code that I could edit and run myself as I have about 20 similar charts that I want to extrapolate a formula for. I need to be only a temp(y) and a humidity(x) and have the formula spit out (z) and it be accurate based off the chart.I’m trying to create a polynomial formula it could be a 3rd degree to a 6th degree it doesn’t matter how long the formula is I just need it to be accurate and be able to extrapolate as accurately as possibly if the x or y data inputted is off the ends of the chart. Attached is the example of the data that I’m referencing I would like to get a code that I could edit and run myself as I have about 20 similar charts that I want to extrapolate a formula for. I need to be only a temp(y) and a humidity(x) and have the formula spit out (z) and it be accurate based off the chart. I’m trying to create a polynomial formula it could be a 3rd degree to a 6th degree it doesn’t matter how long the formula is I just need it to be accurate and be able to extrapolate as accurately as possibly if the x or y data inputted is off the ends of the chart. Attached is the example of the data that I’m referencing I would like to get a code that I could edit and run myself as I have about 20 similar charts that I want to extrapolate a formula for. I need to be only a temp(y) and a humidity(x) and have the formula spit out (z) and it be accurate based off the chart. interpolation, curve fitting MATLAB Answers — New Questions
Why does my neural net data show up in R2021a but not in R2024a?
I have a 1×1 struct variable that contains 6 fields. Each field is a 1×1 CompactClassificationNeuralNetwork, results from a neural network I use to train on images for image segmentation. When I open this struct in MATLAB R2021a, the struct contains all 6 fields. When I open it in 2024a, the struct contains 6 empty fields. The data doesn’t appear. I have had trouble finding answers online. What might be the issue here?I have a 1×1 struct variable that contains 6 fields. Each field is a 1×1 CompactClassificationNeuralNetwork, results from a neural network I use to train on images for image segmentation. When I open this struct in MATLAB R2021a, the struct contains all 6 fields. When I open it in 2024a, the struct contains 6 empty fields. The data doesn’t appear. I have had trouble finding answers online. What might be the issue here? I have a 1×1 struct variable that contains 6 fields. Each field is a 1×1 CompactClassificationNeuralNetwork, results from a neural network I use to train on images for image segmentation. When I open this struct in MATLAB R2021a, the struct contains all 6 fields. When I open it in 2024a, the struct contains 6 empty fields. The data doesn’t appear. I have had trouble finding answers online. What might be the issue here? neural network, image segmentation MATLAB Answers — New Questions
E-mail notifications of canceled SQL Server Agent job should include the name of the Azure MI
Dear Community,
In our Azure Managed Instances we use the SQL Server Agent for maintenance tasks and for checks. If these jobs are canceled for any reason, they inform you about this cancellation by email.
Notifications have been configured in the job properties for this purpose.
However, the mail that is sent in such a case does not show in the subject which Azure MI it was sent from:
Example: If a job in the Azure MI “my-azure-mi-1.e4f0d600e52e.database.windows.net” aborts, we receive an email with the subject “[The job failed.] SQL Server Job System: ‘klesstest’ completed on \DB8C1B7BCF28BD9A3.”
In the future, we will operate a larger number (>30) of Azure Mis, we are dependent on knowing which Azure MI is affected when jobs are canceled.
We would like to see the email notifications about a canceled SQL Server Agent job include the name of the Azure Managed Instance in the subject of the email and not the hostname where the SQL Server Agent service is running.
The problem can be alleviated somewhat by including an explicit “mail-in-case-of-job-step-failed” in the job and adapting the “on-failure-action” in the individual steps so that it forwards to the “mail-in-case-of-job-step-failed” step.
In step ““mail-in-case-of-job-step-failed” you can control the subject of the mail when using
[msdb].[dbo].[sp_send_dbmail] and include @@servername in the subject of your mail.
Nevertheless, you cannot completely do without the standard notification ob the SQL Server Agent Jobs and the problem is exacerbated with a growing number of custom Azure MIs
Please vote for this request.
Kind regards,
Michael
Dear Community, In our Azure Managed Instances we use the SQL Server Agent for maintenance tasks and for checks. If these jobs are canceled for any reason, they inform you about this cancellation by email. Notifications have been configured in the job properties for this purpose. However, the mail that is sent in such a case does not show in the subject which Azure MI it was sent from: Example: If a job in the Azure MI “my-azure-mi-1.e4f0d600e52e.database.windows.net” aborts, we receive an email with the subject “[The job failed.] SQL Server Job System: ‘klesstest’ completed on \DB8C1B7BCF28BD9A3.” In the future, we will operate a larger number (>30) of Azure Mis, we are dependent on knowing which Azure MI is affected when jobs are canceled. We would like to see the email notifications about a canceled SQL Server Agent job include the name of the Azure Managed Instance in the subject of the email and not the hostname where the SQL Server Agent service is running. The problem can be alleviated somewhat by including an explicit “mail-in-case-of-job-step-failed” in the job and adapting the “on-failure-action” in the individual steps so that it forwards to the “mail-in-case-of-job-step-failed” step. In step ““mail-in-case-of-job-step-failed” you can control the subject of the mail when using [msdb].[dbo].[sp_send_dbmail] and include @@servername in the subject of your mail. Nevertheless, you cannot completely do without the standard notification ob the SQL Server Agent Jobs and the problem is exacerbated with a growing number of custom Azure MIs Please vote for this request. Kind regards,Michael Read More
Macro to search a list of words in multiple Excel files
Dear all,
I would be grateful if someone could provide me with the code for this problem, or point me in the right direction. I’ve tried a few codes but I haven’t managed to find a solution.
I have a list of words in column A of Sheet 1. I would like to search for each of these words in multiple Excel files which are saved in one folder. If any of the words are found in any of the Excel files, I would like to know in which file it was found. In Sheet1 the result would look like this:
Column A —- Column B
Peter —– File path/file name
John —– Not found
Mary —– File path/file name
Many thanks in advance,
Juan
Dear all,I would be grateful if someone could provide me with the code for this problem, or point me in the right direction. I’ve tried a few codes but I haven’t managed to find a solution. I have a list of words in column A of Sheet 1. I would like to search for each of these words in multiple Excel files which are saved in one folder. If any of the words are found in any of the Excel files, I would like to know in which file it was found. In Sheet1 the result would look like this: Column A —- Column BPeter —– File path/file nameJohn —– Not foundMary —– File path/file name Many thanks in advance,Juan Read More
SOLVED – Drag to “fill” not working — copies value and not formula – #2
I found this post title which describes the same issue:
drag to “fill” not working – value is copied, formula ignored
That solution is “missing a ‘relative’ reference”. I don’t think that’s the problem here.
I have an exported bookkeeping account worksheet with three columns: Debit, Credit, Balance. I’m looking for missing transactions and short payments. All of the cells currently are values, and this is the only formula.
First, I’m inserting a blank line, and adding an adjusting calculation (A).
Then I update the Balance column with a simple formula (B) to create a running balance with DR – CR.–bog simple.
For a reason I can’t understand, when I drag the corner handle down to lower cells (C), Excel correctly copies the cell formula with incrementing references (D), but it flags an error and displays the same value.
Did I accidentally click a Bizzaro-World keyboard shortcut? What is going on here and how do I fix it?
I found this post title which describes the same issue:drag to “fill” not working – value is copied, formula ignoredThat solution is “missing a ‘relative’ reference”. I don’t think that’s the problem here. I have an exported bookkeeping account worksheet with three columns: Debit, Credit, Balance. I’m looking for missing transactions and short payments. All of the cells currently are values, and this is the only formula. First, I’m inserting a blank line, and adding an adjusting calculation (A).Then I update the Balance column with a simple formula (B) to create a running balance with DR – CR.–bog simple. For a reason I can’t understand, when I drag the corner handle down to lower cells (C), Excel correctly copies the cell formula with incrementing references (D), but it flags an error and displays the same value. Did I accidentally click a Bizzaro-World keyboard shortcut? What is going on here and how do I fix it? Read More
PSTN Usage not showing calls
We typically review PSTN usage from the Teams Admin center and pull any calling plan licenses from people who don’t appear to be using their plan. We recently had some people call to get their plan back because they state they definitely do use their plan and quite regularly.
So, how does someone who says they get 50-70 calls a day show “0” PSTN usage on the report.
She does get her calls forwarded from a calling Q, but shouldn’t that still track calling plan minutes? Am I looking in the wrong spot?
We typically review PSTN usage from the Teams Admin center and pull any calling plan licenses from people who don’t appear to be using their plan. We recently had some people call to get their plan back because they state they definitely do use their plan and quite regularly. So, how does someone who says they get 50-70 calls a day show “0” PSTN usage on the report. She does get her calls forwarded from a calling Q, but shouldn’t that still track calling plan minutes? Am I looking in the wrong spot? Read More
Teams app and web running very slow. Phone is ok
Teams app and web are both not working and have the same issue.
Phone has issues as well but, I can live with it losing connection.
– I can not send messages quickly and can not send photos at all.
– It acts like the internet speed is slow.
– This is only a problem in Texas. It works in WI and OH.
– PC performance is running perfect and my internet speed is 50mbps
– I have tried all the obvious fixes.
– This is the second computer with the same issue. It’s not the computer
Please help.. its killing my ability to function
Teams app and web are both not working and have the same issue.Phone has issues as well but, I can live with it losing connection. – I can not send messages quickly and can not send photos at all.- It acts like the internet speed is slow.- This is only a problem in Texas. It works in WI and OH.- PC performance is running perfect and my internet speed is 50mbps – I have tried all the obvious fixes. – This is the second computer with the same issue. It’s not the computerPlease help.. its killing my ability to function Read More
My business does not appear in local results.
Hello.
I was considering buying some Bing advertising for my business, but I noticed that my business does not appear in the local results at all. It does however appear in the 1st place position just below the local results. Unfortunately, just about everyone will call the businesses that appear in the local results.
I’ve confirmed my address and everything looks good in Bing Places For Business. I’ve been in business for almost 30 years and have had the 1st place position in Google local results for at least 10 years. I synced my business with my Google account about 3 months ago, but that didn’t help.
Any help or suggestions are greatly appreciated 🙂
Hello.I was considering buying some Bing advertising for my business, but I noticed that my business does not appear in the local results at all. It does however appear in the 1st place position just below the local results. Unfortunately, just about everyone will call the businesses that appear in the local results.I’ve confirmed my address and everything looks good in Bing Places For Business. I’ve been in business for almost 30 years and have had the 1st place position in Google local results for at least 10 years. I synced my business with my Google account about 3 months ago, but that didn’t help.Any help or suggestions are greatly appreciated 🙂 Read More