I have a spreadsheet ("A") that contains values that are updated from (linked to) another spreadsheet ("B") entirely. "B" is overwritten daily with new values, and within the sheet, I'm totalling those values; "A" is populated with (linked to) these calculated totals. However, when I open "A" after "B" is updated, I'm prompted to update my links as expected, but when I click "Update," it won't because it's says "'B' hasn't been re-calcuated;" I have to simply open and save "B" in order for "A" to update accordingly. Is there a way around this?