consolidating workbooks

J

Jim

Hi,

I inherited a situation at work wherein I use several different workbooks
which, after they have been fully maintained and updated, when printed out
and assembled become a complete document. There are various cells in the
workbooks that link to each other. I would like to consolidate these various
workbooks into one comprehensive workbook, with the old workbooks becoming
worksheets withing the new, consolidated workbook. I began doing this today,
and I've been painstakingly updating the old links so they will find the
proper cells in the new workbook. My question is, is there an easy way to
dispay linked cells and their respective source and/or target(s), so that I
can be sure I don't miss any?

Any help would be greatly appreciated. Thanks in advance.

Jim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy range from one workbook to another 6
Help on consolidate worksheets from different workbooks into one 2
Save specific sheets to new workbooks adding tomorrow's date to na 1
Mulitple workbooks open simultaneously 2
Consolidating Information 1
Pasting a chart as object between instances of Excel 5
Sharing workbooks limitations - Merged Cells 12
problem with linked workbook 1

Top