Hi I have two spreadsheets where I link information from one to the other. Each time I open I see the prompt to ''Update Links'' which I click and all is updated. Now I am starting not to see this prompt and the information is not being updated

When I do see the prompt it also now advises that Link needs updating although file has not moved -this I do but again no update

Any help greatly appreciated and also on how to see where links are