links to other worksheets
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: links to other worksheets

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have a worksheet that previously had links to other worksheets, when the worksheet was opened it would ask the quesiton "... contains links, do you want to update now ..." (or something similar). The worksheet no longer has links, the cells are now used for direct inputs or formulas all referencing the opened worksheet. Is there away to have it stop asking the question when the worksheet is opened, (since there are no links)???

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Belgrade, Yugoslavia
    Posts
    156
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,
    easiest way is to copy that sheet and paste it in new one. Choose "Paste special"-Values and than "Paste special"-Formats.
    This way you will remove links.
    Hope this will help.
    Sax

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    39
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    You must still have links on the sheet. If you select Edit Links this will tell you the sheet you are linking to. You can then search for the first part of the filename e.g c:...
    Have you got an hidden sheets containing a link?

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com