| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links
When you update links, does that update all worksheets in a workbook, or just
the active one? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Links
Yes, it updates all the links, if you do it when the book opens or you click
the UPDATE LINKS option in the EDIT LINKS window. If you connect values in a cell to a cell from another sheet using a FORMULA instead of a link, then those links may update constantly and individually as the remote sheet is update...unless you've set the sheet to manual calculation. In that case you would have to press F9 to get those formulaic links to update. Does that cover your question? -- "Actually, I AM a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "Mike Milmoe" wrote: When you update links, does that update all worksheets in a workbook, or just the active one? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Links
Great. Thanks you!
"JBeaucaire" wrote: Yes, it updates all the links, if you do it when the book opens or you click the UPDATE LINKS option in the EDIT LINKS window. If you connect values in a cell to a cell from another sheet using a FORMULA instead of a link, then those links may update constantly and individually as the remote sheet is update...unless you've set the sheet to manual calculation. In that case you would have to press F9 to get those formulaic links to update. Does that cover your question? -- "Actually, I AM a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "Mike Milmoe" wrote: When you update links, does that update all worksheets in a workbook, or just the active one? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
| Edit Links: Changing links on a protected worksheet | Excel Discussion (Misc queries) | |||
| Links: Re-establishing Links | Excel Discussion (Misc queries) | |||
| EXCEL - LINKS cannot easily get list of all links & names in book | Excel Worksheet Functions | |||
| can't update links...can't find links | Excel Discussion (Misc queries) | |||
Linear Mode
