Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlink to cells in other workbooks keep changing
We are using Excel 2007 SP1. I am working with an Excel file (.xlsm, it
contains macros) that links to cells in another workbook that is in 2003 format. The master .xlsm workbook creates a new .xlsm file each week (manually started via a button). I don't think this is important, just sharing the information. After the workbook is created, the cells look like this: ='\\server\folder\[workbook.xls]Tab Name'!A1 HOWEVER, after the new workbook is closed and reopened, the hyperlinks change and look like this: ='local drive\folder\[workbook.xls]Tab name'!A1 We do NOT want the link to update to the local drive. I made the "Update Links on Save" setting so that the box is un-checked, but either way it is set, the link changes. This is happening for multiple people. I thought maybe it was a problem with .xlsm files or something.....but i can't seem to find anything related to issues with this functionality in Office 2007. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlink to cells in other workbooks keep changing
A few people have said that this has stopped a similar problem from occurring.
Maybe it'll help you--but you'll have to test it to make sure. In xl2003 menus: File|Properties|Summary Tab|Hyperlink Base change it to C:\ (something that's always available) In xl2007: Click on the Office button Choose Prepare, then properties. Then use the arrow on the Document Properties dropdown Choose Advanced Properties And then change the hyperlink base on the Summary tab. I like to use the =hyperlink() worksheet function. It has never failed me this way: =hyperlink("file:////yourpathtothe/something.xxx","Click me") GHawkins wrote: We are using Excel 2007 SP1. I am working with an Excel file (.xlsm, it contains macros) that links to cells in another workbook that is in 2003 format. The master .xlsm workbook creates a new .xlsm file each week (manually started via a button). I don't think this is important, just sharing the information. After the workbook is created, the cells look like this: ='\\server\folder\[workbook.xls]Tab Name'!A1 HOWEVER, after the new workbook is closed and reopened, the hyperlinks change and look like this: ='local drive\folder\[workbook.xls]Tab name'!A1 We do NOT want the link to update to the local drive. I made the "Update Links on Save" setting so that the box is un-checked, but either way it is set, the link changes. This is happening for multiple people. I thought maybe it was a problem with .xlsm files or something.....but i can't seem to find anything related to issues with this functionality in Office 2007. -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlink to cells in other workbooks keep changing
Is this an Excel application setting or is it something that is
workbook-specific? "Dave Peterson" wrote: A few people have said that this has stopped a similar problem from occurring. Maybe it'll help you--but you'll have to test it to make sure. In xl2003 menus: File|Properties|Summary Tab|Hyperlink Base change it to C:\ (something that's always available) In xl2007: Click on the Office button Choose Prepare, then properties. Then use the arrow on the Document Properties dropdown Choose Advanced Properties And then change the hyperlink base on the Summary tab. I like to use the =hyperlink() worksheet function. It has never failed me this way: =hyperlink("file:////yourpathtothe/something.xxx","Click me") GHawkins wrote: We are using Excel 2007 SP1. I am working with an Excel file (.xlsm, it contains macros) that links to cells in another workbook that is in 2003 format. The master .xlsm workbook creates a new .xlsm file each week (manually started via a button). I don't think this is important, just sharing the information. After the workbook is created, the cells look like this: ='\\server\folder\[workbook.xls]Tab Name'!A1 HOWEVER, after the new workbook is closed and reopened, the hyperlinks change and look like this: ='local drive\folder\[workbook.xls]Tab name'!A1 We do NOT want the link to update to the local drive. I made the "Update Links on Save" setting so that the box is un-checked, but either way it is set, the link changes. This is happening for multiple people. I thought maybe it was a problem with .xlsm files or something.....but i can't seem to find anything related to issues with this functionality in Office 2007. -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlink to cells in other workbooks keep changing
The hyperlink base is workbook property.
Using the worksheet function =hyperlink() may be a nice alternative (but I've said that already). GHawkins wrote: Is this an Excel application setting or is it something that is workbook-specific? "Dave Peterson" wrote: A few people have said that this has stopped a similar problem from occurring. Maybe it'll help you--but you'll have to test it to make sure. In xl2003 menus: File|Properties|Summary Tab|Hyperlink Base change it to C:\ (something that's always available) In xl2007: Click on the Office button Choose Prepare, then properties. Then use the arrow on the Document Properties dropdown Choose Advanced Properties And then change the hyperlink base on the Summary tab. I like to use the =hyperlink() worksheet function. It has never failed me this way: =hyperlink("file:////yourpathtothe/something.xxx","Click me") GHawkins wrote: We are using Excel 2007 SP1. I am working with an Excel file (.xlsm, it contains macros) that links to cells in another workbook that is in 2003 format. The master .xlsm workbook creates a new .xlsm file each week (manually started via a button). I don't think this is important, just sharing the information. After the workbook is created, the cells look like this: ='\\server\folder\[workbook.xls]Tab Name'!A1 HOWEVER, after the new workbook is closed and reopened, the hyperlinks change and look like this: ='local drive\folder\[workbook.xls]Tab name'!A1 We do NOT want the link to update to the local drive. I made the "Update Links on Save" setting so that the box is un-checked, but either way it is set, the link changes. This is happening for multiple people. I thought maybe it was a problem with .xlsm files or something.....but i can't seem to find anything related to issues with this functionality in Office 2007. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hyperlink cells between workbooks | Excel Worksheet Functions | |||
Changing source on multiple workbooks | Links and Linking in Excel | |||
Excel Changing hyperlink | Excel Discussion (Misc queries) | |||
Changing hyperlink defaults | Excel Discussion (Misc queries) | |||
Hyperlink changing row | Excel Worksheet Functions |