Broken external links in Excel a leading file scheme appended to paths can t be evaluated in formulas

0 votes

I have long used Excel and have tested its limits, but this one is brand-new, likely as a result of a recent update, so I doubt anyone will run across the problem I am highlighting here.

I have a number of workbooks with cross-references in my formulas, all of which are saved in the same folder, making the external links in this folder relative (and supposedly unaffected by this folder being renamed...).


Recently, I discovered that cells with formulas referencing some of these linked workbooks could no longer be evaluated and would instead produce an error as if the workbooks had been transferred. The path of these referenced workbooks, which should begin with C:... in the formulas, now begins with file:/C:....

The formulas resume working if I enter the Edit Links window and manually edit the target workbooks (selecting the same workbooks).

They also function once I delete them by replacing the file:/// text with an empty string.

Broken links can also be found using this code in the Immediate window of the VBE:

?ActiveWorkbook.Name: ?"EXTERNAL LINKS: ": For Each l in ActiveWorkbook.LinkSources(XlLinkType.xlLinkTypeExcelLinks): ?"   "&l: Next

returns C:\File1.xlsx or file:///C:\File2.xlsx

If I save the workbooks after that and reopen them, the links are broken again.

What is causing this?

Jan 7 in Others by Kithuzzz
• 28,900 points
32 views

1 answer to this question.

0 votes
If not already done, save and close the workbooks, reduce the path (for example, rename a folder with a long name), open the workbooks again, fix any broken links, save, and you're done.
answered Jan 7 by narikkadan
• 53,520 points

Related Questions In Others

0 votes
1 answer

How to fix a circular reference error by if condition in excel file?

Circular reference in this context refers to ...READ MORE

answered Nov 21, 2022 in Others by narikkadan
• 53,520 points
92 views
0 votes
1 answer

How to save a new sheet in an existing excel file, using Pandas?

import pandas as pd import numpy as np path ...READ MORE

answered Dec 10, 2022 in Others by narikkadan
• 53,520 points
245 views
0 votes
1 answer

How to unmerge multiple cells and transpose each value into a new column in Pandas dataframe from excel file

Try this: df = pd.read_excel("Sample_File.xlsx", header=[0,1,2,3,4,5], index_col = ...READ MORE

answered Jan 8 in Others by narikkadan
• 53,520 points
122 views
0 votes
1 answer

Is it possible to get data from a webpage in real-time to an excel file?

The conventional method of obtaining data from ...READ MORE

answered Jan 17 in Others by narikkadan
• 53,520 points
45 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,630 points
215 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,630 points
395 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17, 2022 in Others by Edureka
• 13,630 points
177 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18, 2022 in Others by gaurav
• 22,960 points
165 views
0 votes
1 answer

How to use a named column in Excel formulas

Let's say I have the following figures ...READ MORE

answered Oct 24, 2022 in Others by narikkadan
• 53,520 points
100 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP