Links

M

Mike Milmoe

When you update links, does that update all worksheets in a workbook, or just
the active one?
 
J

JBeaucaire

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?
 
M

Mike Milmoe

Great. Thanks you!

JBeaucaire said:
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?
Click to expand...
 

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

Update links 1
Update links (repost) 2
Where are the links to other data sources? 1
Trace links between worksheets within one workbook 4
cancel Update message? 2
How to update all worksheets before re-calculation? 1
Nexus 7 Update 3
Links 2

Top