I have a spreadsheet with links to another. When the links are refreshed all
the cells are updated but those in row 12 need information in row 17 and the
value in row 12 comes out errors. I am told this is because Excel calculates
from the top down so the information in row 17 is not available yet when row
12 is calculating. Can't I just press F9 to calculate and make it all work
(or does this start the process all over again)?
Thanks