Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Xla file being referenced in the cell
When say user1 creates report and saves it to his local machine, the
functions refernceed in the cells are saved using an absolute address. Like cell B11, will be referenced as ='C:\Program Files\microsoft office\OFFICE11\xlstart\ConsolidationAddin.xla'!ge tValue($B$1,"DESCRIPTION","LINE_ITEMS",B16) If user1 sends this saved report workbook to another user2, whose excel installation is different from the original developer, The report cannot be used unless the absolute address is mass replaced on all the worksheets of the workbook as for this user the consolidation.xla files will be at different location. Can you please help inresolving this issue. Thanks, Sandeep |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Xla file being referenced in the cell
You could have the recipient use
Edit|Links|Change source To point at their location of the addin. To make life easier, you may want to tell everyone to use the same folder on the same drive (and the same filename). Include a note to all the recipients that they have to store the addin in: C:\SandeepUtils\ConsolidationAddin.xla Then they can use Tools|Addins to browse for this and install it. Sandeep wrote: When say user1 creates report and saves it to his local machine, the functions refernceed in the cells are saved using an absolute address. Like cell B11, will be referenced as ='C:\Program Files\microsoft office\OFFICE11\xlstart\ConsolidationAddin.xla'!ge tValue($B$1,"DESCRIPTION","LINE_ITEMS",B16) If user1 sends this saved report workbook to another user2, whose excel installation is different from the original developer, The report cannot be used unless the absolute address is mass replaced on all the worksheets of the workbook as for this user the consolidation.xla files will be at different location. Can you please help inresolving this issue. Thanks, Sandeep -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Xla file being referenced in the cell
How can we change the cell reference in each cell from
='C:\Program Files\microsoft office\OFFICE11\xlstart\ConsolidationAddin.xla'!ge tValue($B$1,"DESCRIPTION","LINE_ITEMS",B16) to =getValue($B$1,"DESCRIPTION","LINE_ITEMS",B16) programatcally? Can you please give me a sample code for this? thanks, Sandeep "Dave Peterson" wrote: You could have the recipient use Edit|Links|Change source To point at their location of the addin. To make life easier, you may want to tell everyone to use the same folder on the same drive (and the same filename). Include a note to all the recipients that they have to store the addin in: C:\SandeepUtils\ConsolidationAddin.xla Then they can use Tools|Addins to browse for this and install it. Sandeep wrote: When say user1 creates report and saves it to his local machine, the functions refernceed in the cells are saved using an absolute address. Like cell B11, will be referenced as ='C:\Program Files\microsoft office\OFFICE11\xlstart\ConsolidationAddin.xla'!ge tValue($B$1,"DESCRIPTION","LINE_ITEMS",B16) If user1 sends this saved report workbook to another user2, whose excel installation is different from the original developer, The report cannot be used unless the absolute address is mass replaced on all the worksheets of the workbook as for this user the consolidation.xla files will be at different location. Can you please help inresolving this issue. Thanks, Sandeep -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Xla file being referenced in the cell
Record a macro when you go through the Edit|Links|Change source and make sure
that the addin is in a folder that shares a common name for all the users. Sandeep wrote: How can we change the cell reference in each cell from ='C:\Program Files\microsoft office\OFFICE11\xlstart\ConsolidationAddin.xla'!ge tValue($B$1,"DESCRIPTION","LINE_ITEMS",B16) to =getValue($B$1,"DESCRIPTION","LINE_ITEMS",B16) programatcally? Can you please give me a sample code for this? thanks, Sandeep "Dave Peterson" wrote: You could have the recipient use Edit|Links|Change source To point at their location of the addin. To make life easier, you may want to tell everyone to use the same folder on the same drive (and the same filename). Include a note to all the recipients that they have to store the addin in: C:\SandeepUtils\ConsolidationAddin.xla Then they can use Tools|Addins to browse for this and install it. Sandeep wrote: When say user1 creates report and saves it to his local machine, the functions refernceed in the cells are saved using an absolute address. Like cell B11, will be referenced as ='C:\Program Files\microsoft office\OFFICE11\xlstart\ConsolidationAddin.xla'!ge tValue($B$1,"DESCRIPTION","LINE_ITEMS",B16) If user1 sends this saved report workbook to another user2, whose excel installation is different from the original developer, The report cannot be used unless the absolute address is mass replaced on all the worksheets of the workbook as for this user the consolidation.xla files will be at different location. Can you please help inresolving this issue. Thanks, Sandeep -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The absolute referenced cell does not move when source cell moves | Excel Worksheet Functions | |||
Links error if referenced file not opened | Excel Worksheet Functions | |||
See where a cell is referenced | New Users to Excel | |||
How do I double click a cell and jump to cell's referenced cell | Excel Discussion (Misc queries) | |||
Missing linked file - can still be referenced but can't find it! | Excel Worksheet Functions |