Category: Microsoft
Category Archives: Microsoft
Introducing Windows 11 checkpoint cumulative updates
We’re excited to further optimize the delivery of continuous innovation in Windows 11 with new checkpoint cumulative updates.[1] As early as late 2024, you will automatically get this optimization on any devices running Windows 11, version 24H2 or later, as well as on Windows Server 2025. Keeping your organization updated and secure will involve smaller, faster, and more sustainable updates, with no action required from you. Keep reading to learn how you can preview this experience today in Windows Insider Preview Build 26120.1252 (Dev Channel).
Tip: Windows 11, version 24H2 will be available as a traditional feature update to all devices later this year.
Checkpoint cumulative updates explained
Windows 11 quality updates use servicing technology and are built cumulatively from the time when a new Windows OS was “released to manufacturing” (RTM). These monthly updates include all the changes since RTM in the form of binary differentials computed from the initial version of those binaries.
Tip: Review how quality updates work in Windows monthly updates explained.
With Windows 11, version 24H2, we’re introducing a new concept of checkpoint cumulative updates. This will allow you to get features and security enhancements via the latest cumulative update through smaller, incremental differentials containing only the changes since the previous checkpoint cumulative update. This means that you can save time, bandwidth, and hard drive space.
Going forward, Microsoft might periodically release cumulative updates as checkpoints. The subsequent updates will then consist of:
The update package files associated with the checkpoints
New update package files that contain incremental binary differentials against the version of binaries in the last checkpoint
This process may be repeated multiple times, thereby generating multiple checkpoints during the lifecycle of a given Windows release. The Windows 11, version 24H2 servicing stack can merge all the checkpoints and only download and install content that’s missing on the device.
Managing cumulative updates
If you manage updates with Windows Update, Windows Update for Business, Windows Autopatch, or Windows Server Update Services (WSUS), these new developments do not require any changes or actions on your part. They will simply appear as a normal monthly update, only improved. You can continue to use the same tools and processes that you currently use for approving and deploying updates.
Remember, this applies to your devices running Windows 11, version 24H2 or later, as well as Windows Server 2025. You can preview this experience today with Windows Insider Preview Build 26120.1252 (Dev Channel).
If you source updates from the Microsoft Update Catalog, you’ll notice that a given monthly update may contain more than one update package file available for download. There will be one file for each checkpoint, plus an additional file that contains cumulative payload from the latest checkpoint. You will be able to install all files sequentially using existing deployment tools.
If you are running other versions of Windows 10 or Windows 11 (earlier than version 24H2), the process of updating will be similar to previous monthly updates or annual Windows 11 feature updates.
Benefits of checkpoint cumulative updates
Now your organization can stay current with the latest feature and security enhancements in improved ways. Specifically, you get even smaller downloads to Windows devices, sustainable redistribution of updates within your infrastructure, and a better update experience for annual feature updates.
Smaller downloads to the clients
Previously with Windows 11, version 21H2, we introduced smaller downloads to Windows devices by doing range reads to only download and install binary differentials missing on the device. These binary differentials are computed against the RTM version of the binaries. When Windows 11 24H2 cumulative update is released as a checkpoint, the binary differentials in subsequent cumulative updates are generated against the version of binaries in the latest checkpoint instead of the RTM version. Therefore, these differentials are smaller and faster to apply on devices that have already synced to the latest checkpoint cumulative update.
Tip: For a refresher on prior improvements, refer to Windows 11 cumulative updates improvements: an overview and Faster. Smaller. Windows 11, version 22H2 update fundamentals.
Server-side sustainable redistribution
Up to this point, updates have been packaged in a single file that continues to grow over time. This file is downloaded or cached on to the distribution points for redistribution whether they’re Microsoft front-end servers or your remote branch offices. For subsequent updates after a checkpoint, you don’t need to redistribute all the content accumulated since RTM. Once you download a checkpoint file, you can use file-level deduplication to only download incremental files in the subsequent updates. Reserve valuable energy resources only for what’s necessary.
Optimized and sustained feature update delivery via enablement packages
When an annual feature update is delivered using servicing technology and an enablement package, this new release shares a common core operating system with the previous release.[2] This means that it also shares the same monthly updates. The result is single update files become increasingly larger and more impactful with every new release that has its own servicing lifecycle.
When a checkpoint is introduced in alignment with the availability of a feature update with an enablement package, the monthly updates for those releases can start fresh and small. This means that Microsoft can scale to more enablement packages for feature updates, and you can adopt them faster, more easily, and more efficiently than a traditional feature update.
These optimizations are especially designed to help your organization to adopt the continuous innovation model of Windows 11. With annual enablement-package–based feature updates, you can improve your security posture and compliance by ensuring that your devices are always running the latest of Windows 11.
Get ready
We encourage you to check out the preview experience today in Windows Insider Preview Build 26120.1252 (Dev Channel).
We’re passionate about keeping your device protected and productive. As the teams that bring you Windows updates every month, we’ve embraced continuous delivery of innovation and make improvements regularly. We’re excited about this newest innovation for cumulative updates, and we hope that you try Windows 11 checkpoint cumulative updates soon!
[1] Read about Delivering continuous innovation in Windows 11.
[2] To review how enablement packages work, see What’s new for IT pros in Windows 11, version 23H2 and KB5027397.
Continue the conversation. Find best practices. Bookmark the Windows Tech Community, then follow us @MSWindowsITPro on X and on LinkedIn. Looking for support? Visit Windows on Microsoft Q&A.
Microsoft Tech Community – Latest Blogs –Read More
Comparing feature sets for AKS enabled by Azure Arc deployment options
This article shows a comparison of features available for the different deployment options under AKS enabled by Azure Arc.
AKS on Azure Stack HCI, version 23H2
AKS Edge Essentials
AKS on Windows Server and AKS on Azure Stack HCI 22H2
Supported infrastructure where the Kubernetes clusters are hosted
Azure Stack HCI, version 23H2
Windows 10/11 IoT Enterprise
Windows 10/11 Enterprise
Windows 10/11 Pro
Windows Server 2019/2022
Azure Stack HCI 22H2
Windows Server 2019
Windows Server 2022
CNCF conformant?
Yes
Yes
Yes
K8s cluster lifecycle management tools (create, scale, upgrade and delete clusters)
Az CLI
Az PowerShell
Azure Portal
ARM templates
PowerShell
PowerShell
Windows Admin Center
Kubernetes cluster management plane
Kubernetes clusters are managed by Arc Resource Bridge that runs as part of infrastructure components on the Azure Stack HCI cluster.
Kubernetes clusters are self-managed, to preserve resources.
Kubernetes clusters are managed using a “management cluster”, that is installed using PowerShell before Kubernetes workload clusters can be created.
Can you use kubectl and other open-source Kubernetes tools?
Yes
Yes
Yes
Supported Kubernetes versions.
Supports K8s only.
Continuous updates to supported Kubernetes versions. For latest version support, run az aksarc get-versions.
Supports K3s and K8s. Continuous updates to supported Kubernetes versions. For the latest version, visit steps to prepare your machine for AKS Edge Essentials.
Supports K8s only.
Continuous updates to supported Kubernetes versions. For latest version support, visit AKS hybrid releases on GitHub.
Azure Fleet Manager integration
No
No
No
Terraform integration
Not yet
No
No
Azure Monitor integration
Yes, via Arc extensions
Yes, via Arc extensions
Yes, via Arc extensions
The following is a comparison between node pool capabilities for AKS enabled by Azure Arc deployment options:
AKS on Azure Stack HCI, version 23H2
AKS Edge Essentials
AKS on Windows Server and Azure Stack HCI 22H2
Windows nodepool support
Yes
Windows Server 2019 Datacenter
Windows Server 2022 Datacenter
Yes
Windows Server 2022 Datacenter (Core)
Yes
Windows Server 2019 Datacenter
Windows Server 2022 Datacenter
Linux OS options
Container Runtime
Containerd for Linux and Windows nodes.
Containerd for Linux and Windows nodes.
Containerd for Linux and Windows nodes.
Node pool auto-scalar
Yes
No (manually add nodes)
Yes
Horizontal pod scalar
Yes
No
Yes
GPU support
Yes
No
Yes
Azure container registry
Yes
Yes
Yes
The following is a comparison between networking features for AKS enabled by Azure Arc deployment options:
AKS on Azure Stack HCI, version 23H2
AKS Edge Essentials
AKS on Windows Server and Azure Stack HCI 22H2
Network creation and management
You need to create the network in Azure Stack HCI 23H2 before creating an AKS cluster. You also need to ensure the network has the right connectivity and IP address availability for a successful cluster creation and operation.
You need to provide the IP address range for node IPs and Service IPs, that is available and has the right connectivity. The network configuration needed for the cluster is handled by AKS. Read AKS Edge Essentials networking.
You need to create the network in Windows Server before creating an AKS cluster. You also need to ensure the Read network has the right connectivity and IP address availability for a successful cluster creation and operation.
Supported networking options
Static IP networks with/without VLAN ID
Static IP address or use reserved IPs when using DHCP
DHCP networks with/without VLAN ID
Static IP networks with/without VLAN ID
SDN support
No
No
Yes
Supported CNIs
Calico
Calico (K8s)
Flannel (K3s)
Calico
Load balancer
MetalLB Arc extension
Bring your own load balancer (BYOLB)
KubeVIP
MetalLB Arc extension
Bring your own load balancer (BYOLB)
HAProxy
MetalLB Arc extension
SDN load balancer
Bring your own load balancer (BYOLB)
The following is a comparison between storage features for AKS enabled by Azure Arc deployment options:
AKS on Azure Stack HCI, version 23H2
AKS Edge Essentials
AKS on Windows Server and Azure Stack HCI 22H2
Types of supported persistent volumes
Read Write Once
Read Write Many
PVC using local storage
Read Write Once
Read Write Many
Container Storage Interface (CSI) support
Yes
Yes
Yes
CSI drivers
Disk and Files (SMB and NFS) drivers installed by default.
Support for SMB and NFS storage drivers.
Support for SMB and NFS storage drivers.
Dynamic provisioning support
Yes
Yes
Yes
Volume resizing support
Yes
Yes
Yes
The following is a comparison between security and authentication options in AKS and AKS enabled by Azure Arc:
AKS on Azure Stack HCI, version 23H2
AKS Edge Essentials
AKS on Windows Server and Azure Stack HCI 22H2
Access to Kubernetes clusters
Kubectl
Kubectl
Kubectl
Kubernetes cluster authentication
Certificate based Kubeconfig
Microsoft Entra ID
Certificate based Kubeconfig
Microsoft Entra ID
Certificate based Kubeconfig
Microsoft Entra ID
Active Directory SSO
Kubernetes cluster authorization (RBAC)
Kubernetes RBAC
Azure RBAC
Kubernetes RBAC
Kubernetes RBAC
Support for network policies
No
No
Yes – only for Linux containers
Limit source networks that can access API server
Yes
Yes
Yes
Certificate rotation and encryption
Yes
Yes
Yes
Secrets store CSI driver
Yes
Yes
Yes
gMSA support
No
Yes
Yes
Azure policy
Yes, via Arc extensions
Yes, via Arc extensions
Yes, via Arc extensions
Azure Defender
No
Yes, via Arc extensions (preview)
Yes, via Arc extensions (preview)
The following is a comparison between pricing and SLA for AKS and AKS enabled by Azure Arc:
AKS on Azure Stack HCI, version 23H2
AKS Edge Essentials
AKS on Windows Server and Azure Stack HCI 22H2
Pricing
Pricing is based on the number of workload cluster vCPUs. Control plane node nodes are free.
Azure Stack HCI, version 23H2 is priced a $10/physical core and
AKS workload VMs is $24/vcpu/month.
$2.50 per device per month.
Pricing is based on the number of workload cluster vCPUs. Control plane nodes & load balancer VMs are free.
Azure Stack HCI, version 23H2 is priced a $10/physical core and
AKS workload VMs is $24/vcpu/month.
Azure hybrid benefit support
Yes
No
Yes
SLA
No SLA offered since the Kubernetes cluster is running on-premises.
No SLA offered since the Kubernetes cluster is running on-premises.
No SLA offered since the Kubernetes cluster is running on-premises.
Microsoft Tech Community – Latest Blogs –Read More
What’s new in July: Azure Innovate & Azure Migrate and Modernize are built to work together.
A new Innovate with Azure AI Platform scenario for pre-sales and post-sales.
Evolving Build and Modernize AI Apps coverage for additional scenarios.
For ISVs – Build and Modernize AI Apps and Analytics will now support large Pilot/POV engagement types.
We are also launching AI envisioning and Proof of Value support for ISVs, as a part of Azure Innovate partner-led Build and Modernize AI Apps scenarios. Qualified SI partners now have a path to directly nominate ISVs for providing AI Envisioning and Proof of Value (PoV) support. AI envisioning sessions will help software companies define AI use cases, understand best practices, and develop optimal technical approaches with a proof of value/pilot to build AI-powered apps.
Platform level changes and enhancements to improve the partner experience:
MSFT sellers now get visibility of SI post-sales deployments for increased co sell opportunities.
Updated partner-led governance – Shift from 2:1 to 3:1 for pre-sales to post-sales governance ratio increasing the total pre-sales engagements available to partners to drive deployments.
Expanded eligibility with Microsoft Certified Software Designations for ISV offers.
Learn more and nominate today
Microsoft Tech Community – Latest Blogs –Read More
How to Create a QᴜɪᴄKBᴏᴏᴋs Portable Company File: Step-by-Step Guide
Creating a QᴜɪᴄKBᴏᴏᴋs portable company file allows for easy sharing and transferring of financial data. Here’s a concise guide:
1. **Open QᴜɪᴄKBᴏᴏᴋs :** Launch QᴜɪᴄKBᴏᴏᴋs Desktop and open the company file you wish to create a portable version of.
2. **Access File Menu:** Click on the “File” menu at the top-left corner of the screen.
3. **Select Create Copy:** Choose “Create Copy…” from the dropdown menu.
4. **Choose Portable Company File:** In the window that appears, opt for “Portable company file” and click “Next.”
5. **Save File:** Select the location where you want to save the portable file. QᴜɪᴄKBᴏᴏᴋs automatically appends a “.QBM” extension.
6. **Send or Transfer:** Share the portable file via email, USB drive, or any preferred method.
Creating a QᴜɪᴄKBᴏᴏᴋs portable company file is ideal for sending data to your accountant, creating backups, or for easy migration to a different computer. Ensure to backup your original company file before making any changes.
Creating a QᴜɪᴄKBᴏᴏᴋs portable company file allows for easy sharing and transferring of financial data. Here’s a concise guide: 1. **Open QᴜɪᴄKBᴏᴏᴋs :** Launch QᴜɪᴄKBᴏᴏᴋs Desktop and open the company file you wish to create a portable version of.2. **Access File Menu:** Click on the “File” menu at the top-left corner of the screen.3. **Select Create Copy:** Choose “Create Copy…” from the dropdown menu.4. **Choose Portable Company File:** In the window that appears, opt for “Portable company file” and click “Next.”5. **Save File:** Select the location where you want to save the portable file. QᴜɪᴄKBᴏᴏᴋs automatically appends a “.QBM” extension.6. **Send or Transfer:** Share the portable file via email, USB drive, or any preferred method. Creating a QᴜɪᴄKBᴏᴏᴋs portable company file is ideal for sending data to your accountant, creating backups, or for easy migration to a different computer. Ensure to backup your original company file before making any changes. Read More
Email address autofill disaster
I have a very very upsetting situation. I work in a medi-cal provider, and when I type in her email address, outlook has somehow connected the email address as a person, and connected another email address to the entry. Also, there are literally no entries in the address book, so I have no idea how I can track down and correct this problem. I have already sent medically sensitive information to the wrong person because of this weirdness 🙁
example:
I type in email address removed for privacy reasons and it shows the autofill with email address removed for privacy reasons in larger font, and below it in smaller font it displays email address removed for privacy reasons. So when I type email address removed for privacy reasons in the To: field, it send the message to email address removed for privacy reasons. This happens even when I do not select the autofill dropdown option. Again, when I click on the address book there are no entries that I could edit and resolve this. Help!!!
I have a very very upsetting situation. I work in a medi-cal provider, and when I type in her email address, outlook has somehow connected the email address as a person, and connected another email address to the entry. Also, there are literally no entries in the address book, so I have no idea how I can track down and correct this problem. I have already sent medically sensitive information to the wrong person because of this weirdness :(example:I type in email address removed for privacy reasons and it shows the autofill with email address removed for privacy reasons in larger font, and below it in smaller font it displays email address removed for privacy reasons. So when I type email address removed for privacy reasons in the To: field, it send the message to email address removed for privacy reasons. This happens even when I do not select the autofill dropdown option. Again, when I click on the address book there are no entries that I could edit and resolve this. Help!!! Read More
What Causes 🅠🅤🅘🅒🅚🅑🅞🅞🅚🅢 Online Error Code 101 and How Can It Be Fixed?
🅠🅤🅘🅒🅚🅑🅞🅞🅚🅢 Online Error Code 101 typically occurs due to a problem connecting to your bank account. Causes include incorrect bank login credentials, outdated browser settings, or connectivity issues. To fix it:
Verify Login Information: Ensure your bank login credentials are correct.Update Browser: Use the latest version of your web browser.Clear Cache and Cookies: Clear your browser’s cache and cookies.Check Bank’s Website: Verify there are no issues with the bank’s website.Reconnect Account: Disconnect and reconnect your bank account in 🅠🅤🅘🅒🅚🅑🅞🅞🅚🅢.
If the issue persists, contact 🅠🅤🅘🅒🅚🅑🅞🅞🅚🅢 support.
🅠🅤🅘🅒🅚🅑🅞🅞🅚🅢 Online Error Code 101 typically occurs due to a problem connecting to your bank account. Causes include incorrect bank login credentials, outdated browser settings, or connectivity issues. To fix it:Verify Login Information: Ensure your bank login credentials are correct.Update Browser: Use the latest version of your web browser.Clear Cache and Cookies: Clear your browser’s cache and cookies.Check Bank’s Website: Verify there are no issues with the bank’s website.Reconnect Account: Disconnect and reconnect your bank account in 🅠🅤🅘🅒🅚🅑🅞🅞🅚🅢.If the issue persists, contact 🅠🅤🅘🅒🅚🅑🅞🅞🅚🅢 support. Read More
How do I fix QᴜɪᴄᴋBᴏᴏᴋs Error 6123?
QᴜɪᴄᴋBᴏᴏᴋs Error 6123 occurs when opening or updating a company file. To fix it, ensure QᴜɪᴄᴋBᴏᴏᴋs is updated to the latest version. Rename the .ND and .TLG files associated with the company file, then reopen QᴜɪᴄᴋBᴏᴏᴋs. Disable any third-party security software temporarily. If the problem persists, move the company file to a different location and open it from there. Running the QᴜɪᴄᴋBᴏᴏᴋs File Doctor tool can also help resolve this error by repairing the company file and network issues.
QᴜɪᴄᴋBᴏᴏᴋs Error 6123 occurs when opening or updating a company file. To fix it, ensure QᴜɪᴄᴋBᴏᴏᴋs is updated to the latest version. Rename the .ND and .TLG files associated with the company file, then reopen QᴜɪᴄᴋBᴏᴏᴋs. Disable any third-party security software temporarily. If the problem persists, move the company file to a different location and open it from there. Running the QᴜɪᴄᴋBᴏᴏᴋs File Doctor tool can also help resolve this error by repairing the company file and network issues. Read More
How Can I Resolve the Quick=B00ks Restore Failed Error?
To resolve the “Quick=B00ks Restore Failed” error, ensure the backup file isn’t corrupted. Check file permissions and ensure it’s compatible with your Quick=B00ks version. Rename the file to a shorter, simpler name without special characters. Transfer the file to your local drive, such as the C: drive. Use Quick=B00ks to open the file via File > Open or Restore Company, and follow prompts. If problems persist, consider using Quick=B00ks Auto Data Recovery or contacting Quick=B00ks support for advanced troubleshooting.
To resolve the “Quick=B00ks Restore Failed” error, ensure the backup file isn’t corrupted. Check file permissions and ensure it’s compatible with your Quick=B00ks version. Rename the file to a shorter, simpler name without special characters. Transfer the file to your local drive, such as the C: drive. Use Quick=B00ks to open the file via File > Open or Restore Company, and follow prompts. If problems persist, consider using Quick=B00ks Auto Data Recovery or contacting Quick=B00ks support for advanced troubleshooting. Read More
Intune configuration policy
Hello All,
Is there Intune configuration policy available for disabling outlook’s “Cached exchange mode” for shared PCs? . I know that it is available as user policy but i need this for shared PCs.
Hello All, Is there Intune configuration policy available for disabling outlook’s “Cached exchange mode” for shared PCs? . I know that it is available as user policy but i need this for shared PCs. Read More
How do I move QᴜɪᴄᴋBᴏᴏᴋs to a new computer?
To move QᴜɪᴄᴋBᴏᴏᴋs to a new computer, follow these steps:
Create a Backup: On your old computer, open QᴜɪᴄᴋBᴏᴏᴋs and create a backup of your company file by going to “File” > “Back Up Company” > “Create Local Backup.”
Install QᴜɪᴄᴋBᴏᴏᴋs on New Computer: Download the QᴜɪᴄᴋBᴏᴏᴋs installer from the Intuit website and install it on your new computer using your product license and key.
Restore Backup on New Computer: Transfer the backup file to the new computer using a USB drive or a secure cloud service. Open QᴜɪᴄᴋBᴏᴏᴋs on the new computer and go to “File” > “Open or Restore Company” > “Restore a Backup Copy” to restore the file.
Update and Verify Data: Ensure QᴜɪᴄᴋBᴏᴏᴋs is updated to the latest version and verify that all your data is intact by checking key reports and balances.
Following these steps will help you seamlessly transition QᴜɪᴄᴋBᴏᴏᴋs to your new computer without data loss.
To move QᴜɪᴄᴋBᴏᴏᴋs to a new computer, follow these steps:Create a Backup: On your old computer, open QᴜɪᴄᴋBᴏᴏᴋs and create a backup of your company file by going to “File” > “Back Up Company” > “Create Local Backup.”Install QᴜɪᴄᴋBᴏᴏᴋs on New Computer: Download the QᴜɪᴄᴋBᴏᴏᴋs installer from the Intuit website and install it on your new computer using your product license and key.Restore Backup on New Computer: Transfer the backup file to the new computer using a USB drive or a secure cloud service. Open QᴜɪᴄᴋBᴏᴏᴋs on the new computer and go to “File” > “Open or Restore Company” > “Restore a Backup Copy” to restore the file.Update and Verify Data: Ensure QᴜɪᴄᴋBᴏᴏᴋs is updated to the latest version and verify that all your data is intact by checking key reports and balances.Following these steps will help you seamlessly transition QᴜɪᴄᴋBᴏᴏᴋs to your new computer without data loss. Read More
Why do you waste my time with some stupid puzzles in labs to verify account?
Just tried 15 steps, nothing looks similar, very hard to find, and it told me to try again.. Like wtf?
How do i skip this?
Just tried 15 steps, nothing looks similar, very hard to find, and it told me to try again.. Like wtf?How do i skip this? Read More
How Can I Resolve QᵘⁱᶜᵏB00ᵏˢ ᵉʳʳᵒʳ ⁵⁹⁰?
To resolve QᵘⁱᶜᵏB00ᵏˢ Error 590, follow these steps:
Ensure your QᵘⁱᶜᵏB00ᵏˢ Online is updated to the latest version.Verify that your bank’s login credentials are correct and up-to-date.Clear your browser’s cache and cookies, then try reconnecting your bank account.If you use multi-factor authentication (MFA) with your bank, disable it temporarily during the connection process.Disconnect and reconnect your bank account in QᵘⁱᶜᵏB00ᵏˢ :Go to Banking > Banking tab.Select the affected bank account, click the pencil icon, and choose “Edit account info.”Click “Disconnect this account on save” and reconnect it.
If the problem persists, contact QᵘⁱᶜᵏB00ᵏˢ support for further assistance
To resolve QᵘⁱᶜᵏB00ᵏˢ Error 590, follow these steps:Ensure your QᵘⁱᶜᵏB00ᵏˢ Online is updated to the latest version.Verify that your bank’s login credentials are correct and up-to-date.Clear your browser’s cache and cookies, then try reconnecting your bank account.If you use multi-factor authentication (MFA) with your bank, disable it temporarily during the connection process.Disconnect and reconnect your bank account in QᵘⁱᶜᵏB00ᵏˢ :Go to Banking > Banking tab.Select the affected bank account, click the pencil icon, and choose “Edit account info.”Click “Disconnect this account on save” and reconnect it.If the problem persists, contact QᵘⁱᶜᵏB00ᵏˢ support for further assistance Read More
Power Query Connecting to Datasource
It takes 2 minutes to connect to two Power Query tables in a 724 KB Excel file.
The source data comes from two Excel files: the first Excel file is 10.3 MB and has five tables used in subsequent queries; the second is 388 KB of raw data.
The two “final” tables are fed by 9 “connection only” or feeder queries with five different merges.
One of the final tables is 1,860 rows and the other is 730 rows.
There is nothing especially fancy or complicated in any of the Queries except for “pivots.”
None of the “connection only” queries have any “Refresh control,” but the two final tables are set to “Refresh…when opening…” and “Enable Fast Data Load.”
I have a simple UDF (.xlam) “add-in” with about 10 lines of VBA code that sets the X- and Y- axis minimums and maximums for graphs.
It takes just about as long to connect without the UDF as it does with the UDF.
I’ve gone through many of the online videos and articles to help speed up a query.
I’m on Build 26100.1150 ge_release, running a Dell Latitude 7340 64-bit processor with 16 GB of memory.
I’d love the help and advice of this community. Thanks in advance.
It takes 2 minutes to connect to two Power Query tables in a 724 KB Excel file. The source data comes from two Excel files: the first Excel file is 10.3 MB and has five tables used in subsequent queries; the second is 388 KB of raw data. The two “final” tables are fed by 9 “connection only” or feeder queries with five different merges.One of the final tables is 1,860 rows and the other is 730 rows. There is nothing especially fancy or complicated in any of the Queries except for “pivots.” None of the “connection only” queries have any “Refresh control,” but the two final tables are set to “Refresh…when opening…” and “Enable Fast Data Load.” I have a simple UDF (.xlam) “add-in” with about 10 lines of VBA code that sets the X- and Y- axis minimums and maximums for graphs.It takes just about as long to connect without the UDF as it does with the UDF. I’ve gone through many of the online videos and articles to help speed up a query. I’m on Build 26100.1150 ge_release, running a Dell Latitude 7340 64-bit processor with 16 GB of memory. I’d love the help and advice of this community. Thanks in advance. Read More
How to change my field selection.
currently, this is my selection. =IF(OR(D3:V3<1000), 5, 0)
I want to search D3:V3 if the amount is greater than 300 or less than 1000. I still want to end with 5, 0.
How can I do this?
Thanks
currently, this is my selection. =IF(OR(D3:V3<1000), 5, 0)I want to search D3:V3 if the amount is greater than 300 or less than 1000. I still want to end with 5, 0.How can I do this?Thanks Read More
Date check doesn’t seem to be working
I have a date check in my Flow that doesn’t seem to be working. I’m just wondering if a blank Reviewed date is considered to be less than the current date -5 days? Here is the current date formula
.
I have a date check in my Flow that doesn’t seem to be working. I’m just wondering if a blank Reviewed date is considered to be less than the current date -5 days? Here is the current date formulaformatdatetime(adddays(utcNow(),-5),’MM-dd-yyyy’). Read More
Power Point – Copy Formatting of picture to another picture
Hello,
I formatted a picture and I want to copy the formatting to a similar image but it’s not working right. I tried the format painter and tried to copy the format settings but neither work or had the same results I wanted. Here is a link to the file
Hello, I formatted a picture and I want to copy the formatting to a similar image but it’s not working right. I tried the format painter and tried to copy the format settings but neither work or had the same results I wanted. Here is a link to the file Read More
Wʜʏ ɪs ɪᴛ ɪᴍᴘᴏʀᴛᴀɴᴛ ᴛᴏ ʀᴇɢᴜʟᴀʀʟʏ ᴜᴘᴅᴀᴛᴇ ᴛʜᴇ ᴘᴀʏ=ʀᴏʟʟ ᴛᴀx ᴛᴀʙʟᴇ ɪɴ QuIcKB000Ks ﹖
Regularly updating the pay=roll tax table in QuIcKB000Ks is crucial for accuracy and compliance. Tax laws and rates frequently change, and updates ensure that your pay=roll calculations are correct and compliant with current regulations. This helps prevent errors in employee wages, deductions, and tax withholdings. Additionally, updating the tax table ensures that your business meets legal obligations, avoids penalties, and maintains smooth operations without interruptions or discrepancies in pay=roll processing. Stay informed about tax law changes and regularly check for updates within QuIcKB000Ks to maintain precision and compliance in your pay=roll management.
Regularly updating the pay=roll tax table in QuIcKB000Ks is crucial for accuracy and compliance. Tax laws and rates frequently change, and updates ensure that your pay=roll calculations are correct and compliant with current regulations. This helps prevent errors in employee wages, deductions, and tax withholdings. Additionally, updating the tax table ensures that your business meets legal obligations, avoids penalties, and maintains smooth operations without interruptions or discrepancies in pay=roll processing. Stay informed about tax law changes and regularly check for updates within QuIcKB000Ks to maintain precision and compliance in your pay=roll management. Read More
cannot plot vertical aligned column range in chart.net
Hi
I need to plot 10 column range vertical aligned.
With this code I have compensate disalignment BUT after 4 plot it become again disaligned:
Me.Invoke(Sub()
Chart.Series(“FOOT”).Points.AddXY(Indice_Corrente, Dato_Base_FOOT, Dato_Plot_FOOT)
Chart.Series(“SX_UP”).Points.AddXY(Indice_Corrente – 0.65, Dato_Base_SX_UP, Dato_Plot_SX_UP)
Chart.Series(“SX_DOWN”).Points.AddXY(Indice_Corrente – 1.3, Dato_Base_SX_DOWN, Dato_Plot_SX_DOWN)
End Sub)
Why????????
HiI need to plot 10 column range vertical aligned.With this code I have compensate disalignment BUT after 4 plot it become again disaligned:Me.Invoke(Sub()Chart.Series(“FOOT”).Points.AddXY(Indice_Corrente, Dato_Base_FOOT, Dato_Plot_FOOT)Chart.Series(“SX_UP”).Points.AddXY(Indice_Corrente – 0.65, Dato_Base_SX_UP, Dato_Plot_SX_UP)Chart.Series(“SX_DOWN”).Points.AddXY(Indice_Corrente – 1.3, Dato_Base_SX_DOWN, Dato_Plot_SX_DOWN)End Sub) Why???????? Read More
ᴴᵒʷ ᶜᵃⁿ ᴵ ᵈᵒʷⁿˡᵒᵃᵈ ᵃⁿᵈ ⁱⁿˢᵗᵃˡˡ ᵗʰᵉ Qᵘⁱᶜᵏ=ᴮ00ᵏˢ ᶜᵒᵐᵖᵒⁿᵉⁿᵗ ᴿᵉᵖᵃⁱʳ ᵀᵒᵒˡ?”
To download and install the Qᵘⁱᶜᵏ=ᴮ00ᵏˢ Component Repair Tool, follow these steps:
Visit the official Qᵘⁱᶜᵏ=ᴮ00ᵏˢ support website.Search for the “Qᵘⁱᶜᵏ=ᴮ00ᵏˢ Component Repair Tool.”Click on the download link and save the file to your computer.Once downloaded, locate the file and double-click to run the installer.Follow the on-screen instructions to complete the installation.After installation, run the tool to repair any QQᵘⁱᶜᵏ=ᴮ00ᵏˢ components issues.
This tool helps fix problems related to Microsoft components used by Qᵘⁱᶜᵏ=ᴮ00ᵏˢ, such as .NET Framework, MSXML, and C++.
To download and install the Qᵘⁱᶜᵏ=ᴮ00ᵏˢ Component Repair Tool, follow these steps:Visit the official Qᵘⁱᶜᵏ=ᴮ00ᵏˢ support website.Search for the “Qᵘⁱᶜᵏ=ᴮ00ᵏˢ Component Repair Tool.”Click on the download link and save the file to your computer.Once downloaded, locate the file and double-click to run the installer.Follow the on-screen instructions to complete the installation.After installation, run the tool to repair any QQᵘⁱᶜᵏ=ᴮ00ᵏˢ components issues.This tool helps fix problems related to Microsoft components used by Qᵘⁱᶜᵏ=ᴮ00ᵏˢ, such as .NET Framework, MSXML, and C++. Read More
How do I fix QᴜɪᴄᴋBᴏᴏᴋs Error OL-301?
QᴜɪᴄᴋBᴏᴏᴋs Error OL-301 occurs during online banking due to incorrect account information or connectivity issues. To fix it, verify your bank login credentials and ensure they are up-to-date in QᴜɪᴄᴋBᴏᴏᴋs. Update QᴜɪᴄᴋBᴏᴏᴋs to the latest version and ensure your internet connection is stable. Deactivate and reactivate your online banking services within QᴜɪᴄᴋBᴏᴏᴋs. If the issue persists, contact your bank to ensure there are no issues on their end or changes in their services.
QᴜɪᴄᴋBᴏᴏᴋs Error OL-301 occurs during online banking due to incorrect account information or connectivity issues. To fix it, verify your bank login credentials and ensure they are up-to-date in QᴜɪᴄᴋBᴏᴏᴋs. Update QᴜɪᴄᴋBᴏᴏᴋs to the latest version and ensure your internet connection is stable. Deactivate and reactivate your online banking services within QᴜɪᴄᴋBᴏᴏᴋs. If the issue persists, contact your bank to ensure there are no issues on their end or changes in their services. Read More