site Search:


 
    All Forums Hot Topics Gallery






how-to block ads


 
Search Topic:
Share Topic
Posting?
Post a:
Post a:
Links: ·MS Apps FAQ ·Windows XP FAQ ·Windows 7 FAQ ·Windows Home ·Office Home
AuthorAll Replies


Kilroy
Premium,MVM
join:2002-11-21
Ann Arbor, MI

reply to Danny_P

Re: [Excel] Excel links break when moved

Sounds like you need them to be absolute links. You can do it for cells by pressing F4, it changes from A2 to $A$2, this indicates that it will always use A2, so if you copy from A3 to B3 it will still use A2.

Don't know how to do this for a file location, but would assume there is a way. Just trying to point you in the right direction.
--
“Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.” ¯ Robert A. Heinlein

Wednesday, 19-Jun 16:24:34 Terms of Use & Privacy | feedback | contact | Hosting by nac.net - DSL,Hosting & Co-lo
over 13.5 years online © 1999-2013 dslreports.com.
Most commented news this week
Hot Topics