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

Topic

New Reply

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.

Reply | Quote

Replies

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

Reply | Quote

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]

Reply | Quote

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?

Reply | Quote

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.

Reply | Quote

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?

Reply | Quote

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?

Reply | Quote

Two completely different suggestions:

• 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.
• 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

Reply | Quote

Two completely different suggestions:

• 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.
• 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

Reply | Quote

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.

Reply | Quote

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?

Reply | Quote

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]

Reply | Quote

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

Reply | Quote