How to Fix a Broken Link Behind a Printed Excel QR Code
Question details
The user needs to resolve an issue where a physically printed QR code generated from Excel directs users to a broken link or 404 error page.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- A QR code generated in Excel has already been printed, but the destination URL is now broken or returning a 404 error.
- Observed behavior
- Scanning the printed QR code leads to a dead link, and updating the original Excel file does not magically change the physical printouts.
Scan your printed QR code with your smartphone to identify the exact URL it is trying to reach, and determine whether it uses a direct static URL or a dynamic QR redirect service.
Set Up a Server-Side Redirect
If the printed QR code contains a static URL, the best way to fix the broken link without reprinting is to redirect the old web address to the new one on your server.
A static QR code physically encodes the destination URL into its black-and-white pattern. Once printed, the pattern cannot be changed. However, if you own the domain encoded in the QR code, you can intercept the traffic and forward it to the correct working page.
Scan the broken QR code using a mobile device and write down the exact URL that appears before the 404 error.
Log in to your web hosting control panel (like cPanel) or your website's CMS backend (like WordPress).
Set up a permanent 301 redirect so that any traffic attempting to visit the old URL is automatically forwarded to the new, active destination page.

Update the Dynamic QR Service Destination
If you originally generated the QR code using a dynamic QR code service, you can fix the broken link directly in the service's dashboard.
Generate and Print a New QR Code
If you used a static QR code and do not have control over the website's server to set up a redirect, your only option is to generate and print replacement QR codes.
Generate and Manage New QR Codes with WPS Spreadsheet
If you need to replace broken printed QR codes, WPS Spreadsheet offers powerful and intuitive tools to manage your URL lists, generate fresh QR codes, and format them perfectly for high-quality printing.
- 1. Open Your Document: Launch WPS Spreadsheet and open the document containing your list of URLs.
- 2. Update Broken Links: Locate the cells with broken URLs and replace them with the active, working web addresses.
- 3. Generate Fresh Codes: Use built-in features or add-ins in WPS to generate new QR codes corresponding to the updated links.
- 4. Format and Print: Arrange the new QR codes in your spreadsheet layout and use the print function to output replacement labels directly.

Frequently Asked Questions
Can modifying the Excel file fix a QR code that is already printed?
No. A printed static QR code contains a fixed geometric image pattern representing the exact characters of the URL. Modifying the source Excel file will only affect future printouts, not the existing physical copies.
What is the difference between a static and dynamic QR code?
A static QR code directly embeds your final destination URL and cannot be altered once printed. A dynamic QR code embeds a short redirect link provided by a management service, allowing you to update the final destination URL anytime without having to reprint the physical code.
Why does my printed QR code return a 404 error?
A 404 error occurs because the specific web page that the QR code is pointing to has been moved, deleted, or its URL was changed after the physical code was printed.
How can I prevent broken QR code links on future printed materials?
To prevent broken links on printed media, either ensure the URLs used are permanent and will never change, or use a dynamic QR code generator so you retain the ability to route traffic to a new URL if the original page goes down.




