Excel 2007 changes hyperlink path to local appdata

Discussion in 'Microsoft Office' started by tusharkalbhor, Dec 4, 2012.

  1. tusharkalbhor

    tusharkalbhor MDL Junior Member

    Jul 9, 2010
    67
    0
    0
    Hello..

    i have a large sheet with 200+ buttons which are actually paths to different network folders and files.
    today, suddenly, the worksheet refuses to open these folders/files when i click on corresponding link. when I checked, It shows local application data path of my profile for every single hyperlink directing to the various network directories and files.

    changing all hyperlinks manually will be a mess as 100 or so users have modified this sheet according to requirement and most dont even remember the original path as they are used to click on the shortcut in this sheet.

    Hyperlink shows: e:\documents and settings\<user name>\Application Data\Microsoft\Excel\QMS Documents\QMS Procedures\QA QMS ML 004 Masterlist of Procedures QMS.xls
    for a network file at:
    L:\QMS Documents\QMS Procedures\QA QMS ML 004 Masterlist of Procedures QMS.xls

    tried to find a solution but none was convincing.