excel links misbehaviour

mdeponti

New Member
Joined
May 20, 2015
Messages
1
Hello all, I have a problem with excel links that is "somehow" similar to many others seen here; however not quite the same.
Here is the situation:
1- on Office 2013 I have a summary workbook which is liked to 2 other excel files
2- sometimes (not always) when I open the summary file, links are not updated , the edit links dialog box says "Error: source fot found". The only way to fix issue is to re-create links.
3- please note that: (a) files are in the right place with right name (b) files are neither read only not corrupted (c ) same behaviour if I open linked files (d ) all files are on a dropbox directory, but issue happens regardless i am connected to the network or not
4- till a few weeks ago I never saw such an issue but I cannot trace back any specific action that brought issue up.

Any suggestions?
Thanks!
mdeponti
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Forum statistics

Threads
1,223,249
Messages
6,171,031
Members
452,374
Latest member
keccles

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