Source not found in an Excel workbook Solved

Question

Good evening everyone,

Don't laugh Ericcccccc,

I have a little problem when I try to open an Excel workbook.

Apart from being asked if I want to enable my macros or not, I am prompted to update because my workbook contains links to other workbooks.

Of course, I want to update, and that's when the message appears: "this workbook contains one or more links that cannot be updated." I click on "continue," the file opens, and if I click on "edit links," I see a window where I actually find a reference to a workbook that is incorrect.

I've searched through my formulas grrrrrrrrrrr I have plenty of sheets but I can't find this workbook.

How can I find out which sheet in my workbook is hiding this missing source?

Thank you for your help.

Have a good evening.

Configuration: Windows XP Internet Explorer 7.0

eriiic · Accepted Answer

Hi,

Sometimes Excel has a bit of a bug at this level.
If you're sure you've checked everything, you can try this:
Note the path and the name of the file you have links to.
Save your file in that directory with the name of the other file, take a quick look in the 'edit / links...' menu to see if it's still active.
Then save it back in its usual location with its real name.

Good night
Eric

Le Pingou · Answer

Good evening,
You say this:
"...click on "edit links" I have a window where I can indeed see a reference to a workbook that is not correct..."
Since you have the name of the workbook, you should search for it in your "My Documents" directory to
find the correct path of the workbook, indicate the correct path and that's it.
--

Best regards.
Jean-Pierre

eriiic · Answer

Good evening again,  well, what are you doing here? ;-) Take a look at your balance sheet; there are some formulas to correct in Z12:AA22  Alright, time for bed... :-)

debutante-excel · Answer

Hello Pingou, Re eriiiiccccc,

yes, I know there are typos in the formulas in d_bilan, always an eye lurking Eriiiccccccccccc lollll.

but in this case, the problem doesn't come from there.

Pingou, I apologize but I don't understand at all what you’re telling me, okay I’m a beginner, but come on lolllllll.

or maybe I don’t understand anything anymore, but it’s in my Excel workbook that I’m referencing a link (wrong Excel workbook name) and I'm asking how to find where I reference this workbook in my workbook.

maybe I was clearer this time.

have a nice day everyone.

eriiic · Answer

Hello everyone,

The problem may not come ONLY from that, but it contributes to it.
There might be other sheets with the same error.
Search your #REF sheet. You will find several cells with #REF.
Some may not interest you, others will.
Look at the formula of each cell; if it's correct, it means it inherited the error, so you leave it. This means that in your formula you are referring to one (or more) erroneous cells.
If you have something like =SUM(#REF!T13), it means you are referring to another workbook that has been deleted or moved.
You correct the formula or recreate/move your missing workbook.
And you continue as long as you have #REF.

Good luck... :-)
eric

debutante-excel · Answer

Hello everyone,  It's all good, I found it, a big thank you to Ericcccccccccccc and Pingou for their valuable help.  Problem solved.  See you+++++++++++

debutante-excel · Answer

Hi there,,,,,,,,,,

Well, this is a never-ending problem.

So I still have the issue with links, grrrrrrrrrrrrrr.

I still have faulty links in my workbook

when I open my workbook I get

this workbook contains one or more links that cannot be updated.

If I click on edit links

I can see a workbook name that doesn't belong here

no matter how much I click on break links for this workbook it doesn't change anything.

in my sheets I don't have #REF I've searched for this workbook name in my workbook and found nothing

pfffffffffffffff it's so annoyinggggggggggggggg right now

thank you for your help.

See you++++++++++++++++++++++++

debutante-excel · Answer

ericccccccccccccccccccccccc,

you are a deiiiiiine

it works heeeeeeeeeeeeeeeeeee

where did you find such a thinggggggggggggggg lollllllllllllllllllllll

I did the manipulatioooooooooooon and it worksssssssssssssssssssss

thanks a million to youuuuuuuuuuuuuuuuuu

alright, I'm off under the covers too

I had a great day thanks to all of you

thank you allssssssssssssssssssss

see ya++++++++++++++++++++++++

eriiic · Answer

Hello beginner, I assure you, it's not from me... :-) The advantage of this site is that we learn just as much as we help. Have a good day Eric

Source not found in an Excel workbook

9 answers

Color of visited links in firefox 153

How to tell if i can upgrade the ram on my pc?

Windows security

E.tre456.worm.windows

Broken logitech g915 keyboard key (original part)

Computer stuck at boot menu on startup page

Texture issues in enshrouded

Printer uninstalled

Pc audio connection: jack ports, hi-fi chain

Recording and reading issue for jpg files