How may I combine separate workbooks
I have three separate Excel workbooks, each with one worksheet. There are links between some of the content of the three (data modified in a cell in the sheet in book one is reflected to a cell in the sheet in book two for example). Is there any way in which I could combine the separate sheets into one workbook so that I would only need to open one workbook to see and work on all three sheets, without the data links being broken, or do I need to copy the sheets to book one and then recreate the links manually?
|