Penny Arcade Forums› Help / Advice Forum
The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.

Vexing spreadsheet link problem.

JohnnyCacheJohnnyCache Starting DefensePlace at the tableRegistered User regular
in Help / Advice Forum
I am working on a spreadsheet for work.

the template has jumps in it - hyperlinks that skip you from sheet to sheet in the workbook.

The issue is - they just...disappear. We do a bunch of work in the spreadsheet, then one day when we open it, they're ...gone.

Not like "open the formula up in the formula bar and fix what's wrong with it" not "The link is relative"

the hyperlink formula disappears and there's nothing left but the text. You can't find any trace it was a hyperlink.

Any thoughts on what is eating these links?




I host a podcast about movies.

Posts

  • OrogogusOrogogus San DiegoRegistered User regular
    You didn't say what program you're using, but if it's a recentish version of Excel, go to Tools -> Options -> Advanced -> (General) Web Options -> Files, and uncheck Update links on save. I don't know what it's supposed to do, but in practice all I've seen it do is wreck links and not tell you.

  • JohnnyCacheJohnnyCache Starting Defense Place at the tableRegistered User regular
    Using the current excel, sorry.

    I'll try that


    I host a podcast about movies.
  • Dis'Dis' Registered User regular
    Sometimes links can be dropped if there are spaces or odd characters in the address?

Sign In or Register to comment.
Penny Arcade Forums› Help / Advice Forum