Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a worksheet with a web query in columns A-I. Several columns from K onwards contain formulas from the web query data. When I hover over some of the cells in the formula columns, the cursor changes to a hand and a pop-up appears that shows reference to the web query data (http://www........). However, this does not happen with all of the formula's, only some. On the offending columns, if I delete the formula, leaving the cells blank, and hover over the blank cells, the pop-up still appears.

    This is causing considerable file bloat of about 1.5 meg per column of formula. Any idea's how I can stop this?

  2. #2
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I think that this was caused by the copying and pasting of the header cells from the web query accross some of the additional columns, thus also containing links to the query. Formula's in the cells below seemed to take on the links from above, which were then filled down.

    Rebuilding the worksheet from scratch solved the problem.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I suspect the cells in question still contained hyperlinks. You could have solved this with some VBA to remove all hyperlihnks I expect
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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