View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dhstein dhstein is offline
external usenet poster
 
Posts: 266
Default Linked Files - How to find reference

I have combined a number of individual files into one workbook by using "Move
or Copy Sheet". Some of these sheets had macros and defined names and I am
in the process of consolidating all of these into the new workbook. Every
time I open the new workbook, it indicates that there are links to other
files. My question is, is there a way to determine which cells are still
referring to the original workbooks? Thanks.