| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to update all worksheets before re-calculation?
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to update all worksheets before re-calculation?
Hi,
Set the calculation to manual, and in the last link update you can add the line to calculate the spreadsheet "Eric" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto update worksheets | Excel Worksheet Functions | |||
| Automatically update worksheets | Excel Discussion (Misc queries) | |||
| Formulas across worksheets do not update | Excel Worksheet Functions | |||
| Update multiple worksheets | Excel Discussion (Misc queries) | |||
| Update another worksheets | Excel Worksheet Functions | |||
Linear Mode
