Results 1 to 2 of 2

Finding External Workbook references

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-22-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    122

    Finding External Workbook references

    This may be a easy question. But i am merging multple workbooks into a single workbook. The process is pretty tedious, but its going well, BUT, i am running into issues, trying to track down the references/links to the previous workbooks the sheets were in. The Edit > Links, is of no use, it tells me where its referencing, but i need to find the cells so i can update the formualas accordingly, to keep everying on one workbook. Is there an easier process to accomplish this? I have managed to trace a large portion of the formulas and correct them, but going thru each cell frm A1:IV65536 will be VERY time consuming. Any help would be appreciated.
    Last edited by paxile2k; 12-16-2010 at 06:20 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1