Results 1 to 7 of 7
  1. #1
    Lounger
    Join Date
    Nov 2001
    Location
    Fort Dodge, Iowa, USA
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    The address of this site is not valid. (MS Excel 2002 SP3)

    I've an Excel file listing software available to install and where it is located; for those programs already on an installation server, I've got a link to its setup program. This sheet, which is currently in its own file, used to be part of another workbook. Nothing in it references cells anywhere else, but I've seen Excel do strange things and just being on its own, when it used to be in a larger workbook, _may_ be messing something up; I'm a big believer in providing all possibly helpful information to solve a problem. Regardless of where, in the plant, or what make, model, and type of workstation from which I accessed the 'Install-from locations' sheet, it worked perfectly.
    Until I split it off onto it's own sheet.
    My contract here is about up and I'm trying to get some logical organization to the files that I created to do this job; the 'Install-from locations' sheet just didn't fit with the rest of the workbook of which it was a part. In fact, it didn't fit with any other reference or file that I had created in Excel so I MOVEd the sheet to a NEW WORKBOOK, and saved that workbook - containing _only_ the 'Install-from locations' sheet - to an appropriate location on the network. Now the sheet is broken, but predictably so...I'll explain.
    Now, the first time I run it on a workstation to install software - say, for example, Reflections & MS Project 98 - I click on each link and get a message popup saying, "The address of this site is not valid. Check the address and try again." In other words, Excel _does_ know that it is _supposed_ to be a link. If I tap [F2] to edit the cell and then press [ENTER], I can immediately click on that same link and it will now work. If I exit, saving changes, Excel remembers - on that workstation - that those links I [F2]-[ENTER]'ed work but only on that workstation. I go to the next workstation, where I haven't accessed the 'Install-from locations' sheet before, and the links are suddenly broken again.
    (Meh?! What the...?!) says I.
    The final puzzle pieces - don't know if they'll help - is that I have group-based Admin privileges on all machines here and we are running our network with Active Directory.
    Please help...I don't want to leave the poor schmuck who has to do this next hanging. Thanks much.

    BTW: for security reasons, I can't post the file itself.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: The address of this site is not valid. (MS Excel 2002 SP3)

    Just a shot in the dark - did the original workbook have a Hyperlink Base set in File | Properties?

  3. #3
    Lounger
    Join Date
    Nov 2001
    Location
    Fort Dodge, Iowa, USA
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: The address of this site is not valid. (MS Excel 2002 SP3)

    Just checked...
    Nope, no Hyperlink Base set in the File properties. on the original workbook, nor in the workbook in which the 'Install-from Locations' sheet currently occupies. BTW: I can share this much and still be security-conscious: the link format is [SERVERsoftwareInstall from hereCamediaSetup.exe]

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: The address of this site is not valid. (MS Excel 2002 SP3)

    What happens if you move (a copy of) the new workbook with only the 'Install-from locations' sheet to the same folder where the original workbook resides? Do the hyperlinks work then?

  5. #5
    Lounger
    Join Date
    Nov 2001
    Location
    Fort Dodge, Iowa, USA
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: The address of this site is not valid. (MS Excel 2002 SP3)

    Hmmm...hadn't thought of that.
    Nope, same result: the ones that I had already [F2]-[ENTER]ed on this workstation still work, those I hadn't still don't. I also just tried Copy & Pasting the contents of the sheet, as values, into a new, fresh workbook and then [F2]-[ENTER]ing each link to activate it. I saved it and had it tested...didn't work.
    Sorry.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: The address of this site is not valid. (MS Excel 2002 SP3)

    What do you see if you right-click one of the broken hyperlinks and select Edit Hyperlink... from the popup menu? Does the Address box near the bottom of the dialog give you a clue?

  7. #7
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: The address of this site is not valid. (MS Exc

    Two completely different suggestions:<UL><LI>Try saving the problem file into HTML format and then re-saving back into XLS format. *IF* this is a corruption issue, that _may_ cure it.<LI>Try setting up the addresses as links to mapped network drives and mapping the netwrok drives on the test workstation. If this latter stepo provides a cure then it should be possible to recreate the network drive mapping as part of a network log-on script.[/list]HTH
    Gre

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •