Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Excel & Hyperlinks


  • Please log in to reply

#1
luftdrachen

luftdrachen

    New Member

  • Member
  • Pip
  • 2 posts
I have a spreadsheet in excel 2007 that keeps resetting the hyperlinks. Every time I change them they get reset as soon as I change sheets in my workbook. Any help would be appreciated.
  • 0

Advertisements


#2
dm27

dm27

    Member

  • Member
  • PipPipPip
  • 272 posts
Hello luftdrachen,

Welcome to Geeks to Go :)

Could you describe what you mean whey you change a hyperlink and what happens to the hyperlink when it "resets?"

Sincerely,


dm
  • 0

#3
luftdrachen

luftdrachen

    New Member

  • Topic Starter
  • Member
  • Pip
  • 2 posts

Hello luftdrachen,

Welcome to Geeks to Go :)

Could you describe what you mean whey you change a hyperlink and what happens to the hyperlink when it "resets?"

Sincerely,


dm



Certainly I have entered in hyperlinks they have become pointed to an incorrect location. I go through change them to the correct location, when I change sheets and change back again the hyperlinks have gone back to the incorrect location
  • 0

#4
dm27

dm27

    Member

  • Member
  • PipPipPip
  • 272 posts
Thanks for the information... A couple of additional questions if you don't mind:

  • So these links point to files on your computer (or network) or actual websites?
  • Are you the only user of the spreadsheet or do others have access to it?
Best regards,


dm
  • 0

#5
Oliver Wendel

Oliver Wendel

    New Member

  • Member
  • Pip
  • 3 posts
I have the same problem plus another:
this pertains to to another tab in the same Excel file:

after creating a hyperlink and use it once or twice it disappears. I have to create the hyperlink again.
  • 0

#6
dm27

dm27

    Member

  • Member
  • PipPipPip
  • 272 posts
Hello Oliver,

Wow, this is an old thread...

Not sure if you wanted to start your own topic, however, can you describe the actions taken that seem to cause the hyperlink to vanish?

Also, what version of Excel are you using?

Thanks,

dm
  • 0

#7
Oliver Wendel

Oliver Wendel

    New Member

  • Member
  • Pip
  • 3 posts
Thanks for the reply.
I'm using Excel 2007.
The only actions prior to the hyperlink disappearing is that I test it. Sometimes it disappears after one test, sometimes after two or three tests.
Oliver
  • 0

#8
dm27

dm27

    Member

  • Member
  • PipPipPip
  • 272 posts
Interesting...

So the text remains in the cell but the link becomes disabled? Is this a shared workbook or are you the only user?

dm
  • 0

#9
Oliver Wendel

Oliver Wendel

    New Member

  • Member
  • Pip
  • 3 posts
Yes, the text remains in the cell. I am the only user.
Thanks for the reply
  • 0

#10
Sualbh

Sualbh

    New Member

  • Member
  • Pip
  • 1 posts
I have similar problem. I put hyperlinks on cells to files in the same drive. However after some time (may be same day or after 3-4 days) hyperlinks start pointing to the same file itsel and not the intended file (where thay were set). This problem has started from last one month only, was not there earlier. Any Help.

Sulabh
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP