I get the same message if I create a copy using "New Book" option in the
Move or Copy sheet option on the Edit Menu .

However, if I elect to copy to an existing book then I can change the
links - provided that the book has been saved.

Another option is to copy the whole sheet after clicking on the grey square
where the Row and Column hearders meet which will highlight the whole sheet,
paste that into the new workbook and - if the workbook has been saved,
change the links.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Dan the Man" wrote in message
...
I tried changing the source to point at the new workbook, however when I
attempted to do this I got an error message which read:

"your formula contains an invalid external reference to a worksheet.
Verify
that the path, workbook and range name or cell reference are correct and
try
again"

I've tried this process with the source workbook (Evaluation Outcomes)
opened, as well as closed, and the same error message keeps appearing.

The suggestion seemed so logical and obvious too for breaking the link
without losing the formulas (changing the source to point to the new
workbook). Any additional suggestions would be of help.

Dan

PS: Thanks for your suggestion too Boxey, but that didn't seem to work for
me. I appreciate the idea however.

"Sandy Mann" wrote:

"Dan the Man" wrote in message
...
Forgot to mention that I'm aware of how to "break a link",

How are you breaking the link? I find that if I "Change source" to point
at
the new Workbook then it removes the link without losing the formulas.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Dan the Man" wrote in message
...
Forgot to mention that I'm aware of how to "break a link", however when
doing
this (as you probably know) I lose the formulas. I only want to lose
the
actual link portion of the formulas ([Evaluation Outcomes.xls] between
the
books, not the formulas themselves. That I can't figure out how to do.

Again thank you,

Dan

"Dan the Man" wrote:

Thank you for your response. It worked. However I don't want to keep
the
link, as my plan is to delete the orginal "Evaluations Outcome"
workbook
once
it is moved to the "Master Data Base" book. I do notice the links
attached to
all formulas, and I just want to break them, but maintain my formulas.

Dan

"smartin" wrote:

Dan the Man wrote:
I have a new spreadsheet that I created entitled "Evaluation
Outcomes", and
I'd like to copy and paste it into an existing spreadsheet
(entitled
Master
Database-different book), however when I attempt this I get a
message
advising me that data on the clipboard is not of the same size and
shape.
Thus, if I paste the page it does not provide me with a copy that
is
the same
in dimensions. Even worse, I lose all my forumulas in the process.
Any
solutions to obtain an exact copy (including formulas) without
having
to
reset all my rows and columns by hand?



Thanks in advance,

Dan

Open both workbooks. Select your "Evaluation Outcomes" workbook.
Choose
Edit | Move or Copy Sheet, and point to the other workbook. Make
sure
you tick the option to "Create a copy".

Note if you have formulae in the original worksheet that refer to
other
worksheets in the original workbook, the copied version will link to
the
original workbook.