iTechGuides is reader-supported. When you buy through links on our site, we may earn an affiliate commission. As an Amazon Associate I earn from qualifying purchases. Learn more
Make a backup copy first, then identify whether you have a stale link to a moved workbook, an invalid formula reference, an inaccessible source, or a compatibility problem. For a moved or renamed source, use Data > Queries and Connections > Workbook Links > Change source and select the workbook at its new location. If the error is #REF!, inspect the formula itself before changing any path; #REF! means Excel is pointing to a cell or range that is no longer valid.
Identify what is actually broken
Excel uses “link” for several unrelated features. Choosing the wrong repair tool can overwrite formulas or leave the real problem untouched.
| What you see | What it usually represents | Where to work |
|---|---|---|
A formula contains another workbook name, such as [Budget.xlsx], and values stop refreshing after that file moves |
A workbook link with a stale source path | Data > Queries and Connections > Workbook Links |
#REF! appears inside a formula |
An invalid cell, row, column, range, or function coordinate | The formula bar and the source formula structure |
| A clickable web address or document path no longer opens | A hyperlink, not a workbook-link formula | Edit the hyperlink or its target separately |
| Power Query or Get Data results fail to refresh | A query data source or connection | Queries & Connections, not Workbook Links |
| An Excel file migrated from Google Sheets has a broken-link card or incompatible formula | A migration compatibility or file-identity mapping issue | Excel for the web’s compatibility workflow and the migration source mapping |
Workbook links are formula references to cells in another workbook. They are not the same as hyperlinks. Microsoft’s Mac guidance specifically warns that repairing workbook links does not repair broken hyperlinks.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Before changing anything: preserve the original
Save a copy under a new name before changing a source, editing formulas, refreshing data, or breaking links. A repair can legitimately replace a formula with a value, and an incorrect source selection can update many cells at once. Keep the untouched file until you have checked representative results.
#1 Best Overall
- Powerful Turbo Fan:CAGIWIRU Electric Air Duster have reached speed up to 130000RPM,Can efficient remove dust and debris.With LED light and Three Adjustable Speed to meet with different cleaning tasks.
- With Attached USB C Fasting Charging cable.Charing 3 hours,Enjoy up to 240 minutes of use on the lowest setting, For third speed can use for 25mins.with four charging options to meet with your needs.
- Wide Application: attached 5 different nozzles,making it suitable for a variety of scenes, such as car,pet, pc, keyboards, and other electronic devices. It also serves for office and home clean duster.
- Handy Design & Portable:Cordless air duster electric nozzle is Light weight and small size, design and comfortable to hold and space saving, convenient to carry around. You can put it in your room or inside the car without taking up space.
- Economical &Reusable: Built durable materials with a long-lasting battery,our CAGIWIRU air duster it's a sustainable alternative to disposable air cans.
- Open the destination workbook and note which sheets, named ranges, charts, and reports depend on the source.
- Confirm that the intended source file exists and that your current Excel account or Windows user can open it.
- If the source is on a network or cloud location, test access from the same computer and account that opens the destination workbook.
- Record whether you need formulas to remain live or whether a one-time snapshot is acceptable. That decision determines whether you should relink or break the link.
Repair a moved or renamed source workbook
Use this workflow when the source workbook still contains the needed sheets and cells, but its file name or location changed. It keeps the formulas live and changes the source associated with the workbook link.
- Open and verify the source. Open the intended source workbook directly. Check the sheet names and the cells or ranges used by the destination. If the source was replaced by a similarly named file with different columns or sheets, stop and identify the correct file before relinking.
- Open the destination workbook. Work from the copy you made. If Excel displays an external-content or unsafe-links warning, do not automatically accept it; first establish whether the source is available.
- Open Workbook Links. Choose Data > Queries and Connections > Workbook Links. Excel versions and platforms can use slightly different labels, so look for the current command that lists external workbook links.
- Choose the source’s More Commands menu. Select the entry for the moved or renamed workbook, open its More Commands menu, and choose Change source.
- Select the replacement file. Browse to the source workbook’s current location and select it. Excel updates references associated with that source. Do not select a file merely because its name looks familiar; verify its content first.
- Recalculate or refresh. Recalculate the workbook or refresh the linked content as appropriate for your Excel version. If Excel asks whether to enable external content, enabling it is required for current values to be retrieved from an accessible source.
- Check the result. Compare several linked values with the source, including a value from each important sheet or range. Check totals and any downstream formulas that depend on those values.
- Save the repaired copy. Keep the original backup until the workbook has been opened again and validated.
Changing a source applies to the workbook link as a whole. If only one cell has the wrong external reference, use the individual-formula method below instead.
Change one formula without relinking every reference
Sometimes most links are correct and only one formula points to an old file. Editing the individual external reference limits the change to that cell or selected range.
Free tools Windows power users keep installed
One-click scans. No signup required.
- Select the cell that displays the wrong result or error.
- Read the complete formula in the formula bar. Identify the external workbook name or path, the worksheet name, and the cell or range.
- Replace only the old workbook path or file name with the correct location. Preserve the sheet name and the cell or range reference unless those also changed.
- Press Enter, then inspect the result and compare it with the corresponding source value.
- Repeat only for formulas that genuinely require a different source. A broad find-and-replace can alter text, sheet names, or formulas that should continue pointing to the original workbook.
While the source workbook is open, Excel may display a compact reference such as =SUM([Budget.xlsx]Annual!C10:C25). After the source is closed, the same reference may appear as =SUM('C:Reports[Budget.xlsx]Annual'!C10:C25). Single quotation marks surround names or paths containing spaces or non-alphabetical characters. Do not remove those quotes when editing a formula.
Rank #2
- Screen Cleaner is Your Screen’s New Bestfriend! - EVEO is proud to present a screen cleaner that’s perfectly suited for your TV. Meet your new screen cleaner, computer screen cleaner, laptop cleaner, iPad cleaner, Macbook,tv cleaner or any other electronic device. Our screen cleaner spray and wipe along with the included plush microfiber cloth, easily removes dust, fingerprints & other smudges on the screen’s surface. Clean effectively for a streak-free screen
- Gentle on your Screens - Our screen cleaner spray and wipes is compatible to be used even for the most sensitive LCD, LED, CRT, and OLED screens in proper use. Be at ease knowing that this product is compatible with all the major brands: LG, SONY, Samsung, Sharp, iPad, iPhone, Android screens, Kindle, PC monitors - we’ve got you covered! Can be used as LCD screen cleaner, tv cleaner, smart tv screen cleaner, and more
- Premium Super Soft Plush Microfiber Cloth - Included in this efficient screen cleaning kit. This screen cleaner spray and wipe has our signature plush microfiber cloth specially designed to comply with screens and monitors and leave them streak-free. Has been shown to effectively absorbs stubborn stains, zero streaks, and no fiber shedding. Always use this together with our screen cleaner for the best results
- Easy-to-Use Screen Cleaner Kit + microfiber cleaning cloth - The EVEO Screen Cleaning Kit will easily be your new favorite tool when it comes to taking care of the things you love most, quick and easy solution for a streak-free screen. Simply screw on the sprayer gun on the screen cleaner bottle. Spray the cleaning liquid onto the microfiber cloth, then wipe the screen until desired cleanliness & shine is achieved.
- Quality Screen Care Kit Worth Purchasing - Enjoy a convenient Screen Cleaner anytime, anywhere you need it. Your satisfaction is our top priority. We stand behind the quality of our products and that’s why, you shouldn’t be worrying at all. We manufacture the Best Screen Cleaner. and can be used for laptop cleaning kit, laptop screen cleaner, tv screen cleaner for smart tv. MacBook screen cleaner, monitor cleaner or screen cleaner spray for electronic devices with microfiber cleaning cloth
Diagnose #REF! before changing a file path
Microsoft defines #REF! as a formula reference to a cell that is not valid. A stale external path is only one possible cause. If the formula’s cell coordinates are invalid, selecting a new workbook will not repair it.
A referenced row or column was deleted
Inspect explicit references such as =SUM(B2,C2,D2). If a referenced column or row was deleted, Excel can replace that part of the formula with #REF!. Restore the deleted structure if appropriate, or edit the formula to point to the intended surviving cells. Check whether a paste operation overwrote the expected range.
A lookup or reference coordinate is outside its range
Check functions that request a row or column number. For example, =INDEX(B2:E5,5,5) asks for row 5 and column 5, but B2:E5 contains only four rows and four columns. Reduce the coordinates or expand the range to include the intended cell. Apply the same check to lookup formulas whose requested position is calculated from another cell.
INDIRECT points to a closed workbook
An INDIRECT reference to a closed workbook can return #REF!. Open the source workbook when the formula depends on it, then recalculate. This is a formula-function limitation, not necessarily a bad path in Workbook Links.
Rank #3
- 【Large size】：Measuring 800 x 300 mm/ 31. 5×12 inches, which is wider and taller than others. Large mouse pad can perfectly fit your keyboard and mouse of any size, and there is also ample space for peripherals such as phones, tablets, etc.
- 【LED backlight mouse pad】：Blade Hawks RGB mouse pad provides 7 static modes and 7 dynamic modes will give you the options you are looking for. Power-off memory function remembers the last lighting mode you selected. The super glow fiber Chroma will give you a colorful gaming setup that you want.
- 【Anti-slip rubber base】：Made from Natural rubber, this gaming mousepad will firmly grip your desktop, allowing you to enjoy the ultimate precision in the games you are most passionate about. It also comes with a texture that enhances this ability even further.
- 【Smooth and waterproof surface】: Micro-textured cloth surface, for extremely precise mouse control and a smooth movement. When liquid splashes on the gaming mouse pad, it forms water droplets and slides down. Will not delay your work or gameplay.
- 【Plug and play】: This mouse and keyboard pad is powered by USB, plug and play, no driver required. One button control light modes. Press one time to change the lighting mode, press twice to change the brightness, press and hold about 3 seconds turn ON/OFF.
A dynamic-array formula uses a closed source
Microsoft also notes that a dynamic-array function referencing a closed workbook can produce #REF!. Open the source and recalculate, or redesign the formula so it does not require a closed external workbook. Test the result with the source both open and closed if other users will receive the file.
If correcting the source path does not remove #REF!, return to the formula bar and repair the reference or function coordinates. Do not label every #REF! error a broken external link.
Resolve mapped-drive, UNC, and relative-path problems
Two computers can reach the same server through different path forms. One user may open a source through a mapped drive such as R:Reports; another may use a UNC path such as \ServerReports. Excel can retain the path form used when the link was created and does not necessarily switch between them just because both routes are available.
- Open the source using the path form that the current user can access consistently.
- Compare the path shown in the formula bar and in Workbook Links with the actual location. Excel may combine stored relative-path information with the current source location when the destination opens, so the displayed formula is not always a complete picture of what is stored.
- If a mapped drive exists only for some users, use an accessible, consistent location or change the source while signed in as the affected user.
- Check permissions, VPN or network connectivity, cloud synchronization status, and whether the file was renamed. A path can be correct while access is denied.
Do not silently convert live formulas to values just to suppress an update prompt caused by a temporarily unavailable network source.
Rank #4
- 【Softer and More Comfortable】Vaydeer wrist rest has unique diamond pattern, which is the combination of softness and aesthetics. The materials of wrist rest are improved into higher quality memory foam and covered with silky smooth lycra. The computer wrist rest makes you as comfortable and cushiony as like rest your wrists on clouds.
- 【Ergonomic Wrist Saver】The wrist rests for keyboard and mouse comes with a 17.32×3.15×0.83 inch keyboard wrist pad and a 5.94×3.15×0.83 inch mouse wrist support. Based on ergonomic design, the unique concave shape is the perfect fit for your wrist joints. The wrist rest pad fits most computer keyboards and laptops, improve hand and wrist posture, release your wrist and arm stress.
- 【Non-Slip Rubber Bottom】Featuring an anti-skid silicone base on the bottom, this wrist keyboard support stays firmly in place on your desk, preventing the padding from sliding around, ensuring stable and consistent wrist support during extended computer sessions.
- 【Better Experience & Pain Relief】Our keyboard arm rest is beneficial to alleviate the soreness caused by direct contact and friction between your arm and a hard desk surface, reducing the risk of wrist fatigue or carpal tunnel. The soft texture of memory foam can evenly distribute the pressure around your wrists and provide good support with just enough give.
- 【Helpful in Multiple Scenarios】Whether you're working, studying, writing, typing, gaming, this keyboard and mouse rest combo is an essential accessory to add comfort and support to your hands and wrists. It’s also a great gift for men, women, family, friend, coworker, gamer, teacher, etc.
Handle update prompts and unavailable sources safely
When Excel cannot connect to an external workbook, it may ask whether to update links. If the source is temporarily unavailable, Microsoft recommends choosing Don’t Update rather than pretending the link is repaired. Excel then leaves the latest stored result in place; it cannot retrieve a new value without a connection.
A displayed number after choosing Don’t Update is therefore not proof that the link works. Reopen the workbook after restoring access, enable external content when prompted, and verify that values refresh. If the workbook must circulate while the source is offline, tell recipients that the displayed figures are the last saved results.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Break links only when you intentionally want fixed values
Break links is a one-way data-preservation decision, not a repair that keeps formulas live. Microsoft says formulas using the selected linked workbook become their current values when the link is broken. The formula logic is removed, so later changes in the source will no longer flow into the destination.
- Save a separate backup of the destination workbook.
- Confirm that current values are sufficient and that no future refresh is required.
- Use the Workbook Links command to select the source and choose the current Break links command.
- Reopen the resulting copy and inspect formulas, totals, charts, and reports that depended on the source.
Review defined names and query parameters separately; they can contain references that are not removed or repaired by the same workbook-link operation. If you are breaking links merely because the source is offline, stop and relink or restore access instead.
Best Value
- 【No Drill Mounted】Cable management tray can be assembled in as little as 3 minutes or less-simply. Side clips easily clampe the edge of desk, pass through the holes on the sides, and secure excess cables with baskets. Desk cable management supports inward or outward installation to meet your needs in different scenarios, and provides you with great convenience when collecting and organizing wires.
- 【Rubber Pad Protects Desk】Wire organizer under desk built-in soft rubber pads on the clamp protect your desk from scratches, so you will not damage your furniture or office.
- 【Sturdy and Beautiful】Cord management under desk is made of high-quality carbon steel and holds about 15 lbs. The wire basket has 2 holes on each side of the tray to enable your cables to pass freely. Cable baskets are suitable for desk thickness use from 0.4" to 2.4".
- 【Space Saving & Keep Organized】Desk cable management tray holds all your power cords, outlet strips, USB hubs and computer transformers hidden from your feet, and the data cables will not enter the vacuum cleaner to keep your desk clean and tidy. Desk wire organizer is also suitable for use in the kitchen and outdoors.
- 【Reduce Safety Risks】Cable tray under desk keeps all plugs away from your kids, no more worry about tripping. Using 2 holes wire tray saves extra space, helps you easily cabling and wire protection. The mesh design is not easy to accumulate dust, but avoids safety accidents caused by messy wires.
Excel for Mac and Power Query cases
Excel for Mac
Excel for Mac includes a workbook-link repair process for data links, but that process does not fix hyperlinks. If a user clicks a link to a web page or document and it fails, edit that hyperlink independently. Menu names can differ from Windows, so use the Mac equivalent of the Workbook Links command in the Data area.
Power Query and Get Data
If the workbook imports data through Power Query (Get Data), manage the connection and refresh it through Queries & Connections. A Power Query source is not repaired by changing an ordinary formula-based workbook link. Inspect the query’s source settings, credentials, and accessible location, then refresh and validate the resulting table.
Repair links after migrating Google Sheets to Microsoft 365
Migration from Google Sheets is a special case. Google’s IMPORTRANGE formulas do not always map directly to Excel formulas, and a normal Change source operation may not be enough.
The Tool Desk
Outbyte PC Repair FREERepair Windows errors before they cause bigger problemsFix Now →Outbyte Driver Updater FREEFix the driver behind crashes, sound loss and screen glitchesFind Drivers →- Open the migrated workbook in Excel for the web and look for the compatibility pane or broken-link card.
- Select the broken-link card and choose Change source.
- Select the correct file in SharePoint or OneDrive and allow the linked content to refresh.
- Check whether the original Google file ID was associated with the destination file through the migration’s
MigrationSourceIDmapping. Automated repair depends on that identity mapping; third-party migration tools may need to configure it. - Review formulas that Excel flags as incompatible. Excel can replace some Google Sheets functions with Excel equivalents, but Microsoft warns that some formulas still require manual attention.
Confirm that both source and destination files are in the intended SharePoint or OneDrive locations. Treat a migration repair as complete only after checking representative formulas and results; compatibility automation does not guarantee that every formula was converted.
Validate the workbook after repair
- Close and reopen the destination workbook to test the link under normal startup conditions.
- Check Workbook Links for remaining old source entries.
- Compare sample values from every important linked sheet or range with the source workbook.
- Search formulas for
#REF!, and inspect named ranges, charts, and summary cells that depend on repaired formulas. - Refresh Power Query connections separately if the workbook uses them.
- Test from the network, mapped-drive, UNC, or cloud context used by the people who will open the file.
- Save a final verified copy and retain the original backup until the next reporting cycle has completed.
Choose the right action at a glance
| Your requirement | Action | What happens |
|---|---|---|
| Keep formulas live after a source move | Workbook Links > Change source | References associated with that source point to the selected workbook |
| Change one formula only | Edit its external reference in the formula bar | Only the selected formula or range changes |
| Fix a deleted-cell or invalid-coordinate error | Repair the formula, range, or function arguments | The reference becomes valid without changing the source file |
| Keep the last saved figures while a source is offline | Choose Don’t Update | Stored results remain; no new source data is retrieved |
| Stop depending on the source permanently | Break links after making a backup | Linked formulas become their current values |
| Repair a Power Query import | Queries & Connections | The query’s own source and connection are managed |
| Repair a migrated Google Sheets link | Excel for the web compatibility workflow and source-ID mapping | Migration-specific links and incompatible formulas are addressed |
Prevent the next break
Before moving a source workbook, decide whether its consumers need live formulas, a controlled archive, or a frozen report. If formulas must remain live, move or rename the source in a coordinated change, then open a representative destination workbook and use Change source immediately. Keep the path convention consistent for the people and systems that access the files, and test a closed-source reopen rather than checking only the values visible while both workbooks are open.
For recurring reports, document the source workbook’s expected sheets and ranges, the network or cloud location, and whether Power Query or ordinary formulas provide the data. That record makes it easier to distinguish an access outage from a genuinely invalid formula the next time a workbook changes.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
