How to update all worksheets before re-calculation?

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

There are 5 worksheets with links to internet site, whenever I open this
worksheets, which will automatically update the links for all worksheets.
After one link is updated, it will re-calculate all worksheet before
updating the second link. Would it be possible that all worksheets will be
re-calculated only after all links are updated.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric
 
Hi,
Set the calculation to manual, and in the last link update you can add the
line to calculate the spreadsheet
 
Back
Top