Some thoughts ..
.. The Problem is that the sheets appears to carry
their File Path with them creating a Problem
for my formulas within the destination sheet [book]

Think it's because the formulas on the sheets within the source book to be
moved over are referencing other sheets in the source book

Is there a way to keep the Formulas intact to represent the
destination sheet?

Try tinkering in this way ..

First, ensure that all dependent sheetnames referenced by the formulas
within the sheets to be moved over, eg: Day14, etc actually *exist* within
the destination book before proceeding ..


In the source book,
(Do this one sheet at a time)

Select the entire sheet to be moved
Click Edit Replace
Find what: =
Replace with: zzzzz
Click Replace All
(this effectively "neutralizes" all formulas on the sheet)

Then move the sheet over to the destination book,
and reverse the process ..

Select the entire sheet (which is copied over)
Click Edit Replace
Find what: zzzzz
Replace with: =
Click Replace All
(Array formulas, if any, would need to be re-entered using CSE & re-filled)

Repeat for next sheet ...
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mhz" wrote:
Hello, I have a situation where I want to move 3 sheets from one
workbook to another. The Problem is that the sheets appears to carry
their File Path with them creating a Problem for my formulas within the
destination sheet..

Is there a way to keep the Formulas in tact to represent the
destination sheet?

The Workbooks have the same Data, but 3 sheets from the source workbook
need to be inserted in the destination workbook without paths in the
formulas leading back to the source workbook (file).

eg.

Source workbook sheet1 A1 Reads:

=IF(DAY14!B330,DAY14!C33,"")

When it is copied to the Destination Worksheet it Reads:

=IF('[JULY CALLS CREATION BU9 TESTING.xls]DAY14!B330,'[JULY CALLS
CREATION BU9 TESTING.xls]DAY14!C33,"")

I modified the above formula slightly to remove the Reference errors,
but I just want to show basically what is happening...

Thanks for any help here...


--
Mhz
------------------------------------------------------------------------
Mhz's Profile: http://www.excelforum.com/member.php...o&userid=35980
View this thread: http://www.excelforum.com/showthread...hreadid=561798