How to update all worksheets before re-calculation?

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
 
E

Eduardo

Hi,
Set the calculation to manual, and in the last link update you can add the
line to calculate the spreadsheet
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to update all links before re-calculation for macro? 1
How to enable / disable re-calculation option? 5
How to disable the pop up for enable auto update? 2
How to skip the enable update confirmation? 0
take all data from several worksheets to one main worksheet? 0
Require formula to search across multiple worksheets 2
Why macro cannot refreshall? 7
HELP - the file links cannot be updated! 0

Top