Hi,

Set the base address for the hyperlinks in a workbook


By default, unspecified paths to hyperlink (hyperlink: Colored and
underlined text or a graphic that you click to go to a file, a location in a
file, a Web page on the World Wide Web, or a Web page on an intranet.
Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.)
destination files are relative to the location of the active workbook. Use
this procedure when you want to set a different default path.

Each time you create a hyperlink to a file in that location, you'll only
have to specify the file name, not the path, in the Insert Hyperlink dialog
box.

1. On the File menu, click Properties.
2. Click the Summary tab.
3. In the Hyperlink base box, type the path you want to use.

Note You can override the hyperlink base address by using the full, or
absolute, address for the hyperlink in the Insert Hyperlink dialog box.

Challa Prabhu

"Sandeep" wrote:

When say user1 develops the report and saves, the
functions are saved to the xla file using an absolute address.


The directory depends on where the excel is installed. Below is an example
of a function saved.


='C:\Program Files\microsoft
office\OFFICE11\xlstart\ConsolidationAddin.xla'!ge tValue($B$1,"DESCRIPTION","LINE_ITEMS",B16)



If user1 sends this report workbook to another report developer, user2 whose
excel installation is different from the original developer, The report
cannot used unless the absolute address is mass replaced on all the
worksheets of the workbook.



For this to work we need to select each sheet in the workbook and then
remove the 'C:\Program Files\microsoft
office\OFFICE11\xlstart\ConsolidationAddin.xla' from all the functions for
each cell.



Can any one please help me to resolve this issue.



We want that when the user saves the report, it must be saved with the
relativbe address i.e only the function name
'getValue($B$1,"DESCRIPTION","LINE_ITEMS",B16)' i.e. instead of storing the
complete address in each cell.



thanks,

sandeep