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