Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 loses the links to other excel spreadsheets on a server | Excel Discussion (Misc queries) | |||
Why does my Excel workbook take so long to update links? | Excel Discussion (Misc queries) | |||
Upgrade from Excel 97 to 2003 | Excel Discussion (Misc queries) | |||
Excel 97 to Excel XP upgrade issue | Excel Discussion (Misc queries) | |||
upgrade to excel 2003 update broken links error | Links and Linking in Excel |