ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Links in Excel not good anymore after upgrade (https://www.excelbanter.com/excel-worksheet-functions/114726-links-excel-not-good-anymore-after-upgrade.html)

V&B

Links in Excel not good anymore after upgrade
 
After upgrading from Office 97 to Office 2003, the links in Excel workbooks
to other workbooks are not correct anymore.
Where there used to be a link to the workbook on a network drive (for
example H:\Excel\document.xls) the link now replaces H: with C:\Documents and
Setiings\%Username%\Application Data\.......
Even after restoring the links manually, the next day on opening the
workbook, the links are not correct again.

JLatham

Links in Excel not good anymore after upgrade
 
Try setting the links using 'My Network Places' rather than 'My Computer'
This eliminates problems with drive mapping for anyone using the workbook.
Be sure to save workbook after updating the links.

"V&B" wrote:

After upgrading from Office 97 to Office 2003, the links in Excel workbooks
to other workbooks are not correct anymore.
Where there used to be a link to the workbook on a network drive (for
example H:\Excel\document.xls) the link now replaces H: with C:\Documents and
Setiings\%Username%\Application Data\.......
Even after restoring the links manually, the next day on opening the
workbook, the links are not correct again.



All times are GMT +1. The time now is 06:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com