Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to default links to RELATIVE reference
My Links between different Excel files are always absolute. Can I change them
to record relative. and 2) Can a change all the asolutes to relative at one time. Keep in mind that I am linking up to 30 files including some Word files. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to default links to RELATIVE reference
I don't believe you can change the default to relative cell references.
To change all at once from absolute to relative use this macro. Sub Relative() Dim cell As Range For Each cell In Selection If cell.HasFormula Then cell.Formula = Application.ConvertFormula _ (cell.Formula, xlA1, xlA1, xlRelative) Next End Sub Gord Dibben MS Excel MVP On Mon, 11 Sep 2006 13:47:01 -0700, David Diamond Del Vecchio <David Diamond Del wrote: My Links between different Excel files are always absolute. Can I change them to record relative. and 2) Can a change all the asolutes to relative at one time. Keep in mind that I am linking up to 30 files including some Word files. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
relative cell reference in custom validation | Excel Discussion (Misc queries) | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
Setting links to relative paths from ppt to xls | Links and Linking in Excel | |||
Creating Relative Links in Excel... | Excel Discussion (Misc queries) | |||
How do I keep formats (eg.color) when making a relative reference | Excel Discussion (Misc queries) |