Tag Archives: microsoft
How to Fix QuickBooks Error 3371 status code 1 after update?
Troubleshooting Solutions: QuickBooks Error 3371 status code 1
QuickBooks Error 3371 status code 1 typically occurs when the software is unable to initialize the license properties, commonly due to missing or damaged files. Here are some troubleshooting steps to resolve this issue efficiently:
Update QuickBooks: Ensure you’re using the latest version of QuickBooks. Updates often include bug fixes and patches that can address error codes like 3371.Run QuickBooks Install Diagnostic Tool: Intuit provides a diagnostic tool specifically designed to troubleshoot installation issues. Download and run this tool to identify and fix problems with your QuickBooks installation.Recreate Damaged EntitlementDataStore.ecml File: This file stores your license information. Corrupt or damaged files can trigger Error 3371. To recreate it, close QuickBooks, press Windows + R to open the Run command, type “%ProgramData%IntuitEntitlement Clientv8” (without quotes), and hit Enter. Delete the EntitlementDataStore.ecml file, restart QuickBooks, and re-register the product.Manually Resolve Windows Components: Sometimes, certain Windows components necessary for QuickBooks to function properly might be damaged or missing. Ensure that your Windows operating system is up to date and perform a repair on Microsoft .NET Framework, MSXML, and C++.Update Windows: Keeping your Windows OS updated ensures that all necessary components are current, reducing the likelihood of compatibility issues.Resolve Third-Party Software Conflicts: Conflicts with antivirus or anti-malware software can interfere with QuickBooks operations. Temporarily disable such software and try opening QuickBooks again.Reinstall QuickBooks Using Clean Install: If none of the above steps resolve the issue, perform a clean reinstall of QuickBooks. Uninstall QuickBooks from your system, rename the installation folders, reinstall QuickBooks, and update it to the latest version.Seek Technical Support: If you’ve exhausted all troubleshooting steps and still encounter Error 3371, consider reaching out to QuickBooks technical support. They may provide additional guidance or assistance in resolving the issue.
By following these troubleshooting solutions, you can effectively address QuickBooks Error 3371 status code 1 and resume normal operation of the software without further interruption. Remember to back up your company file before making any significant changes to ensure data integrity.
Troubleshooting Solutions: QuickBooks Error 3371 status code 1 QuickBooks Error 3371 status code 1 typically occurs when the software is unable to initialize the license properties, commonly due to missing or damaged files. Here are some troubleshooting steps to resolve this issue efficiently: Update QuickBooks: Ensure you’re using the latest version of QuickBooks. Updates often include bug fixes and patches that can address error codes like 3371.Run QuickBooks Install Diagnostic Tool: Intuit provides a diagnostic tool specifically designed to troubleshoot installation issues. Download and run this tool to identify and fix problems with your QuickBooks installation.Recreate Damaged EntitlementDataStore.ecml File: This file stores your license information. Corrupt or damaged files can trigger Error 3371. To recreate it, close QuickBooks, press Windows + R to open the Run command, type “%ProgramData%IntuitEntitlement Clientv8” (without quotes), and hit Enter. Delete the EntitlementDataStore.ecml file, restart QuickBooks, and re-register the product.Manually Resolve Windows Components: Sometimes, certain Windows components necessary for QuickBooks to function properly might be damaged or missing. Ensure that your Windows operating system is up to date and perform a repair on Microsoft .NET Framework, MSXML, and C++.Update Windows: Keeping your Windows OS updated ensures that all necessary components are current, reducing the likelihood of compatibility issues.Resolve Third-Party Software Conflicts: Conflicts with antivirus or anti-malware software can interfere with QuickBooks operations. Temporarily disable such software and try opening QuickBooks again.Reinstall QuickBooks Using Clean Install: If none of the above steps resolve the issue, perform a clean reinstall of QuickBooks. Uninstall QuickBooks from your system, rename the installation folders, reinstall QuickBooks, and update it to the latest version.Seek Technical Support: If you’ve exhausted all troubleshooting steps and still encounter Error 3371, consider reaching out to QuickBooks technical support. They may provide additional guidance or assistance in resolving the issue. By following these troubleshooting solutions, you can effectively address QuickBooks Error 3371 status code 1 and resume normal operation of the software without further interruption. Remember to back up your company file before making any significant changes to ensure data integrity. Read More
Monitor Azure VM Linux Mount Point Availablity
Hi Team,
Sorry if it’s a very basic question.
Could you please suggest how can we monitor mounted disks on Azure VM for its availability?
In past especially in case of On-Prem setup, we’ve faced and issue where due to some changes or patches etc. the mounted disks go missing.
And hence want to monitor and setup alert for the same in case those are missing.
Could you please suggest if there’s a way to do so, may be via some KQL using VM Insights or any other simpler solution?
Thanks.
Hi Team, Sorry if it’s a very basic question.Could you please suggest how can we monitor mounted disks on Azure VM for its availability? In past especially in case of On-Prem setup, we’ve faced and issue where due to some changes or patches etc. the mounted disks go missing. And hence want to monitor and setup alert for the same in case those are missing. Could you please suggest if there’s a way to do so, may be via some KQL using VM Insights or any other simpler solution? Thanks. Read More
How do I fix QuickBooks Error 3371 status code 11104 after update?
Troubleshooting Solutions: QuickBooks Error 3371 status code 11104
QuickBooks Error 3371 status code 11104 typically arises due to issues with the software’s licensing or damaged components. Here are some effective troubleshooting steps to resolve this error promptly:
Update QuickBooks: Start by ensuring that your QuickBooks software is up to date. Installing the latest updates often includes bug fixes and patches that can address error codes like 3371.Run QuickBooks Install Diagnostic Tool: Intuit provides a diagnostic tool designed to identify and resolve installation issues. Download and run this tool to diagnose and fix any problems with your QuickBooks installation.Recreate EntitlementDataStore.ecml File: This file stores your QuickBooks license information. If it’s damaged or corrupted, it can trigger Error 3371. Close QuickBooks, press Windows + R to open the Run command, type “%ProgramData%IntuitEntitlement Clientv8” (without quotes), and hit Enter. Delete the EntitlementDataStore.ecml file, restart QuickBooks, and re-register the product.Update Windows Components: Ensure that your Windows operating system is up to date, including components like Microsoft .NET Framework, MSXML, and C++. Outdated or damaged Windows components can interfere with QuickBooks functionality.Perform a Clean Install of QuickBooks: If the issue persists, consider performing a clean reinstall of QuickBooks. Uninstall QuickBooks from your system, rename the installation folders, reinstall QuickBooks, and then update it to the latest version.Check for Third-Party Software Conflicts: Sometimes, conflicts with third-party software such as antivirus or anti-malware programs can cause issues with QuickBooks. Temporarily disable these programs and try opening QuickBooks again to see if the error persists.Repair QuickBooks Installation: Use the Control Panel to repair your QuickBooks installation. Go to Control Panel > Programs and Features, select QuickBooks from the list, and click on Repair. Follow the on-screen instructions to complete the repair process.Seek Technical Support: If you’ve tried all the troubleshooting steps above and are still experiencing Error 3371 status code 11104, consider contacting QuickBooks technical support for further assistance. They can provide personalized guidance and help you resolve the issue.
By following these troubleshooting solutions, you can effectively address QuickBooks Error 3371 status code 11104 and resume normal operation of the software without further interruption. Remember to back up your company file before making any significant changes to ensure data integrity.
Troubleshooting Solutions: QuickBooks Error 3371 status code 11104 QuickBooks Error 3371 status code 11104 typically arises due to issues with the software’s licensing or damaged components. Here are some effective troubleshooting steps to resolve this error promptly: Update QuickBooks: Start by ensuring that your QuickBooks software is up to date. Installing the latest updates often includes bug fixes and patches that can address error codes like 3371.Run QuickBooks Install Diagnostic Tool: Intuit provides a diagnostic tool designed to identify and resolve installation issues. Download and run this tool to diagnose and fix any problems with your QuickBooks installation.Recreate EntitlementDataStore.ecml File: This file stores your QuickBooks license information. If it’s damaged or corrupted, it can trigger Error 3371. Close QuickBooks, press Windows + R to open the Run command, type “%ProgramData%IntuitEntitlement Clientv8” (without quotes), and hit Enter. Delete the EntitlementDataStore.ecml file, restart QuickBooks, and re-register the product.Update Windows Components: Ensure that your Windows operating system is up to date, including components like Microsoft .NET Framework, MSXML, and C++. Outdated or damaged Windows components can interfere with QuickBooks functionality.Perform a Clean Install of QuickBooks: If the issue persists, consider performing a clean reinstall of QuickBooks. Uninstall QuickBooks from your system, rename the installation folders, reinstall QuickBooks, and then update it to the latest version.Check for Third-Party Software Conflicts: Sometimes, conflicts with third-party software such as antivirus or anti-malware programs can cause issues with QuickBooks. Temporarily disable these programs and try opening QuickBooks again to see if the error persists.Repair QuickBooks Installation: Use the Control Panel to repair your QuickBooks installation. Go to Control Panel > Programs and Features, select QuickBooks from the list, and click on Repair. Follow the on-screen instructions to complete the repair process.Seek Technical Support: If you’ve tried all the troubleshooting steps above and are still experiencing Error 3371 status code 11104, consider contacting QuickBooks technical support for further assistance. They can provide personalized guidance and help you resolve the issue. By following these troubleshooting solutions, you can effectively address QuickBooks Error 3371 status code 11104 and resume normal operation of the software without further interruption. Remember to back up your company file before making any significant changes to ensure data integrity. Read More
Is it possible to use previous answer in a new question?
Hi,
Say I have Q1 to be What is your first name?
I then want Q2 to be How did you find out about us, <Q1 Answer>?
Is this possible?
Thanks
Todd
Hi,Say I have Q1 to be What is your first name?I then want Q2 to be How did you find out about us, <Q1 Answer>?Is this possible?ThanksTodd Read More
ingest iot device data directly from tcp or udp stream?
Hi all,
Newbie question. We have some existing scada iot type devices that send basic telemetry data to a propriety database system that is very old. The tcp or udp data is unencrypted and unauthenticated, and easily decoded and read with wireshark. I’m wondering if there is something in the Azure IoT world that can be deployed to listen on a tcp port for the network stream of data, and then be configured to decode this data, and then send it off to Azure for reporting?
Thanks
Hi all, Newbie question. We have some existing scada iot type devices that send basic telemetry data to a propriety database system that is very old. The tcp or udp data is unencrypted and unauthenticated, and easily decoded and read with wireshark. I’m wondering if there is something in the Azure IoT world that can be deployed to listen on a tcp port for the network stream of data, and then be configured to decode this data, and then send it off to Azure for reporting? Thanks Read More
Train a simple Recommendation Engine using the new Azure AI Studio
Hi, everyone! I am Paschal Alaemezie, a Gold Microsoft Learn Student Ambassador. I am a student at the Federal University of Technology, Owerri (FUTO). I am interested in Artificial Intelligence, Software Engineering, and Emerging technologies, and how to apply the knowledge from these technologies in writing and building cool solutions to the challenges we face. Feel free to connect with me on LinkedIn and GitHub or follow me on X (Twitter).
In my previous article, I wrote about Recommendation Engines and gave a walkthrough on how to train a simple recommendation engine using the Azure Machine Learning Designer via the Azure portal. In this article, I will give a walkthrough on how to replicate this training using Azure Machine Learning Designer via the new Azure AI Studio.
The new Azure AI Studio is a comprehensive platform designed to facilitate the development, management, and deployment of AI applications. It offers a user-friendly interface with drag-and-drop capabilities for model creation, alongside advanced features for model management and scalability. The platform supports automated machine learning to optimize model selection and tuning. It is suitable for creating custom AI solutions, including chatbots and other AI-driven applications, with a focus on collaboration, efficiency, and responsible AI practices. Azure AI Studio is available in public preview, providing a glimpse into the future of AI development tools.
An Azure subscription is required to carry out the activities in this article. If you are a student, you can use your university or school email to sign up for a free Azure for Students account and start building on the Azure cloud with a free $100 Azure credit.
Activity 1: Create a New Training Pipeline
Step 1: Setting up your Azure AI Studio workspace
Open your web browser and go to ai.azure.com to open the new Azure AI Studio
Go to Build on the Azure AI Studio and click on it to open the Build environment. Then click on + New project button to open the Create a project environment.
Step 2: Creating your project
For the Project details section:
At Hub name, key in your preferred name for your project’s hub in the input box provided.
At Subscription, select your existing subscription from the drop-down menu.
Select your Resource group. If you have any existing resource group, select it from the drop-down menu. Otherwise, click on Create new to create a new resource group, and click OK after that.
At Location, select your location from the drop-down menu. Then, click on the Next button at the bottom of the screen to go to the Review and finish.
At the Review and finish section, click on Create a project button at the bottom of the screen to provision your workspace on Azure AI Studio.
Your provisioned workspace will display the window below. Go to the All Azure AI at the upper right of the screen and select the Azure Machine Learning Studio from the drop-down menu.
In the Azure Machine Learning studio, select Designer from the navigation pane on the left-hand side. This will open the Designer environment where you can select a new pipeline if there is no existing pipeline.
In the Designer environment, select the Classic prebuilt component. Then click on the Create a new pipeline using classic prebuilt components. This will open a visual pipeline authoring editor.
Step 3: Add Sample Datasets
In the left navigation pane of the Authoring editor, click the Asset library and go to the Component section. Under Component, click on Sample data.
In the Sample data, scroll down to the Movie Ratings, and IMDB Movie Titles. Drag and drop the selected datasets onto the canvas.
Step 4: Join the two datasets on Movie ID
Close the Sample data drop-down menu. From the Data Transformation section in the left navigation, select the Join Data prebuilt module, and drag and drop the selected module onto the canvas
Connect the output of the Movie Ratings module to the first input of the Join Data module.
Connect the output of the IMDB Movie Titles module to the second input of the Join Data module.
Select the Join Data module. Click the navigation button at the upper right of the canvas to open the Join Data module window.
Select the Edit column link to open the Join key columns for the left dataset editor. Select the MovieId column in the Enter column name field and click Save.
Select the Edit column link to open the Join key columns for the right dataset editor. Select the Movie ID column in the Enter column name field and click Save. Then, close the Join Data window.
Step 5: Select Columns UserId, Movie Name, and Rating using a Python script
From the Python Language section in the left navigation, select the Execute Python Script prebuilt module. Drag and drop the selected module onto the canvas. Then, connect the Join Data output to the input of the Execute Python Script module.
Select Edit code to open the Python script editor, clear the existing code and then enter the following lines of code to select the UserId, Movie Name, and Rating columns from the joined dataset. Ensure best practice by indenting only the second and third lines of your code.
Step 6: Remove duplicate rows with the same Movie Name and UserId
From the Data Transformation section in the left navigation pane, select the Remove Duplicate Rows prebuilt module from the drop-down menu, and drag and drop the selected module onto the canvas.
Connect the first output of the Execute Python Script to the input of the Remove Duplicate Rows module.
Select the Edit column link to open the Select column editor. Click the navigation button at the upper right of the canvas to open the Remove Duplicate Rows module window.
Enter the following list of columns to be included in the output dataset: Movie Name, UserId. Then, click Save.
Step 7: Split the dataset into a training set (0.5) and a test set (0.5)
From the Data Transformation section in the left navigation select the Split Data prebuilt module and drag and drop the selected module onto the canvas, then connect the Dataset to the Split Data module.
Click the navigation button at the upper right of the canvas to open the Split Data module window. Ensure that the Fraction of rows in the first output dataset: 0.5
Step 8: Initialize Recommendation Module
From the Recommendation section in the left navigation pane, select the Train SVD Recommender prebuilt module and drag and drop the selected module onto the canvas. Then, connect the first output of the Split Data module to the input of the Train SVD Recommender module.
Click the navigation button at the upper right of the canvas to open the Train SVD Recommender module window. Set Number of factors: 200. This option specifies the number of factors to use with the recommender.
Number of recommendation algorithm iterations: 30. This number indicates how many times the algorithm should process the input data. The default value is 30.
For Learning rate: 0.001. The learning rate defines the step size for learning.
Step 9: Select Columns UserId, Movie Name from the test set
From the Data Transformation section in the left navigation pane, select the Select Columns in Dataset prebuilt module and drag and drop the selected module onto the canvas. Then, connect the Split Data second output to the input of the Select columns in Dataset module.
Click the navigation button at the upper right of the canvas to open the Select Columns in Dataset module window. Select the Edit column link to open the Select columns editor.
Enter the following list of columns to be included in the output dataset: UserId, Movie Name and Click Save.
Step 10: Configure the Score SVD Recommender
From the Recommendation section in the left navigation pane, select the Score SVD Recommender prebuilt module and drag and drop the selected module onto the canvas
Connect the output of the Train SVD Recommender module to the first input of the Score SVD Recommender module, which is the Trained SVD recommendation input.
Connect the output of the Select Columns in Dataset module to the second input of the Score SVD Recommender module, which is the Dataset to score input.
Open the Score SVD Recommender module on the canvas by clicking on the navigation button at the upper right of the canvas. Set the Recommender prediction kind: Rating Prediction. For this option, no other parameters are required.
Step 11: Setup Evaluate Recommender Module
From the Recommendation section in the left navigation pane, select the Evaluate Recommender prebuilt module and drag and drop the selected module onto the canvas.
Connect the Score SVD Recommender module to the second input of the Evaluate Recommender module, which is the Scored dataset input.
Connect the second output of the Split Data module (train set) to the first input of the Evaluate Recommender module, which is the Test dataset input.
Activity 2: Submit Training Pipeline
In the Authoring editor, ensure that you have AutoSave enabled. Then click on Configure & Submit at the upper right-hand side of your screen.
For the Set up pipeline job window: In the Basics section, click the Create new button under the Experiment name. Type your new experiment name and click the Next button at the bottom of the screen.
In the Inputs & outputs section, click the Next button at the bottom of the screen.
In the Runtime settings section: skip the Default compute. Go to the select compute type and select Compute instance from the drop-down menu. Under the Select Azure ML compute instance, click on Create Azure ML compute instance. The Create compute instance will open in another environment.
In the Create compute instance window, type in your compute name under the Compute name tab. Then, select the CPU button under the Virtual machine type.
While authoring this article, I had to select my virtual machine first to enable the Compute name tab. You may or may not encounter this issue. I selected the Standard_D2_v2 virtual machine for this training. After that, click the Review + Create button at the end of the screen, to take you back to the Runtime settings window.
Back to the Runtime settings window. At the Select Azure ML compute instance, Select the compute instance that you have created. Here, I selected the movie instance from the drop-down menu. Note that your newly created compute instance will take some time to be provisioned and appear in your drop-down menu. Go to the Advanced settings and ensure that the Continue on step failure box is checked. Then, click the Review + Submit button at the end of the screen.
At the Review + Submit section, ensure that your provided details are correct. Then, click the Submit button at the end of the screen.
Activity 3: Visualize Scoring Results
Step 1: When your pipeline is submitted and your model training is completed, at the left navigation pane, go to Jobs under Asset and click on the name of your completed pipeline.
Step 2: Visualize the Scored dataset
Go to the Score SVD Recommender module on the canvas and right-click on it. Select Preview data and click on Scored dataset.
Observe the predicted values under the column Rating.
Step 3: Visualize the Evaluation Results
Go to the Evaluate Recommender module on the canvas and right-click on it. Select Preview data and click on Metric.
Evaluate the model performance by reviewing the various evaluation metrics, such as Mean Absolute Error, Root Mean Squared Error, etc.
Next step
Congratulations, on making it this far. Stay tuned for my next blog on the amazing solutions you can build using the Azure AI Studio.
For enthusiasts and professionals alike, you can leverage these resources to stay informed and inspired as you embark on your AI journey:
Microsoft AI Discord Community is a dynamic space to discuss and share AI-related insights.
Global AI Community offers a platform to connect with peers worldwide.
Azure Samples provides practical code examples to enhance your projects.
Microsoft AI Show delivers the latest updates in AI technology.
ML for Begineers Open Source Course and Curricula
Microsoft Tech Community – Latest Blogs –Read More
“Manifest parsing has failed” while running teams message extension locally.
Hi,
I wanted to add “samplePrompts” property to my manifest json which requires manifest version v1.17. I’ve changed the schema and version from v1.16 to v1.17. Also removed “packageName” property from manifest json file as v1.17 is not supported the “packageName” property. After that, I tried to run the message extension locally however I am getting below error.
When I clicked to “Copy error details to clipboard”, it give me “packageName | Property “packageName” has not been defined and the schema does not allow additional properties.” this error and unable to add message extension app.
Please let me know how can I fix it.
Hi,I wanted to add “samplePrompts” property to my manifest json which requires manifest version v1.17. I’ve changed the schema and version from v1.16 to v1.17. Also removed “packageName” property from manifest json file as v1.17 is not supported the “packageName” property. After that, I tried to run the message extension locally however I am getting below error. When I clicked to “Copy error details to clipboard”, it give me “packageName | Property “packageName” has not been defined and the schema does not allow additional properties.” this error and unable to add message extension app. Please let me know how can I fix it. Read More
Microsoft Edge only opens PDF. Can’t default to any other program.
I have Adobe Acrobat Pro installed. For some reason, edge is the default program. I have tried to change this and have had zero success. When I select any other program but edge, it will default back to edge.
On the side, it says that an error has occurred and it defaults back to edge. Can someone please help me it’s infuriating. Never had this issue before.
I have Adobe Acrobat Pro installed. For some reason, edge is the default program. I have tried to change this and have had zero success. When I select any other program but edge, it will default back to edge. On the side, it says that an error has occurred and it defaults back to edge. Can someone please help me it’s infuriating. Never had this issue before. Read More
Recommendation – Microsoft 365 authorisation concepts – Part 2
[New Blog Post]
*PART 2!*
I have put a new article online. This article is divided into two parts.
In the second part, we take a closer look at the configuration of #AdministrativeUnits and #ExchangeOnline, as well as a possible training concept.
https://www.msb365.blog/?p=5503
#MVPbuzz #M365 #Microsoft365 #CommunityRocks #EntraID
[New Blog Post]
*PART 2!*
I have put a new article online. This article is divided into two parts.
In the second part, we take a closer look at the configuration of #AdministrativeUnits and #ExchangeOnline, as well as a possible training concept.
https://www.msb365.blog/?p=5503
#MVPbuzz #M365 #Microsoft365 #CommunityRocks #EntraID
Sharing temporary data under %appData% of MSIX app with MSI application
Dear Members,
My App is .Net Framework 4.8.1 based WPF app.
Packaged in MSIX installer to distribute as Store App.
I have a use case to share temporary file data created by WPF packaged app with other desktop application. This is temporary data which will be created while executing a feature and will be deleted after completion of feature execution.
When data is kept under %appdata%/ LocalCache, it is accessible by other desktop application.
Does this kind of sharing violates any Appx principles or rules of Store App?
Thank you.
Dear Members, My App is .Net Framework 4.8.1 based WPF app.Packaged in MSIX installer to distribute as Store App. I have a use case to share temporary file data created by WPF packaged app with other desktop application. This is temporary data which will be created while executing a feature and will be deleted after completion of feature execution. When data is kept under %appdata%/ LocalCache, it is accessible by other desktop application.Does this kind of sharing violates any Appx principles or rules of Store App? Thank you. Read More
Question about moving SSD to new build
I have a 2 TB Samsung SSD from my old pc that died and I want to add to new pc with Windows 10 currently the operating system. The question I have is would it cause any issues to just install it and then format the thing? Most of what is on it is also on new I just want the extra storage.
I have a 2 TB Samsung SSD from my old pc that died and I want to add to new pc with Windows 10 currently the operating system. The question I have is would it cause any issues to just install it and then format the thing? Most of what is on it is also on new I just want the extra storage. Read More
Form to allow user to colour fill cells of their choice
I would like to include a feature in my spreadsheet. In cell B2 I have a list form, showing the options “O.P”, “C.P” and “P.S.P”. Underneath in cells B3 to E3 are two rows of the following options “Socials”, “Alert”, “Going” and “Subscription”. Photo below for example.
I have already formatted each of the cells from B3 to E4 to display their respective text, dependent on the value in B2. So when either of the options are selected in the form in B2, the cells underneath will display the same word text. For example, the formula I have used in cell B4 is this “=IF(B2=”O.P”,”Socials”,IF(B2=”C.P”,”Socials”,IF(B2=”P.S.P”,”Socials”,””))) “.
Everything works fine when switching between the forms. What I need to include is a feature where the user can choose any of the options in B2 and colour fill in the cells underneath as they need.
Right now when I do this, the colour filled cells stay the same across all of the options in B2. What I need is for the colour filled cells to stay the same, respective to the option in B2.
Ultimately, if the user is on the “O.P” option in B2, and they colour fill cells B3 and D3, then go to the “C.P” option in B2 and colour fill cells C3 and D3, when they go back to the “O.P” option, cells B3 and D3 will still be colour filled, and when they go back to the “C.P” option, cells C3 and D3 will still be colour filled.
How would I be able to include this feature in my spreadsheet please?
I would like to include a feature in my spreadsheet. In cell B2 I have a list form, showing the options “O.P”, “C.P” and “P.S.P”. Underneath in cells B3 to E3 are two rows of the following options “Socials”, “Alert”, “Going” and “Subscription”. Photo below for example. I have already formatted each of the cells from B3 to E4 to display their respective text, dependent on the value in B2. So when either of the options are selected in the form in B2, the cells underneath will display the same word text. For example, the formula I have used in cell B4 is this “=IF(B2=”O.P”,”Socials”,IF(B2=”C.P”,”Socials”,IF(B2=”P.S.P”,”Socials”,””))) “. Everything works fine when switching between the forms. What I need to include is a feature where the user can choose any of the options in B2 and colour fill in the cells underneath as they need. Right now when I do this, the colour filled cells stay the same across all of the options in B2. What I need is for the colour filled cells to stay the same, respective to the option in B2. Ultimately, if the user is on the “O.P” option in B2, and they colour fill cells B3 and D3, then go to the “C.P” option in B2 and colour fill cells C3 and D3, when they go back to the “O.P” option, cells B3 and D3 will still be colour filled, and when they go back to the “C.P” option, cells C3 and D3 will still be colour filled. How would I be able to include this feature in my spreadsheet please? Read More
Getting phone numbers in Teams
Hello
Please i need your help on this issue.
How do I get phone numbers via Microsoft for two or three of my employees?What are the steps and costs associated with this?
Hello Please i need your help on this issue. How do I get phone numbers via Microsoft for two or three of my employees?What are the steps and costs associated with this? Read More
Questions on implementation-
Hi there! We have a couple of questions on setting up access methods and user roles…
Can we put a generic URL in the body of the survey invite?Can we include videos in the body of the survey invite?If we allow access to a demographic variable, all users will have access to use it?How do we go about providing certain users access to specific demographic report? (i.e., providing division heads division reports)
Hi there! We have a couple of questions on setting up access methods and user roles…Can we put a generic URL in the body of the survey invite?Can we include videos in the body of the survey invite?If we allow access to a demographic variable, all users will have access to use it?How do we go about providing certain users access to specific demographic report? (i.e., providing division heads division reports) Read More
New Outlook and Calendar aren’t synched?
Hello,
I was recently forced to switch from the Calendar app to Outlook.
Several important features no longer work like the following.
Neither shows up in the other suddenly. Also I can’t NOT use Outlook. So if I create events in Outlook I can’t see them in the other.
Also if I create events in the other, not only can I not see them in Outlook, but I also can’t seem to delete/modify them either?
The little calendar pop up in the bottom right is one of the most useful and seamless features I’ve used.
How do I restore this feature?
Hello,I was recently forced to switch from the Calendar app to Outlook.Several important features no longer work like the following.Neither shows up in the other suddenly. Also I can’t NOT use Outlook. So if I create events in Outlook I can’t see them in the other.Also if I create events in the other, not only can I not see them in Outlook, but I also can’t seem to delete/modify them either?The little calendar pop up in the bottom right is one of the most useful and seamless features I’ve used.How do I restore this feature? Read More
Connect more deeply with the Teams SMB product team
Would you like to join other SMBs in small group discussions with direct access to the Teams feature teams? Would you be willing to share feedback and customer stories with our Teams SMB Research team? Are you interested in joining private preview programs for Teams SMB features? If so, we want to hear from you!
The following opportunities are available to our small businesses as a way to connect with the Teams SMB product team on a regular basis:
Teams Customer Council for SMBs (aka TCC)
Description: Teams Engineering is extending a special invitation to customers and partners who have 2-300 employees and hold an active Microsoft 365 subscription. Join our Council to explore upcoming Teams scenarios and provide valuable feedback. This is a program that requires an NDA agreement (non-disclosure) to be included in Teams conversations and bi-weekly forum calls.
Sign-up link: https://aka.ms/TeamsCouncil
M365 and Copilot SMB Champions Community
Description: Join our non-NDA SMB Champions community for Copilot and SMB M365 discussions. This Champions community will provide direct access to product teams during a monthly call where you can learn about new features and share your feedback.
Sign-up link: http://aka.ms/smbcommunitysignup
Champions community discussion board (meeting details also shared here): https://techcommunity.microsoft.com/t5/smb-microsoft-365-champion/bd-p/SMBM365ChampionProgram
Teams for Small Business Research
Description: The Teams SMB Research team is looking for small businesses who would be interested in joining future research sessions. These panels will be held virtually and you may choose to participate or decline individual studies or leave the panel at any time. Some studies include a thank you gift for participation.
Sign-up link: https://forms.office.com/r/qPYYJjm3df
Keep a watch on this discussion space (https://aka.ms/TeamsSMBCommunity) for a growing set of opportunities.
Would you like to join other SMBs in small group discussions with direct access to the Teams feature teams? Would you be willing to share feedback and customer stories with our Teams SMB Research team? Are you interested in joining private preview programs for Teams SMB features? If so, we want to hear from you!
The following opportunities are available to our small businesses as a way to connect with the Teams SMB product team on a regular basis:
Teams Customer Council for SMBs (aka TCC)
Description: Teams Engineering is extending a special invitation to customers and partners who have 2-300 employees and hold an active Microsoft 365 subscription. Join our Council to explore upcoming Teams scenarios and provide valuable feedback. This is a program that requires an NDA agreement (non-disclosure) to be included in Teams conversations and bi-weekly forum calls.
Sign-up link: https://aka.ms/TeamsCouncil
M365 and Copilot SMB Champions Community
Description: Join our non-NDA SMB Champions community for Copilot and SMB M365 discussions. This Champions community will provide direct access to product teams during a monthly call where you can learn about new features and share your feedback.
Sign-up link: http://aka.ms/smbcommunitysignup
Champions community discussion board (meeting details also shared here): https://techcommunity.microsoft.com/t5/smb-microsoft-365-champion/bd-p/SMBM365ChampionProgram
Teams for Small Business Research
Description: The Teams SMB Research team is looking for small businesses who would be interested in joining future research sessions. These panels will be held virtually and you may choose to participate or decline individual studies or leave the panel at any time. Some studies include a thank you gift for participation.
Sign-up link: https://forms.office.com/r/qPYYJjm3df
Keep a watch on this discussion space (https://aka.ms/TeamsSMBCommunity) for a growing set of opportunities. Read More
Can’t print graph
When I try to print my graph from Excel it isn’t printing the bars, why is this?
When I try to print my graph from Excel it isn’t printing the bars, why is this? Read More
Importing 2 batches of historical import
Hi! We are hoping to import 2 batches of historical data for an upcoming survey and we are not too sure how can this happen. I have seen the article on historical import but it does not seem to talk about the feasibility of 2 historical imports. I am wondering if there is any resources that can help answer our question?
Hi! We are hoping to import 2 batches of historical data for an upcoming survey and we are not too sure how can this happen. I have seen the article on historical import but it does not seem to talk about the feasibility of 2 historical imports. I am wondering if there is any resources that can help answer our question? Read More
Team Android Mobile app syncing issue.
I am writing to bring to your attention a critical issue affecting a significant portion of our fleet of Android devices. Approximately 10-20 percent of our devices are experiencing a perplexing problem with the Teams application, wherein certain teams fail to sync and update properly.
To date the only fix is for the user to log into a web browser version of teams and look at the teams channel it then updates on the tablet.
The symptoms of this issue are as follows: despite new posts being made in a channel, affected devices display outdated information and fail to reflect the latest updates. Consequently, users are unable to access crucial information in a timely manner, significantly impeding workflow and collaboration efforts.
To date, we have exhausted various troubleshooting measures, all of which have proven ineffective in resolving the issue. These include:
Clearing cache and temporary files: This action results in channels appearing blank, devoid of any data, including both old and new posts.
Logging out and then back in: Despite attempting to re-authenticate, the problem persists.
Deleting the Teams application from the device: Reinstalling the application has not yielded any improvements.
Interestingly, we have observed that if a user is tagged in a post, the content becomes accessible through the activity tab of Teams. However, this workaround is not a sustainable solution for our operational needs.
Given the severity of this issue and its adverse impact on our productivity, we urgently require your assistance in identifying and rectifying the root cause from the administrative side. Any insights or guidance you can provide to resolve this matter expediently would be greatly appreciated.
I am writing to bring to your attention a critical issue affecting a significant portion of our fleet of Android devices. Approximately 10-20 percent of our devices are experiencing a perplexing problem with the Teams application, wherein certain teams fail to sync and update properly.To date the only fix is for the user to log into a web browser version of teams and look at the teams channel it then updates on the tablet.The symptoms of this issue are as follows: despite new posts being made in a channel, affected devices display outdated information and fail to reflect the latest updates. Consequently, users are unable to access crucial information in a timely manner, significantly impeding workflow and collaboration efforts. To date, we have exhausted various troubleshooting measures, all of which have proven ineffective in resolving the issue. These include:Clearing cache and temporary files: This action results in channels appearing blank, devoid of any data, including both old and new posts.Logging out and then back in: Despite attempting to re-authenticate, the problem persists.Deleting the Teams application from the device: Reinstalling the application has not yielded any improvements. Interestingly, we have observed that if a user is tagged in a post, the content becomes accessible through the activity tab of Teams. However, this workaround is not a sustainable solution for our operational needs. Given the severity of this issue and its adverse impact on our productivity, we urgently require your assistance in identifying and rectifying the root cause from the administrative side. Any insights or guidance you can provide to resolve this matter expediently would be greatly appreciated. Read More