Copying and Pasting Question?

[Dan the Man]

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

 

[Dan the Man]

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

 

[Dan the Man]

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

 

[BoxeyOK]

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

i don't know if this helps for the second point. I had to copy a large
block of formulas (each of which references another worksheet in the
source workbook)from one workbook to a another workbook.

I set the target workbook up with worksheets named exactly as in the
source workbook. Then Find-Replace all the equals signs in the source
worksheet with an otherwise unused combination of meaningless text
characters (like "q#"). This changes formulas into neutral text

Once copied to the target worksheet all the meaningless characters can
be Find-Replaced with equal signs which restores them as formulas.
Links to the original workbook are not preserved but references to the
identically named worksheets in the target workbook are
reconstructed.


I hope this helps
Boxey

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

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

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

 

[Dan the Man]

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.

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

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

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

:

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.

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

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.

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

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

:

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

:

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.