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.

Linked Files - How to find reference
 

I would use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

dhstein wrote:

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.

--

Dave Peterson

Linked Files - How to find reference
 

you can also go to Edit/Links/Break Links

"dhstein" wrote:

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.

Linked Files - How to find reference
 

Thank you - that was perfect.

"Dave Peterson" wrote:

I would use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

dhstein wrote:

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.

--

Dave Peterson