Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Voorhees, New Jersey
    Posts
    200
    Thanks
    0
    Thanked 0 Times in 0 Posts

    mystery link(s) (2002)

    When I open the 50+ sheet workbook this morning that I worked on late yesterday, I get a message about updating external links. I don't recall this workbook having any external links...
    Whether I tell it to update the links or not, I seem to get the same result...the workbook now has a light grey background (rather than white). In preview it appears that the light grey will not appear on the hardcopy...Is it some kind of reminder about the link(s)?

    Is there an easy way to determine the offending link?

    How do I get rid of the grey background? Saving the file under a new name doesn't appear to do it.

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: mystery link(s) (2002)

    To find links you can use Bill Manville's free addin FindLink

    As for the background has anything been set under Format>Sheet>background...

  3. #3
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Voorhees, New Jersey
    Posts
    200
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: mystery link(s) (2002)

    No, nothing is set under background...
    I also checked cell formatting, nothing there either...
    The pages print OK, the grey is just on the dsiplay...

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: mystery link(s) (2002)

    What about conditional formatting?

    Steve

  5. #5
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Voorhees, New Jersey
    Posts
    200
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: mystery link(s) (2002)

    nothing there either...
    remember, it's only on the screen disclay...it doesn't print out that way

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: mystery link(s) (2002)

    If you select View, Normal, does that help?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  7. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: mystery link(s) (2002)

    Did you check Tony's suggestion:
    <hr>As for the background has anything been set under Format>Sheet>background...<hr>

    Steve

  8. #8
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Voorhees, New Jersey
    Posts
    200
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: mystery link(s) (2002)

    doesn't make any difference...

  9. #9
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Voorhees, New Jersey
    Posts
    200
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: mystery link(s) (2002)

    Yes, I did. Nothing is set there...

  10. #10
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: mystery link(s) (2002)

    Window, arrange, tiled?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  11. #11
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Voorhees, New Jersey
    Posts
    200
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: mystery link(s) (2002)

    Doesn't make a difference...It's still gray.

  12. #12
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Ankeny, Iowa, USA
    Posts
    298
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: mystery link(s) (2002)

    Is it just this workbook that has the gray sheets? It's not all your sheets in all workbooks?

  13. #13
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Voorhees, New Jersey
    Posts
    200
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: mystery link(s) (2002)

    just this workbook

  14. #14
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: mystery link(s) (2002)

    Can you post a sanitized version of the workbook with any confidential data removed?

  15. #15
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Voorhees, New Jersey
    Posts
    200
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: mystery link(s) (2002)

    In preparing a sanitized version, I first saved the workbook to "sanitized.xls" and then proceeded to delete some of the sheets. Upon deletion of the first sheet (not the leftmost tab, but rather the first sheet that struck my fancy), VOILA! the grey disappeared from all remaining sheets as soon as I deleted a single sheet. Being as I have a relatively worthless sheet or two at the end of the workbook, the workaround is easy...

    BTW: One of the last things I recall doing yesterday was a statistical analysis to prepare a histogram...could this relate to the prolbem?

Page 1 of 2 12 LastLast

Posting Permissions

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