can't find link to other workbook (i think)
Posted by S N on May 01, 2001 12:41 PM
I have a workbook that has a LOT of links in it (all within the same workbook)... but i think through a lot of cutting and pasting i somehow have a cell in the workbook that links to another workbook.
If i open the workbook and then attempt to immediately close it, the computer asks if i wish to save the changes (which is why i assume there is a link somewhere to another workbook, which "refreshes" everytime i open the workbook).
Is there any "easy" way to find this link, or any other potential reasons why a given cell may refresh upon opening (i do have a web-query in the workbook, BUT it is NOT set to refresh upon opening).