| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Am I on the right path | Excel Discussion (Misc queries) | |||
| Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
| hyperlink navigation path path wrong in Excel 2003 | Excel Discussion (Misc queries) | |||
| how to change absolute path to relative path | Excel Worksheet Functions | |||
| How to retrieve orignial file excel that is renamed | Excel Worksheet Functions | |||
Linear Mode
