Link from which cell?!?

charlie92_uk

New Member
Joined
Jan 11, 2012
Messages
31
Hi everybody!
I've got this problem (excel 2010): when I open a file, I've got the error message that I've a broken link: it cannot update the data from a certain file. It tells me from which file it cannot download the data (also seen in "Edit Links") but it does not say which is the cell that contains the formula where is the wrong file address!

In many cases, I just want to delete the link because I copied and pasted a formula from another file and the references are linked to the old file. There is the option in the Edit Links to break the link, but before that I would like to check the cell if I want there a value or an updated formula...

I usually visualise formulas instead of results in the cells to help me finding the bloody cell, but sometimes I've got very large files...

Any ideas?
thanks a lot
Carlo
 

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top