Copying and Pasting Question?
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 |
Copying and Pasting Question?
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. |
Copying and Pasting Question?
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. |
Copying and Pasting Question?
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. |
Copying and Pasting Question?
On Aug 17, 3:00*am, 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 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 |
Copying and Pasting Question?
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. |
Copying and Pasting Question?
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. |
All times are GMT +1. The time now is 01:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com