We made 4 working copies of a master workbook with 20 or so worksheets and
some macros. The plan was to have 4 people working on different worksheets,
copy their sheet to the master, resave the master both as the master and a
new working copy. We were very careful not to have two people worked on the
same sheet at the same time, but now when the third person goes to enter
their data where two others have worked, the cells have all these links ties
into the formulas. Is there a way to copy a page ourt of one workbook and
copy it into another workbook of like configuration, without creating a link
while preserving the formulas and macros in the destination file? Have I
thoroughly confused everyone reading this? Thanks if you can help.
James
ps. Does anyone know if there is a way to contact Microsoft tech assistance
with e-mail questions concerning a case number from an attempt at getting
tech support by phone (Was on hold too long at $1.70/min)?
Bill Manville - 29 Oct 2004 07:43 GMT
Jstevenstpa wrote:
> The plan was to have 4 people working on different worksheets,
> copy their sheet to the master, resave the master both as the master and a
> new working copy.
If there are links from the copied sheet to other sheets in the "slave"
workbook, and those other sheets have identical layout to the corresponding
sheets in the master workbook then you can Edit / Links / Change Source to
the Master workbook.
Other options, depending on the design of the sheets, would be to select the
areas of the "slave" sheet that contain constant data (rather than formulas)
and just Copy them to the cells in the "master" sheet.
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup