Tag Archives: microsoft
Bluetooth mouse can’t connect to Windows 10 laptop
Hi all,
I bought a new bluetooth mouse with USB port. However, my Windows 10 laptop can’t detect this device. There is no problem using it on a Windows 11 PC.
Thanks
Hi all, I bought a new bluetooth mouse with USB port. However, my Windows 10 laptop can’t detect this device. There is no problem using it on a Windows 11 PC. Thanks Read More
How to pass AZ-104 in one month?
To pass the AZ-104 Exam in one month with DumpsSure, create a focused study plan covering all exam objectives. Utilize DumpsSure’s comprehensive study materials efficiently, including Dumps PDFs, practice questions, and mock exams. Practice consistently to reinforce learning, review regularly to identify weak areas, and seek clarification from DumpsSure’s support team or online forums. Engage with the community for additional insights and motivation. Stay disciplined, track progress, and adjust study strategies as needed. With dedication and DumpsSure’s resources, you can confidently prepare and succeed in the AZ-104 exam within a month.
To pass the AZ-104 Exam in one month with DumpsSure, create a focused study plan covering all exam objectives. Utilize DumpsSure’s comprehensive study materials efficiently, including Dumps PDFs, practice questions, and mock exams. Practice consistently to reinforce learning, review regularly to identify weak areas, and seek clarification from DumpsSure’s support team or online forums. Engage with the community for additional insights and motivation. Stay disciplined, track progress, and adjust study strategies as needed. With dedication and DumpsSure’s resources, you can confidently prepare and succeed in the AZ-104 exam within a month. Read More
How to Fix QBDBMGRN Not Running On This Computer Windows 10?
Troubleshooting Solutions: QBDBMGRN Not Running On This Computer Windows 10
When encountering the QBDBMGRN Not Running On This Computer Windows 10, several troubleshooting steps can help resolve the issue. Follow these solutions to address the problem:
Restart QuickBooks Database Server Manager (QBDBMgrN.exe): Start by restarting the QuickBooks Database Server Manager. This process can sometimes encounter glitches or stop running unexpectedly, leading to the error message. To do this:
Press Ctrl + Shift + Esc to open the Task Manager.Navigate to the “Processes” tab and look for “QBDBMgrN.exe.”Right-click on it and select “End task.”Then, restart QuickBooks and check if the error persists.
Update QuickBooks: Ensure that your QuickBooks software is up-to-date. Intuit regularly releases updates and patches to address bugs and improve software stability. To update QuickBooks:
Open QuickBooks and go to the “Help” menu.Select “Update QuickBooks Desktop.”Follow the prompts to download and install any available updates.After the update is complete, restart your computer and check if the error persists.
Check Firewall and Antivirus Settings: Sometimes, firewall or antivirus software may block QuickBooks Database Server Manager from running properly, leading to the error message. To address this:
Temporarily disable your firewall and antivirus software.Restart QuickBooks and check if the error persists.If the error is resolved, add QuickBooks to the exceptions or whitelist in your firewall and antivirus settings to prevent future conflicts.
Repair QuickBooks Installation: Corrupted or incomplete QuickBooks installations can also cause the QBDBMGRN Not Running On This Computer error. To repair the QuickBooks installation:
Close QuickBooks and navigate to the Control Panel on your computer.Go to “Programs” > “Programs and Features.”Find QuickBooks in the list of installed programs, right-click on it, and select “Repair.”Follow the prompts to complete the repair process.After repairing QuickBooks, restart your computer and check if the error persists.
Verify QuickBooks Services: Ensure that the necessary QuickBooks services are running properly. To do this:
Press Windows + R to open the Run dialog box.Type “services.msc” and press Enter to open the Services window.Look for services related to QuickBooks, such as “QuickBooksDBXX” and “QuickBooksDBXXE” (XX represents the version of QuickBooks).Make sure these services are set to “Automatic” startup type and are running.If any service is stopped, right-click on it, select “Start,” and then restart QuickBooks to see if the error is resolved.
By following these troubleshooting steps, you should be able to resolve the QBDBMGRN Not Running On This Computer Windows 10. If the issue persists after trying these solutions, consider reaching out to QuickBooks support for further assistance.
Troubleshooting Solutions: QBDBMGRN Not Running On This Computer Windows 10When encountering the QBDBMGRN Not Running On This Computer Windows 10, several troubleshooting steps can help resolve the issue. Follow these solutions to address the problem:Restart QuickBooks Database Server Manager (QBDBMgrN.exe): Start by restarting the QuickBooks Database Server Manager. This process can sometimes encounter glitches or stop running unexpectedly, leading to the error message. To do this:Press Ctrl + Shift + Esc to open the Task Manager.Navigate to the “Processes” tab and look for “QBDBMgrN.exe.”Right-click on it and select “End task.”Then, restart QuickBooks and check if the error persists.Update QuickBooks: Ensure that your QuickBooks software is up-to-date. Intuit regularly releases updates and patches to address bugs and improve software stability. To update QuickBooks:Open QuickBooks and go to the “Help” menu.Select “Update QuickBooks Desktop.”Follow the prompts to download and install any available updates.After the update is complete, restart your computer and check if the error persists.Check Firewall and Antivirus Settings: Sometimes, firewall or antivirus software may block QuickBooks Database Server Manager from running properly, leading to the error message. To address this:Temporarily disable your firewall and antivirus software.Restart QuickBooks and check if the error persists.If the error is resolved, add QuickBooks to the exceptions or whitelist in your firewall and antivirus settings to prevent future conflicts.Repair QuickBooks Installation: Corrupted or incomplete QuickBooks installations can also cause the QBDBMGRN Not Running On This Computer error. To repair the QuickBooks installation:Close QuickBooks and navigate to the Control Panel on your computer.Go to “Programs” > “Programs and Features.”Find QuickBooks in the list of installed programs, right-click on it, and select “Repair.”Follow the prompts to complete the repair process.After repairing QuickBooks, restart your computer and check if the error persists.Verify QuickBooks Services: Ensure that the necessary QuickBooks services are running properly. To do this:Press Windows + R to open the Run dialog box.Type “services.msc” and press Enter to open the Services window.Look for services related to QuickBooks, such as “QuickBooksDBXX” and “QuickBooksDBXXE” (XX represents the version of QuickBooks).Make sure these services are set to “Automatic” startup type and are running.If any service is stopped, right-click on it, select “Start,” and then restart QuickBooks to see if the error is resolved.By following these troubleshooting steps, you should be able to resolve the QBDBMGRN Not Running On This Computer Windows 10. If the issue persists after trying these solutions, consider reaching out to QuickBooks support for further assistance. Read More
=IF Formula – The statement value is not stored as a number.
Hi,
I am pretty amateur with excel and trying my best with googling all possible solutions but i am coming up short.
I am using formulas to format that if an employee works 6 days then they are given a £90 bonus, and if they work one day they are given a £50 bonus.
I have an =IF formal in place that if the selected cell says 6 days it will input £90 into the cell I require. And vice versa. That £90 is then needed to be added up in a =SUM formula to give me a sum of two cells. However as the £90 not a value is will not add up in the =SUM formula.
Is there another way around this?
Hi, I am pretty amateur with excel and trying my best with googling all possible solutions but i am coming up short. I am using formulas to format that if an employee works 6 days then they are given a £90 bonus, and if they work one day they are given a £50 bonus. I have an =IF formal in place that if the selected cell says 6 days it will input £90 into the cell I require. And vice versa. That £90 is then needed to be added up in a =SUM formula to give me a sum of two cells. However as the £90 not a value is will not add up in the =SUM formula. Is there another way around this? Read More
Partnership Requirement as Services
Hello Everyone,
I hope you’re all doing well.
I’m reaching out on behalf of BitTwoByte Technology, my venture dedicated to assisting businesses in modernizing their BI solutions. We specialize in data engineering and mining services, focusing on preparing, refining, and modeling data to establish robust data warehouse (DWH) architectures. Once the DWH is constructed, we undertake rigorous testing, implementation, and integration to ensure seamless functionality across various systems.
As a service provider, I am keen on forging a partnership with Microsoft. I am seeking guidance on the requirements and qualifications necessary to become a Microsoft partner. I would greatly appreciate any assistance or insights from this community to help me navigate this process.
Thank you.
Hello Everyone, I hope you’re all doing well. I’m reaching out on behalf of BitTwoByte Technology, my venture dedicated to assisting businesses in modernizing their BI solutions. We specialize in data engineering and mining services, focusing on preparing, refining, and modeling data to establish robust data warehouse (DWH) architectures. Once the DWH is constructed, we undertake rigorous testing, implementation, and integration to ensure seamless functionality across various systems. As a service provider, I am keen on forging a partnership with Microsoft. I am seeking guidance on the requirements and qualifications necessary to become a Microsoft partner. I would greatly appreciate any assistance or insights from this community to help me navigate this process. Thank you. Read More
Sharepoint cannot open .xls files
Hello, I’ve got an organisation-wide issue where Sharepoint cannot open some (not all) .xls files I’ve uploaded to a directory. This issue seems to occur only in Sharepoint & I am able to open the files (before uploading them to Sharepoint) on Windows 10 without any issues.
I’ve tried to circumvent this for my organisation and downloading the files results in a corrupt extension or file which cannot be opened either way.
My suspicion is that during the upload process something corrupts the extention but I cannot get down to finding a solution. Help is greatly appreciated!
Hello, I’ve got an organisation-wide issue where Sharepoint cannot open some (not all) .xls files I’ve uploaded to a directory. This issue seems to occur only in Sharepoint & I am able to open the files (before uploading them to Sharepoint) on Windows 10 without any issues. I’ve tried to circumvent this for my organisation and downloading the files results in a corrupt extension or file which cannot be opened either way.My suspicion is that during the upload process something corrupts the extention but I cannot get down to finding a solution. Help is greatly appreciated! Read More
Full access to be able to rename and delete folders
Hello
Please i need your help on this issue.
I have two people that have shared access to my one drive folders. at the moment they have limited access to view and upload files. I want to give them full access to be able to rename and delete folders.
Hello Please i need your help on this issue. I have two people that have shared access to my one drive folders. at the moment they have limited access to view and upload files. I want to give them full access to be able to rename and delete folders. Read More
Windows server 2022 Remote App issue
Hello,
We have remote app published on windows server 2022 and when the user loses connection (disconnect) and click on the application again the session reconnects and the application is launched again with new instance, in windows server 2019 and previous the behavior was different since the application is already running and will not launch a new instance for the same application.
To summarize the issue, the application should not launch new instance on reconnect to workspace by clicking the application icon.
Hello,We have remote app published on windows server 2022 and when the user loses connection (disconnect) and click on the application again the session reconnects and the application is launched again with new instance, in windows server 2019 and previous the behavior was different since the application is already running and will not launch a new instance for the same application. To summarize the issue, the application should not launch new instance on reconnect to workspace by clicking the application icon. Read More
How to Fix QuickBooks Payroll connection error in QuickBooks Desktop?
Troubleshooting Solutions : QuickBooks Payroll connection error in QuickBooks Desktop
Encountering a QuickBooks Payroll connection error in QuickBooks Desktop can disrupt payroll processing and cause inconvenience. Here are steps to troubleshoot and resolve this issue:
Check Internet Connection: Ensure that your computer has a stable internet connection. A weak or unstable connection can hinder communication with the QuickBooks Payroll servers. Try accessing other websites or online services to verify the internet connection’s stability.Verify Payroll Subscription: Confirm that your QuickBooks Payroll subscription is active and up to date. Log in to your Intuit account and check your subscription status. If your subscription has expired or encountered billing issues, resolve them to restore access to QuickBooks Payroll features.Update QuickBooks: Ensure that you are using the latest version of QuickBooks Desktop. Outdated software may have compatibility issues with QuickBooks Payroll services. Go to the Help menu in QuickBooks, select Update QuickBooks, and follow the prompts to download and install any available updates.Update Payroll Tax Table: Update the payroll tax table in QuickBooks to ensure compliance with the latest tax regulations. Go to the Employees menu, select Get Payroll Updates, then choose Update. Follow the on-screen instructions to download and install the latest payroll tax table updates.Restart QuickBooks and Computer: Sometimes, a simple restart can resolve temporary issues. Close QuickBooks Desktop and restart your computer. After restarting, open QuickBooks and try accessing QuickBooks Payroll again to check if the connection error persists.Check Firewall and Security Software: Adjust firewall and security software settings to allow QuickBooks Desktop to communicate with QuickBooks Payroll servers. Add exceptions for QuickBooks and its associated processes in firewall and security software settings to prevent them from blocking necessary connections.Run QuickBooks Connection Diagnostic Tool: Intuit provides a QuickBooks Connection Diagnostic Tool that can help diagnose and resolve connectivity issues with QuickBooks Payroll. Download and run the tool from the Intuit website, and follow the on-screen instructions to diagnose and fix any connection problems.Reauthorize Intuit Services: Sometimes, reauthorizing Intuit services can resolve connection errors. Go to the Help menu in QuickBooks, select Manage My License, then choose Sync License Data Online. Follow the prompts to reauthorize Intuit services, and then try accessing QuickBooks Payroll again.Contact QuickBooks Support: If you’ve tried the above steps and are still experiencing the QuickBooks Payroll connection error, contact QuickBooks support for further assistance. They can provide personalized troubleshooting guidance and help resolve the issue.
By following these troubleshooting steps, users can effectively address the QuickBooks Payroll connection error in QuickBooks Desktop and ensure seamless integration with QuickBooks Payroll for accurate and efficient payroll processing.
Troubleshooting Solutions : QuickBooks Payroll connection error in QuickBooks Desktop Encountering a QuickBooks Payroll connection error in QuickBooks Desktop can disrupt payroll processing and cause inconvenience. Here are steps to troubleshoot and resolve this issue: Check Internet Connection: Ensure that your computer has a stable internet connection. A weak or unstable connection can hinder communication with the QuickBooks Payroll servers. Try accessing other websites or online services to verify the internet connection’s stability.Verify Payroll Subscription: Confirm that your QuickBooks Payroll subscription is active and up to date. Log in to your Intuit account and check your subscription status. If your subscription has expired or encountered billing issues, resolve them to restore access to QuickBooks Payroll features.Update QuickBooks: Ensure that you are using the latest version of QuickBooks Desktop. Outdated software may have compatibility issues with QuickBooks Payroll services. Go to the Help menu in QuickBooks, select Update QuickBooks, and follow the prompts to download and install any available updates.Update Payroll Tax Table: Update the payroll tax table in QuickBooks to ensure compliance with the latest tax regulations. Go to the Employees menu, select Get Payroll Updates, then choose Update. Follow the on-screen instructions to download and install the latest payroll tax table updates.Restart QuickBooks and Computer: Sometimes, a simple restart can resolve temporary issues. Close QuickBooks Desktop and restart your computer. After restarting, open QuickBooks and try accessing QuickBooks Payroll again to check if the connection error persists.Check Firewall and Security Software: Adjust firewall and security software settings to allow QuickBooks Desktop to communicate with QuickBooks Payroll servers. Add exceptions for QuickBooks and its associated processes in firewall and security software settings to prevent them from blocking necessary connections.Run QuickBooks Connection Diagnostic Tool: Intuit provides a QuickBooks Connection Diagnostic Tool that can help diagnose and resolve connectivity issues with QuickBooks Payroll. Download and run the tool from the Intuit website, and follow the on-screen instructions to diagnose and fix any connection problems.Reauthorize Intuit Services: Sometimes, reauthorizing Intuit services can resolve connection errors. Go to the Help menu in QuickBooks, select Manage My License, then choose Sync License Data Online. Follow the prompts to reauthorize Intuit services, and then try accessing QuickBooks Payroll again.Contact QuickBooks Support: If you’ve tried the above steps and are still experiencing the QuickBooks Payroll connection error, contact QuickBooks support for further assistance. They can provide personalized troubleshooting guidance and help resolve the issue.By following these troubleshooting steps, users can effectively address the QuickBooks Payroll connection error in QuickBooks Desktop and ensure seamless integration with QuickBooks Payroll for accurate and efficient payroll processing. Read More
iPad/iPhone and Mac with Intune
Hello everyone!
This is my first post. We have recently been staring to use Intune, beginning with our PC’s and Samsung phones. Now we’re discussing if we shell or shell not migrate or iPad/iPhones and Macs as well. We’ve got around 1.000 Macs and 2.000 devices. About 90-95% of the are used in school by students and teachers. For the moment we manage the in Jamf Pro. Bellow follows a couple of questions I find very interesting to get some answers for. :
iPad / iOS
Jamf Techer and Apple Classroom
Jamf Teacher
– Create and manage classes
– Create and start lessons
– Share a lesson
– Invite students to a remote class
– Send messages to class or student
– Request apps for students
– Manage students devices, set restrictions for ongoing lesson among other things
Apple Classroom
– Can do much Jamf Techer can, but not all
– Allows you to remote control student
– You can combine both Apple Classroom and Jamf Teacher
Is there any app like Jamf Teacher connected to Intune?
Mac
When it comes to Mac in Intune, how long does it in average take to enroll?
Is it passible and is it easy to change/renew a configuration/policy for a Mac that’s already enrolled for an example a month ago?
How about creating and deploying a new coniguration/policy to a already enrolled Mac?
Both iPad and Mac
How close ot release of new OS’s does Microsoft support it?
Hello everyone!This is my first post. We have recently been staring to use Intune, beginning with our PC’s and Samsung phones. Now we’re discussing if we shell or shell not migrate or iPad/iPhones and Macs as well. We’ve got around 1.000 Macs and 2.000 devices. About 90-95% of the are used in school by students and teachers. For the moment we manage the in Jamf Pro. Bellow follows a couple of questions I find very interesting to get some answers for. :iPad / iOSJamf Techer and Apple ClassroomJamf Teacher- Create and manage classes- Create and start lessons- Share a lesson- Invite students to a remote class- Send messages to class or student- Request apps for students- Manage students devices, set restrictions for ongoing lesson among other thingsApple Classroom- Can do much Jamf Techer can, but not all- Allows you to remote control student- You can combine both Apple Classroom and Jamf TeacherIs there any app like Jamf Teacher connected to Intune?MacWhen it comes to Mac in Intune, how long does it in average take to enroll?Is it passible and is it easy to change/renew a configuration/policy for a Mac that’s already enrolled for an example a month ago?How about creating and deploying a new coniguration/policy to a already enrolled Mac?Both iPad and MacHow close ot release of new OS’s does Microsoft support it? Read More
eDiscovery hold licensing
Dear Community,
I have read that an E3 license has to be assigned to a user in order to apply eDiscovery hold on it, but what if we remove the license or delete the account while the hold is active? The hold retains SharePoint and OneDrive only. If you know the answer, can you please write a referenced article where I can find the related official statement?
I really appreciate any help you can provide.
Dear Community, I have read that an E3 license has to be assigned to a user in order to apply eDiscovery hold on it, but what if we remove the license or delete the account while the hold is active? The hold retains SharePoint and OneDrive only. If you know the answer, can you please write a referenced article where I can find the related official statement? I really appreciate any help you can provide. Read More
How fix QuickBooks Database Server Manager Network Diagnostics Failed?
Troubleshooting Solutions : QuickBooks Database Server Manager Network Diagnostics Failed
QuickBooks Database Server Manager plays a critical role in multi-user environments, facilitating access to QuickBooks company files across a network. When encountering the error QuickBooks Database Server Manager Network Diagnostics Failed several factors could be at play. Here are troubleshooting solutions to resolve this issue:
Check Network Connectivity: Ensure that all computers and devices on the network have stable and reliable connections. Verify Ethernet cables, Wi-Fi connections, and network configurations to rule out any connectivity issues that could impede communication with the QuickBooks Database Server.
Restart QuickBooks Database Server Manager: Try restarting the QuickBooks Database Server Manager service to refresh its functionality. Access the Services console on your computer, locate the QuickBooksDBxx service (xx represents the year version), and restart it. After restarting the service, attempt to run the network diagnostics again.
Update QuickBooks Database Server Manager: Ensure that your QuickBooks software, including the Database Server Manager component, is up to date. Updates often contain fixes for known issues and compatibility improvements. Check for updates within QuickBooks and install any available updates for the Database Server Manager.
Verify Firewall and Antivirus Settings: Check your firewall and antivirus software settings to ensure that QuickBooks Database Server Manager is allowed through. Configure firewall and antivirus exceptions for QuickBooks and related processes to prevent them from being blocked or interfered with by security software.
Run QuickBooks File Doctor: Utilize the QuickBooks File Doctor tool to diagnose and repair network-related issues with QuickBooks company files and the Database Server Manager. Launch the File Doctor tool, select the option to check network connectivity, and follow the on-screen instructions to resolve any detected problems.
Check Host Multi-User Access: Ensure that the hosting of multi-user access is enabled on the computer where QuickBooks Database Server Manager is installed. Open QuickBooks on the host computer, navigate to the File menu, select “Utilities,” and verify that “Host Multi-User Access” is enabled. If not, enable hosting and try running network diagnostics again.
Review Network Configuration: Double-check the network configuration settings on all computers and devices involved in accessing QuickBooks company files. Verify IP addresses, subnet masks, and network sharing settings to ensure proper communication between the QuickBooks Database Server and client computers.
Restart Computers and Networking Equipment: Perform a reboot of all computers and networking equipment, including routers, switches, and modems. Sometimes, a simple restart can resolve temporary network issues that may be affecting the performance of QuickBooks Database Server Manager.
Contact QuickBooks Support: If the issue persists despite attempting the above solutions, consider reaching out to QuickBooks support for further assistance. QuickBooks support representatives can provide specialized troubleshooting guidance and help resolve complex network-related issues with Database Server Manager.
By following these troubleshooting solutions, you can effectively address the QuickBooks Database Server Manager Network Diagnostics Failed issue and ensure smooth network connectivity for accessing QuickBooks company files in a multi-user environment.
Troubleshooting Solutions : QuickBooks Database Server Manager Network Diagnostics Failed QuickBooks Database Server Manager plays a critical role in multi-user environments, facilitating access to QuickBooks company files across a network. When encountering the error QuickBooks Database Server Manager Network Diagnostics Failed several factors could be at play. Here are troubleshooting solutions to resolve this issue: Check Network Connectivity: Ensure that all computers and devices on the network have stable and reliable connections. Verify Ethernet cables, Wi-Fi connections, and network configurations to rule out any connectivity issues that could impede communication with the QuickBooks Database Server.Restart QuickBooks Database Server Manager: Try restarting the QuickBooks Database Server Manager service to refresh its functionality. Access the Services console on your computer, locate the QuickBooksDBxx service (xx represents the year version), and restart it. After restarting the service, attempt to run the network diagnostics again.Update QuickBooks Database Server Manager: Ensure that your QuickBooks software, including the Database Server Manager component, is up to date. Updates often contain fixes for known issues and compatibility improvements. Check for updates within QuickBooks and install any available updates for the Database Server Manager.Verify Firewall and Antivirus Settings: Check your firewall and antivirus software settings to ensure that QuickBooks Database Server Manager is allowed through. Configure firewall and antivirus exceptions for QuickBooks and related processes to prevent them from being blocked or interfered with by security software.Run QuickBooks File Doctor: Utilize the QuickBooks File Doctor tool to diagnose and repair network-related issues with QuickBooks company files and the Database Server Manager. Launch the File Doctor tool, select the option to check network connectivity, and follow the on-screen instructions to resolve any detected problems.Check Host Multi-User Access: Ensure that the hosting of multi-user access is enabled on the computer where QuickBooks Database Server Manager is installed. Open QuickBooks on the host computer, navigate to the File menu, select “Utilities,” and verify that “Host Multi-User Access” is enabled. If not, enable hosting and try running network diagnostics again.Review Network Configuration: Double-check the network configuration settings on all computers and devices involved in accessing QuickBooks company files. Verify IP addresses, subnet masks, and network sharing settings to ensure proper communication between the QuickBooks Database Server and client computers.Restart Computers and Networking Equipment: Perform a reboot of all computers and networking equipment, including routers, switches, and modems. Sometimes, a simple restart can resolve temporary network issues that may be affecting the performance of QuickBooks Database Server Manager.Contact QuickBooks Support: If the issue persists despite attempting the above solutions, consider reaching out to QuickBooks support for further assistance. QuickBooks support representatives can provide specialized troubleshooting guidance and help resolve complex network-related issues with Database Server Manager.By following these troubleshooting solutions, you can effectively address the QuickBooks Database Server Manager Network Diagnostics Failed issue and ensure smooth network connectivity for accessing QuickBooks company files in a multi-user environment. Read More
Referencing issue when running insert-rows-Macro
Hello there,
I am struggling in a situation I hope anyone could help or provide any workaround. I am attaching a sample document to make the situation more clear. I run Excel 365.
I have two set of rows 3-5 and 9-11. Each of these sets of rows contain 3 rows. I then have a macro that inserts a row to each of these sets. That is, whenever I need a new product name, 1 row is inserted in the first set, that would then go from 3-6 and 1 row is inserted in the second set, that would then go from 10-13.
The pieces of code of that macro look as follows:
Sub Add_Rows()
Application.ScreenUpdating = False
Sheets(“Sheet1”).Select
Cells.Find(What:=”Header 1″, After:=ActiveCell, LookIn _
:=xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _
xlNext, MatchCase:=False, SearchFormat:=False).Activate
ActiveCell.Offset(rowOffset:=2).Activate
ActiveCell.EntireRow.Select
Selection.Copy
ActiveCell.Offset(rowOffset:=1).Activate
Selection.Insert Shift:=xlDown
Sheets(“Sheet1”).Select
Cells.Find(What:=”Header 2″, After:=ActiveCell, LookIn _
:=xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _
xlNext, MatchCase:=False, SearchFormat:=False).Activate
ActiveCell.Offset(rowOffset:=2).Activate
ActiveCell.EntireRow.Select
Selection.Copy
ActiveCell.Offset(rowOffset:=1).Activate
Selection.Insert Shift:=xlDown
Application.ScreenUpdating = True
End Sub
The problem I have is that there are cells in all these rows that reference the other set of rows at the same time. That is, explained by colors (see attached document), cells in the first set of rows reference both cells in the same set of rows (blue) and cells in the second set of rows (orange). At the same time, cells in the second set of rows reference cells in the first one (blue and green).
The real issue is that, whatever the order of the inserted rows in the VBA code is, there will always be some referencing that will be broken.
I want that whenever the row is added, it follows the formulation of the cells above/below accordingly, but the formulation breaks (naturally, because it tries to reference a row that is not yet created).
Is there any possibility to write additional code in order to handle this? Is this even possible to be worked around? I have tried with “Application.Calculation = xlCalculationManual” at the beggining and “Application.Calculation = xlCalculationAutomatic” at the end, but it does not work.
Would the only solution be to first create all rows and then write the code to fill the formulation of all these newly inserted rows accordingly?
Any help would be appreaciated.
Martin
Hello there, I am struggling in a situation I hope anyone could help or provide any workaround. I am attaching a sample document to make the situation more clear. I run Excel 365. I have two set of rows 3-5 and 9-11. Each of these sets of rows contain 3 rows. I then have a macro that inserts a row to each of these sets. That is, whenever I need a new product name, 1 row is inserted in the first set, that would then go from 3-6 and 1 row is inserted in the second set, that would then go from 10-13. The pieces of code of that macro look as follows: Sub Add_Rows()
Application.ScreenUpdating = False
Sheets(“Sheet1”).Select
Cells.Find(What:=”Header 1″, After:=ActiveCell, LookIn _
:=xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _
xlNext, MatchCase:=False, SearchFormat:=False).Activate
ActiveCell.Offset(rowOffset:=2).Activate
ActiveCell.EntireRow.Select
Selection.Copy
ActiveCell.Offset(rowOffset:=1).Activate
Selection.Insert Shift:=xlDown
Sheets(“Sheet1”).Select
Cells.Find(What:=”Header 2″, After:=ActiveCell, LookIn _
:=xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _
xlNext, MatchCase:=False, SearchFormat:=False).Activate
ActiveCell.Offset(rowOffset:=2).Activate
ActiveCell.EntireRow.Select
Selection.Copy
ActiveCell.Offset(rowOffset:=1).Activate
Selection.Insert Shift:=xlDown
Application.ScreenUpdating = True
End Sub The problem I have is that there are cells in all these rows that reference the other set of rows at the same time. That is, explained by colors (see attached document), cells in the first set of rows reference both cells in the same set of rows (blue) and cells in the second set of rows (orange). At the same time, cells in the second set of rows reference cells in the first one (blue and green). The real issue is that, whatever the order of the inserted rows in the VBA code is, there will always be some referencing that will be broken. I want that whenever the row is added, it follows the formulation of the cells above/below accordingly, but the formulation breaks (naturally, because it tries to reference a row that is not yet created). Is there any possibility to write additional code in order to handle this? Is this even possible to be worked around? I have tried with “Application.Calculation = xlCalculationManual” at the beggining and “Application.Calculation = xlCalculationAutomatic” at the end, but it does not work. Would the only solution be to first create all rows and then write the code to fill the formulation of all these newly inserted rows accordingly? Any help would be appreaciated. Martin Read More
How to check USB port 2.0 or 3.0 on my PC?
The file transfer to USB is very slow on my PC. The USB drive is 3.1 Gen. How can check the USB version my PC?
The file transfer to USB is very slow on my PC. The USB drive is 3.1 Gen. How can check the USB version my PC? Read More
How to Fix QBDBMGRN Not Running On This Computer Windows 11?
Troubleshooting Solutions: QBDBMGRN Not Running On This Computer Windows 11
The “QBDBMGRN Not Running On This Computer” error in QuickBooks typically arises due to issues with the QuickBooks Database Server Manager service. Follow these steps to troubleshoot and resolve the issue:
Restart QuickBooks Database Server Manager Service:
Press Windows + R to open the Run dialog box.Type services.msc and press Enter to open the Services window.Locate the QuickBooks Database Server Manager service in the list.Right-click on it and select Restart. If it’s already running, select Stop and then Start again.Check if the error persists. If it does, proceed to the next step.
Update QuickBooks:
Ensure that you have the latest updates installed for QuickBooks.Open QuickBooks and go to the Help menu.Select Update QuickBooks.Click on Update Now and follow the prompts to download and install any available updates.After updating, restart your computer and check if the error is resolved.
Run QuickBooks File Doctor:
QuickBooks File Doctor is a built-in tool designed to diagnose and repair various QuickBooks-related issues.Download and install the QuickBooks Tool Hub from the official Intuit website.Open the Tool Hub and select the Company File Issues tab.Click on Run QuickBooks File Doctor and follow the on-screen instructions.Once the repair process is complete, restart your computer and check if the error persists.
Check Firewall Settings:
Sometimes, firewall settings can block the QuickBooks Database Server Manager service.Open your firewall settings and ensure that QuickBooks and its associated services are allowed through.If necessary, create an inbound and outbound rule to allow QuickBooks through the firewall.Restart QuickBooks and check if the error is resolved.
Repair QuickBooks Installation:
If the issue persists, repairing the QuickBooks installation may resolve any corrupted files or settings.Close QuickBooks and any related processes.Open the Control Panel and navigate to Programs > Programs and Features.Select QuickBooks from the list of installed programs and click on Repair.Follow the on-screen instructions to complete the repair process.Once repaired, restart your computer and check if the error is resolved.
Reinstall QuickBooks Database Server Manager:
If none of the above steps resolve the issue, reinstalling the QuickBooks Database Server Manager may be necessary.Uninstall QuickBooks Database Server Manager from the Control Panel.Download the latest version of QuickBooks Database Server Manager from the Intuit website.Install the software and follow the on-screen instructions.Restart your computer and check if the error is resolved.
By following these troubleshooting steps, you should be able to resolve the “QBDBMGRN Not Running On This Computer Windows 11” error in QuickBooks and resume normal operation. If the issue persists, consider reaching out to Intuit support for further assistance.
Troubleshooting Solutions: QBDBMGRN Not Running On This Computer Windows 11The “QBDBMGRN Not Running On This Computer” error in QuickBooks typically arises due to issues with the QuickBooks Database Server Manager service. Follow these steps to troubleshoot and resolve the issue:Restart QuickBooks Database Server Manager Service:Press Windows + R to open the Run dialog box.Type services.msc and press Enter to open the Services window.Locate the QuickBooks Database Server Manager service in the list.Right-click on it and select Restart. If it’s already running, select Stop and then Start again.Check if the error persists. If it does, proceed to the next step.Update QuickBooks:Ensure that you have the latest updates installed for QuickBooks.Open QuickBooks and go to the Help menu.Select Update QuickBooks.Click on Update Now and follow the prompts to download and install any available updates.After updating, restart your computer and check if the error is resolved.Run QuickBooks File Doctor:QuickBooks File Doctor is a built-in tool designed to diagnose and repair various QuickBooks-related issues.Download and install the QuickBooks Tool Hub from the official Intuit website.Open the Tool Hub and select the Company File Issues tab.Click on Run QuickBooks File Doctor and follow the on-screen instructions.Once the repair process is complete, restart your computer and check if the error persists.Check Firewall Settings:Sometimes, firewall settings can block the QuickBooks Database Server Manager service.Open your firewall settings and ensure that QuickBooks and its associated services are allowed through.If necessary, create an inbound and outbound rule to allow QuickBooks through the firewall.Restart QuickBooks and check if the error is resolved.Repair QuickBooks Installation:If the issue persists, repairing the QuickBooks installation may resolve any corrupted files or settings.Close QuickBooks and any related processes.Open the Control Panel and navigate to Programs > Programs and Features.Select QuickBooks from the list of installed programs and click on Repair.Follow the on-screen instructions to complete the repair process.Once repaired, restart your computer and check if the error is resolved.Reinstall QuickBooks Database Server Manager:If none of the above steps resolve the issue, reinstalling the QuickBooks Database Server Manager may be necessary.Uninstall QuickBooks Database Server Manager from the Control Panel.Download the latest version of QuickBooks Database Server Manager from the Intuit website.Install the software and follow the on-screen instructions.Restart your computer and check if the error is resolved.By following these troubleshooting steps, you should be able to resolve the “QBDBMGRN Not Running On This Computer Windows 11” error in QuickBooks and resume normal operation. If the issue persists, consider reaching out to Intuit support for further assistance. Read More
Real world object detection
Hi All,
I hope this is the right place to ask this question. If it is not, please point me to the right location. Thanks.
I have been asked to develop a HoloLens 2 healthcare application that should work as guide for patients on how to handle different devices for blood sugar measurements, insulin pumps etc.
But I need some help/information for how to do this the best way.
The HoloLens 2 application must be able to recognize the device (blood sugar measurement device) on the table, so that it can start telling what to do with it.
Are you able to help me with this?
Thank you in advance
Hi All, I hope this is the right place to ask this question. If it is not, please point me to the right location. Thanks. I have been asked to develop a HoloLens 2 healthcare application that should work as guide for patients on how to handle different devices for blood sugar measurements, insulin pumps etc.But I need some help/information for how to do this the best way.The HoloLens 2 application must be able to recognize the device (blood sugar measurement device) on the table, so that it can start telling what to do with it. Are you able to help me with this? Thank you in advance Read More
What’s the best PDF to word converter for PC?
I’m currently looking for recommendations on the best PDF to Word converter for PC. I need a tool that can handle a variety of PDF documents, including those with complex layouts, images, and various fonts, and convert them into editable Word files without losing the formatting.
I would appreciate suggestions based on personal experiences, particularly noting the software’s accuracy, ease of use, and any features that stand out. Price is also a consideration, so I’d like to hear if there are good free options or if it’s worth investing in a paid version. Thanks in advance for your help!
I’m currently looking for recommendations on the best PDF to Word converter for PC. I need a tool that can handle a variety of PDF documents, including those with complex layouts, images, and various fonts, and convert them into editable Word files without losing the formatting. I would appreciate suggestions based on personal experiences, particularly noting the software’s accuracy, ease of use, and any features that stand out. Price is also a consideration, so I’d like to hear if there are good free options or if it’s worth investing in a paid version. Thanks in advance for your help! Read More
How do i fix My Payroll PIN is working in QuickBooks Desktop after update?
Troubleshooting Solutions: Payroll PIN not working in QuickBooks Desktop
Encountering issues with Payroll PIN not working in QuickBooks Desktop can be frustrating, but there are several troubleshooting steps you can take to resolve the issue:
Verify Correctness of PIN: Ensure that you’re entering the correct Payroll PIN. Double-check the PIN for any typos or errors. If you’re uncertain about the PIN, confirm it with your payroll administrator or the person who initially set it up.Check Internet Connection: Make sure you have a stable and active internet connection. QuickBooks Desktop requires an internet connection to validate the Payroll PIN. If your internet connection is weak or intermittent, it may prevent proper authentication.Restart QuickBooks Desktop: Close QuickBooks Desktop and reopen it. Sometimes, simply restarting the software can resolve temporary glitches or issues, including problems with the Payroll PIN authentication.Update QuickBooks Desktop: Ensure that you’re using the latest version of QuickBooks Desktop. Outdated software versions may contain bugs or compatibility issues that can affect the functionality of payroll features, including the PIN authentication process.Run QuickBooks File Doctor: Use the QuickBooks File Doctor tool to diagnose and fix common QuickBooks Desktop issues, including problems with payroll features. This tool can identify and repair issues that may be preventing proper authentication of the Payroll PIN.Reset Payroll PIN: If you’re unable to authenticate with the existing Payroll PIN, consider resetting it. In QuickBooks Desktop, navigate to the Payroll section and look for options to reset or change the Payroll PIN. Follow the on-screen instructions to create a new PIN.Contact QuickBooks Support: If none of the above solutions resolve the issue, contact QuickBooks customer support for further assistance. QuickBooks support agents can provide personalized guidance and troubleshooting steps to help you fix the problem with the Payroll PIN and resume payroll processing smoothly.Check Payroll Subscription Status: Verify that your payroll subscription is active and up to date. If your subscription has expired or encountered issues, it may affect the functionality of payroll features, including the authentication of the Payroll PIN. Renew or update your subscription as needed.Review Payroll Service Key: Double-check the Payroll Service Key associated with your QuickBooks Desktop account. Ensure that the service key is correct and hasn’t expired. Update the service key if necessary to ensure proper authentication of the Payroll PIN.
By following these troubleshooting solutions, you can address the issue of a Payroll PIN not working in QuickBooks Desktop and resume payroll processing smoothly. Regularly updating QuickBooks Desktop and maintaining a stable internet connection can help prevent similar issues in the future, ensuring efficient payroll management for your business.
Troubleshooting Solutions: Payroll PIN not working in QuickBooks Desktop Encountering issues with Payroll PIN not working in QuickBooks Desktop can be frustrating, but there are several troubleshooting steps you can take to resolve the issue: Verify Correctness of PIN: Ensure that you’re entering the correct Payroll PIN. Double-check the PIN for any typos or errors. If you’re uncertain about the PIN, confirm it with your payroll administrator or the person who initially set it up.Check Internet Connection: Make sure you have a stable and active internet connection. QuickBooks Desktop requires an internet connection to validate the Payroll PIN. If your internet connection is weak or intermittent, it may prevent proper authentication.Restart QuickBooks Desktop: Close QuickBooks Desktop and reopen it. Sometimes, simply restarting the software can resolve temporary glitches or issues, including problems with the Payroll PIN authentication.Update QuickBooks Desktop: Ensure that you’re using the latest version of QuickBooks Desktop. Outdated software versions may contain bugs or compatibility issues that can affect the functionality of payroll features, including the PIN authentication process.Run QuickBooks File Doctor: Use the QuickBooks File Doctor tool to diagnose and fix common QuickBooks Desktop issues, including problems with payroll features. This tool can identify and repair issues that may be preventing proper authentication of the Payroll PIN.Reset Payroll PIN: If you’re unable to authenticate with the existing Payroll PIN, consider resetting it. In QuickBooks Desktop, navigate to the Payroll section and look for options to reset or change the Payroll PIN. Follow the on-screen instructions to create a new PIN.Contact QuickBooks Support: If none of the above solutions resolve the issue, contact QuickBooks customer support for further assistance. QuickBooks support agents can provide personalized guidance and troubleshooting steps to help you fix the problem with the Payroll PIN and resume payroll processing smoothly.Check Payroll Subscription Status: Verify that your payroll subscription is active and up to date. If your subscription has expired or encountered issues, it may affect the functionality of payroll features, including the authentication of the Payroll PIN. Renew or update your subscription as needed.Review Payroll Service Key: Double-check the Payroll Service Key associated with your QuickBooks Desktop account. Ensure that the service key is correct and hasn’t expired. Update the service key if necessary to ensure proper authentication of the Payroll PIN.By following these troubleshooting solutions, you can address the issue of a Payroll PIN not working in QuickBooks Desktop and resume payroll processing smoothly. Regularly updating QuickBooks Desktop and maintaining a stable internet connection can help prevent similar issues in the future, ensuring efficient payroll management for your business. Read More
How to Fix QuickBooks Database Server Manager Network Diagnostics Failed?
Troubleshooting Solutions : QuickBooks Database Server Manager Network Diagnostics Failed
Encountering the QuickBooks Database Server Manager Network Diagnostics Failed error can disrupt workflow and hinder QuickBooks functionality. Here are steps to troubleshoot and resolve this issue effectively:
Restart QuickBooks Services: Begin by restarting QuickBooks Database Server Manager and related services. Navigate to the Windows Start menu, type “Services” in the search bar, and press Enter. Locate the QuickBooksDBXX service (XX represents the version of QuickBooks), right-click on it, and select Restart. Repeat this process for other related services like QuickBooksDBXX (QBDBXX) and QuickBooksDBXX (QBCFMonitorService).Update QuickBooks: Ensure that QuickBooks and QuickBooks Database Server Manager are updated to the latest versions. Outdated software may encounter compatibility issues leading to the “Network Diagnostics Failed” error. Visit the official QuickBooks website or use the built-in update feature within the software to download and install the latest updates.Check Firewall and Antivirus Settings: Adjust firewall and antivirus settings to allow QuickBooks Database Server Manager to function properly. Add exceptions for QuickBooks and its associated processes in firewall and antivirus software to prevent them from blocking necessary connections. Consult the documentation of your firewall or antivirus program for instructions on adding program exceptions.Network Configuration: Verify network settings to ensure proper communication between the server hosting QuickBooks Database Server Manager and client workstations. Check network cables, routers, and switches for any signs of malfunction. Ensure that the workstations have proper network access to the server hosting the company file.File Hosting: Confirm that the company file is properly hosted on the server and accessible by QuickBooks Database Server Manager. Open QuickBooks on the host computer, navigate to the File menu, select Utilities, and then Host Multi-User Access. Follow the on-screen instructions to ensure proper hosting of the company file.Repair QuickBooks Installation: If the issue persists, repair the QuickBooks installation to fix any corrupted files or components causing the error. Close QuickBooks and navigate to the Control Panel on your computer. Select Programs and Features, locate QuickBooks in the list of installed programs, right-click, and choose Repair. Follow the prompts to complete the repair process.Recreate Network Data File: If all else fails, recreate the QuickBooks Network Data (.ND) file associated with the company file. Close QuickBooks on all workstations and navigate to the folder containing the company file. Locate the corresponding .ND file, rename it, and reopen QuickBooks. QuickBooks will automatically recreate the .ND file, potentially resolving any corruption issues causing the error.
By following these troubleshooting steps, users can effectively address the QuickBooks Database Server Manager Network Diagnostics Failed error and ensure seamless functioning of QuickBooks for their business needs. If the problem persists, consider reaching out to QuickBooks support for further assistance and guidance.
Troubleshooting Solutions : QuickBooks Database Server Manager Network Diagnostics Failed Encountering the QuickBooks Database Server Manager Network Diagnostics Failed error can disrupt workflow and hinder QuickBooks functionality. Here are steps to troubleshoot and resolve this issue effectively: Restart QuickBooks Services: Begin by restarting QuickBooks Database Server Manager and related services. Navigate to the Windows Start menu, type “Services” in the search bar, and press Enter. Locate the QuickBooksDBXX service (XX represents the version of QuickBooks), right-click on it, and select Restart. Repeat this process for other related services like QuickBooksDBXX (QBDBXX) and QuickBooksDBXX (QBCFMonitorService).Update QuickBooks: Ensure that QuickBooks and QuickBooks Database Server Manager are updated to the latest versions. Outdated software may encounter compatibility issues leading to the “Network Diagnostics Failed” error. Visit the official QuickBooks website or use the built-in update feature within the software to download and install the latest updates.Check Firewall and Antivirus Settings: Adjust firewall and antivirus settings to allow QuickBooks Database Server Manager to function properly. Add exceptions for QuickBooks and its associated processes in firewall and antivirus software to prevent them from blocking necessary connections. Consult the documentation of your firewall or antivirus program for instructions on adding program exceptions.Network Configuration: Verify network settings to ensure proper communication between the server hosting QuickBooks Database Server Manager and client workstations. Check network cables, routers, and switches for any signs of malfunction. Ensure that the workstations have proper network access to the server hosting the company file.File Hosting: Confirm that the company file is properly hosted on the server and accessible by QuickBooks Database Server Manager. Open QuickBooks on the host computer, navigate to the File menu, select Utilities, and then Host Multi-User Access. Follow the on-screen instructions to ensure proper hosting of the company file.Repair QuickBooks Installation: If the issue persists, repair the QuickBooks installation to fix any corrupted files or components causing the error. Close QuickBooks and navigate to the Control Panel on your computer. Select Programs and Features, locate QuickBooks in the list of installed programs, right-click, and choose Repair. Follow the prompts to complete the repair process.Recreate Network Data File: If all else fails, recreate the QuickBooks Network Data (.ND) file associated with the company file. Close QuickBooks on all workstations and navigate to the folder containing the company file. Locate the corresponding .ND file, rename it, and reopen QuickBooks. QuickBooks will automatically recreate the .ND file, potentially resolving any corruption issues causing the error.By following these troubleshooting steps, users can effectively address the QuickBooks Database Server Manager Network Diagnostics Failed error and ensure seamless functioning of QuickBooks for their business needs. If the problem persists, consider reaching out to QuickBooks support for further assistance and guidance. Read More