| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to change absolute path to relative path
I have two different workbooks. Some cells in workbook 1 are using cells from workbook 2. These cells use the absolute path of workbook 2. When I copy these files to another computer I have to create the exact same path otherwise it will not work. Can I make relative path in my workbooks so it will work on any computer ? Henry -- hwijgerse ------------------------------------------------------------------------ hwijgerse's Profile: http://www.excelforum.com/member.php...o&userid=29083 View this thread: http://www.excelforum.com/showthread...hreadid=488091 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| changing multiple cells from relative to absolute reference | Excel Discussion (Misc queries) | |||
| change directory for refresh data | Excel Discussion (Misc queries) | |||
| How to change the Excel Title Bar to show the full file path na... | Excel Discussion (Misc queries) | |||
| Change Path names in copied work book | Excel Worksheet Functions | |||
| How do I change an Excel range of cells from relative to absolute. | Excel Worksheet Functions | |||
Linear Mode
