how to change absolute path to relative path

H

hwijgerse

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
 

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

Incorporating the User Profile location into a document template path 1
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
How to create absolue path link to another workbook (Excel 2003) 1
Using 'indirect' function with full network path 0
How to create absolute link to cell in another workbook (Excel 2003) 1
Contatenate folder path strings, how ? 2
Worksheet relative reference 3
How do you assign a Workbook Location Path to a cell? 1

Top