dfghjk
Apr 25, 2007, 12:15 PM
Hi out there!
I'm new in this help desk, and can't find any thread for MS Excel formulas, but hope anyway to find some expert in this subject even if it's not traditional programming.
Now to my problem.
I have two workbooks, Workbook wbA.xls that has source information, and the other workbook wbB.xls that have cellreferences to get information from wbA.xls.
The cell references in wbB.xls is a range with formula that is normaly like this:
{='[wbA.xls]Sheet A'!$E$6:$F$11}
wbA.xls is located in: C:\Folder1\folder2
wbB.xls is located in: C:\Folder1\Templates\TemplateType1\
Then I have two different configurations in Excel.
1: This configuration must some users have, but it do not work.
The setting in Excel:
"Tools>Options>Regular>At start open all files in:" is empty, so no files I fourced to start at startup of MS Excel (hope u understand the translation from swedish).
Then, when I start MS Excel, open wbA.xls, and then from a button in worksheet in wbA.xls I open wbB with VBA-macro, and then the links looks like this:
{='C:\Documents and Settings\larzet01\Application Data\Microsoft\Excel\XLStart\[wvA.xls]Sheet A'!$E$6:$F$11}
And this links do not work, as the source workbook wbA is not located in the XLStart folder.
2: But if I configure the "Tools>Options>Regular>At start open all files in:" option to start wbA.xls by setting the open-option to "c:\folder1\folder2\wbA.xls", and then use exactly the same button and the same VBA-macro to open wbB.xls, it works perfectly!
The original cell references are there and works perfect.
Now to my q.
Depending on how I open wbA.xls is the links broken when I open wbB.xls from wbA.xls.
Can anyone tell my why this happened?
And how do I avoid this damage of cell references when I open wbA.xls manually, and then use the button to open wbB.xls?
I'm using Windows XP, and MS Excel 2003.
Hope I have make myself understood with this problem, and will be very happy for a solution!
Regards
dfghjk
I'm new in this help desk, and can't find any thread for MS Excel formulas, but hope anyway to find some expert in this subject even if it's not traditional programming.
Now to my problem.
I have two workbooks, Workbook wbA.xls that has source information, and the other workbook wbB.xls that have cellreferences to get information from wbA.xls.
The cell references in wbB.xls is a range with formula that is normaly like this:
{='[wbA.xls]Sheet A'!$E$6:$F$11}
wbA.xls is located in: C:\Folder1\folder2
wbB.xls is located in: C:\Folder1\Templates\TemplateType1\
Then I have two different configurations in Excel.
1: This configuration must some users have, but it do not work.
The setting in Excel:
"Tools>Options>Regular>At start open all files in:" is empty, so no files I fourced to start at startup of MS Excel (hope u understand the translation from swedish).
Then, when I start MS Excel, open wbA.xls, and then from a button in worksheet in wbA.xls I open wbB with VBA-macro, and then the links looks like this:
{='C:\Documents and Settings\larzet01\Application Data\Microsoft\Excel\XLStart\[wvA.xls]Sheet A'!$E$6:$F$11}
And this links do not work, as the source workbook wbA is not located in the XLStart folder.
2: But if I configure the "Tools>Options>Regular>At start open all files in:" option to start wbA.xls by setting the open-option to "c:\folder1\folder2\wbA.xls", and then use exactly the same button and the same VBA-macro to open wbB.xls, it works perfectly!
The original cell references are there and works perfect.
Now to my q.
Depending on how I open wbA.xls is the links broken when I open wbB.xls from wbA.xls.
Can anyone tell my why this happened?
And how do I avoid this damage of cell references when I open wbA.xls manually, and then use the button to open wbB.xls?
I'm using Windows XP, and MS Excel 2003.
Hope I have make myself understood with this problem, and will be very happy for a solution!
Regards
dfghjk