I tried that, but the links are still active.
Plus bonus points for use of the word 'mosey'.
Oz ,'Same Time, Same Place'
Buffistechnology 2: You Made Her So She Growls?
Got a question about technology? Ask it here. Discussion of hardware, software, TiVos, multi-region DVDs, Windows, Macs, LINUX, hand-helds, iPods, anything tech related. Better than any helpdesk!
Jessica - Nov 07, 2005 12:06:02 pm PST #5485 of 10003
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset
Kristen - Nov 07, 2005 12:19:33 pm PST #5486 of 10003
Have you tried copying it all to a blank worksheet? (As values only.)
Jessica - Nov 07, 2005 12:20:41 pm PST #5487 of 10003
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset
I gave up and left them linky. They're not sorted the way I'd ideally like, but I can deal. (Really, all I need this for is a list of things to cross off to make sure all these clips ended up on the reel.)
Kristen - Nov 07, 2005 12:31:29 pm PST #5488 of 10003
It's so strange. I can't figure out why it wouldn't work on your computer.
Excel is just weird.
le nubian - Nov 07, 2005 12:49:16 pm PST #5489 of 10003
"And to be clear, I am the hell. And the high water."
Jessica,
copy them, then do Paste Special, then select "text"
You might have to go back and convert the column to numbers. If you don't know how to do that, post back here.
Jessica - Nov 07, 2005 3:03:06 pm PST #5490 of 10003
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset
It's so strange. I can't figure out why it wouldn't work on your computer
I'm guessing we have different versions. My office is...not so good about the updating of things.
(I'd tell you what the version was, except I'm at home now.)
LeN, the problem was that when I selected more than one cell, the "text" option was replaced by a bunch of other things (like "values" "formatting" and suchlike. "Values" seemed the obvious choice, but it didn't change a thing.)
le nubian - Nov 07, 2005 3:04:37 pm PST #5491 of 10003
"And to be clear, I am the hell. And the high water."
erg. that's frustrating.
Eddie - Nov 07, 2005 5:38:51 pm PST #5492 of 10003
Your tag here.
Just to follow up a bit on the instructions given in the above link:
1. After entering the code, select File > "Close and Return to Microsoft Excel" (or press Alt-Q)
2. Select Tools > Macro Macros... (or press Alt-F8)
3. Select ZapHyperlinks, press Run
Your hyperlinks should disappear. Note: this will nuke all hyperlinks in the workbook.
Jessica - Nov 08, 2005 5:42:26 am PST #5493 of 10003
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset
Is there a Firefox extension that adds "Save target as/Download linked file" to a right-click menu? I remember finding one once, but that I need it, I can't find it on the Extensions site.
tommyrot - Nov 08, 2005 5:43:46 am PST #5494 of 10003
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.