| View previous topic :: View next topic |
| Author |
Message |
BMAN99
General User
Joined: 02 Jan 2008
Posts: 17
|
 Posted: Thu May 29, 2008 2:50 pm Post subject: Can you link to a specific sheet in a different Calc file? |
 |
|
Hello...
Was wondering if it's possible to hyperlink to a specific sheet in a *different* Calc file? I see that you can link to a specific sheet within the same file, but not in a different one.
Any clue if this is possible?
Thanks! |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Thu May 29, 2008 3:30 pm Post subject: |
|
|
=HYPERLINK("file://path/name.ods#SheetX.A1";"Push Me")
or Menu:Insert>Hyperlink...
specify the path and the address or range name as target in document.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
BMAN99
General User
Joined: 02 Jan 2008
Posts: 17
|
| Posted: Thu May 29, 2008 5:31 pm Post subject: |
|
|
Villeroy,
Thanks for the tip! Works a charm  |
|
| Back to top |
|
|
|
