Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Updating Absolute References
Is it possible to do a global update to all absolute references? I have a
large worksheet that links to another and it must be updated each month to change the link and move it one cell below, i. e. from say A23 to A24. I want to be able to do this at one time rather than changing each link individually. -- Allan |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Updating Absolute References
Maybe yes.
If you used Ctrl+K, or Insert Hyperlink for your links, you're probably out of luck with regard to changing specific cell callouts. (FYI, you can edit the workbook source(s) using Edit-links) If you used the HYPERLINK formula, then its a simple matter of using Find & Replace. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Flipper" wrote: Is it possible to do a global update to all absolute references? I have a large worksheet that links to another and it must be updated each month to change the link and move it one cell below, i. e. from say A23 to A24. I want to be able to do this at one time rather than changing each link individually. -- Allan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert relative cell references to absolute cell references via amacro? | Excel Discussion (Misc queries) | |||
Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
Absolute References | Excel Discussion (Misc queries) | |||
Absolute References | Excel Worksheet Functions | |||
Turn off Absolute references | Excel Discussion (Misc queries) |