How to keep the orignial path?
 

Does anyone have any suggestions on how to fix the path under different
directory?
This file sheet.xls is saved under following the paths
E:\Homework\class1\
E:\Homework\class2\
E:\Homework\class3\

Within the E:\Homework\class1\summary.xls - Temp sheet - cell A1, there is
a value retrieved from 'E:\Homework\class1\[sheet.xls]D'!$H$2.

When I copy this summary.xls file into following directory
E:\Homework\class2\

Under directory E:\Homework\class2\, the path E:\Homework\class1\summary.xls
- Temp sheet - cell A1 change into
'E:\Homework\class2\[sheet.xls]D'!$H$2, but I would like to keep the
original path
E:\Homework\class1\summary.xls - Temp sheet - cell A1.

Does anyone have any suggestions on how to do it in Excel?
Thanks in advance for any suggestions
Eric

How to keep the orignial path?
 

Hi Eric,
Not clear to me.
Looks like your linking to workbooks that are named the same but in different folders.
Excel won't allow open workbooks with the same name regardless of the path.

John


"Eric" wrote in message ...
Does anyone have any suggestions on how to fix the path under different
directory?
This file sheet.xls is saved under following the paths
E:\Homework\class1\
E:\Homework\class2\
E:\Homework\class3\

Within the E:\Homework\class1\summary.xls - Temp sheet - cell A1, there is
a value retrieved from 'E:\Homework\class1\[sheet.xls]D'!$H$2.

When I copy this summary.xls file into following directory
E:\Homework\class2\

Under directory E:\Homework\class2\, the path E:\Homework\class1\summary.xls
- Temp sheet - cell A1 change into
'E:\Homework\class2\[sheet.xls]D'!$H$2, but I would like to keep the
original path
E:\Homework\class1\summary.xls - Temp sheet - cell A1.

Does anyone have any suggestions on how to do it in Excel?
Thanks in advance for any suggestions
Eric