E
Eric
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
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