External excel links not updating
For some reason, the workbook links aren't updating, when they should.This problem is intermittent, some times they work, sometimes they don't.To stop cells from automatically updating, copy them as values instead of linked cells.If you right click when pasting, you should see other options from just "paste".
I have: - checked and re-checked the links and know that they are pointing correctly between workbooks - Made sure I have calculated the workbooks - set automatic update of links on - checked links via Edit Links, check status and it says Source Is Open - even changed the source file to re-establish the links, then update values, and again status is Source Is Open But no joy.
But for the last few weeks the only way to get it to update is to copy and paste the formula, then reselect the "Spares order log.xlsm" file from a browse window. I click "Check Status" and it changes back to "Error: Source not found" One way to quickly fix it is to open the exact file it is referencing, using that exact UNC file path. Excel will treat them differently than the full UNC parameter.
the source status is set to unknown If I click "Update Values" I get the update values Dialogue box again Then the status changes to OK.
I have tried to disable all external access in the trust center with no luck.
How do I stop Excel from auto-updating those cells ?
Problem I have is that I want to roll these up into a master trend report. Click on the star if you think some-1 helped you Regards Ford The roll up report is only 'needed' once per month.