Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update links
Is there a way to update all of the links in a sheet automatically? I have a
sheet I copy into a workbook and need to update the sheet links with several other sheets in the book. The workbook will not have the same number of sheets everytime so a macro won't work. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update links
I think this is what you need. Under TOOLS OPTIONS "Edit" tab and uncheck
the "Ask to update automatic links". This should update automatically without asking. -- "Actually, I AM a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "wcurtis" wrote: Is there a way to update all of the links in a sheet automatically? I have a sheet I copy into a workbook and need to update the sheet links with several other sheets in the book. The workbook will not have the same number of sheets everytime so a macro won't work. |
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) | |||
How do you update links | Excel Worksheet Functions | |||
keep value from last update and don't ask to update links | Excel Discussion (Misc queries) | |||
update links | Excel Discussion (Misc queries) | |||
can't update links...can't find links | Excel Discussion (Misc queries) |