Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Difference between Cut and Paste....
Morning all!
This may be an easy question to answer or not... In Excel what's the difference between Cut and Paste? The reason I ask is because I have a sheet where I get #REF! errors when the users 'Cut' data between cells. The sheet, I'll call sheet 1, is referenced by multiple other sheets in the workbook (mostly formulas). It has its Headings (Columns/Rows) hidden, so the users can't delete entire rows. Sheet 1 has no formulas in it. When the users Copy data into Sheet 1 and move the data around using Copy, all is well. If the users move the same data around using Cut, I get #REF! errors in the sheets that reference Sheet 1. What is causing this? Thanks for any and all replies DanF |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Difference between Cut and Paste....
I think you are landed in wrong forum as your question is for excel and this
is word forum..! neways, Let's assume that you have data in Sheet1 and you have inserted formula in Sheet2, in this case Sheet2 will only display the calculated value (reference) of Sheet1. When you copy data from Sheet1, it works properly. But, when you CUT that data from Sheet1, ultimately, you are (re)moving the reference value of Sheet2. As a result, Sheet2 has nothing to display as the reference from Sheet1 is missing -- Regards, Anup "DanF" wrote: Morning all! This may be an easy question to answer or not... In Excel what's the difference between Cut and Paste? The reason I ask is because I have a sheet where I get #REF! errors when the users 'Cut' data between cells. The sheet, I'll call sheet 1, is referenced by multiple other sheets in the workbook (mostly formulas). It has its Headings (Columns/Rows) hidden, so the users can't delete entire rows. Sheet 1 has no formulas in it. When the users Copy data into Sheet 1 and move the data around using Copy, all is well. If the users move the same data around using Cut, I get #REF! errors in the sheets that reference Sheet 1. What is causing this? Thanks for any and all replies DanF |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Difference between Cut and Paste....
Ooooppsss! Clicked on the wrong favourite link!!
Thanks for replying, but it doesn't really make a lot of sense. Surely the cell C6 (for instance) is always C6 - if you move the data around, why does the formula try to follow it? I would have thought that a formula should always reference the cell you wish, unless you instruct it otherwise. Oh well. Better instruct the users not to use CUT!! Thanks mate, I'll try to read the links before clickng on them next time! ;-) "Anup Tawde" wrote: I think you are landed in wrong forum as your question is for excel and this is word forum..! neways, Let's assume that you have data in Sheet1 and you have inserted formula in Sheet2, in this case Sheet2 will only display the calculated value (reference) of Sheet1. When you copy data from Sheet1, it works properly. But, when you CUT that data from Sheet1, ultimately, you are (re)moving the reference value of Sheet2. As a result, Sheet2 has nothing to display as the reference from Sheet1 is missing -- Regards, Anup "DanF" wrote: Morning all! This may be an easy question to answer or not... In Excel what's the difference between Cut and Paste? The reason I ask is because I have a sheet where I get #REF! errors when the users 'Cut' data between cells. The sheet, I'll call sheet 1, is referenced by multiple other sheets in the workbook (mostly formulas). It has its Headings (Columns/Rows) hidden, so the users can't delete entire rows. Sheet 1 has no formulas in it. When the users Copy data into Sheet 1 and move the data around using Copy, all is well. If the users move the same data around using Cut, I get #REF! errors in the sheets that reference Sheet 1. What is causing this? Thanks for any and all replies DanF |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Difference between Cut and Paste....
"DanF" wrote:
Ooooppsss! Clicked on the wrong favourite link!! Thanks for replying, but it doesn't really make a lot of sense. Surely the cell C6 (for instance) is always C6 - if you move the data around, why does the formula try to follow it? I would have thought that a formula should always reference the cell you wish, unless you instruct it otherwise. By default, cell references in Excel are relative, unlike the cell references used in Word table cells which are absolute. To force an absolute reference in Excel, use $ with rows and/or columns. For example: $C$6 will always refer to that cell, even if you copy or cut it. -- Stefan Blom Microsoft Word MVP Oh well. Better instruct the users not to use CUT!! Thanks mate, I'll try to read the links before clickng on them next time! ;-) "Anup Tawde" wrote: I think you are landed in wrong forum as your question is for excel and this is word forum..! neways, Let's assume that you have data in Sheet1 and you have inserted formula in Sheet2, in this case Sheet2 will only display the calculated value (reference) of Sheet1. When you copy data from Sheet1, it works properly. But, when you CUT that data from Sheet1, ultimately, you are (re)moving the reference value of Sheet2. As a result, Sheet2 has nothing to display as the reference from Sheet1 is missing -- Regards, Anup "DanF" wrote: Morning all! This may be an easy question to answer or not... In Excel what's the difference between Cut and Paste? The reason I ask is because I have a sheet where I get #REF! errors when the users 'Cut' data between cells. The sheet, I'll call sheet 1, is referenced by multiple other sheets in the workbook (mostly formulas). It has its Headings (Columns/Rows) hidden, so the users can't delete entire rows. Sheet 1 has no formulas in it. When the users Copy data into Sheet 1 and move the data around using Copy, all is well. If the users move the same data around using Cut, I get #REF! errors in the sheets that reference Sheet 1. What is causing this? Thanks for any and all replies DanF |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is the difference ? .... | Mailmerge | |||
what is the difference between F4 & Ctrl+Z | Microsoft Word Help | |||
difference in aphostrophe? | Microsoft Word Help | |||
Difference between copy-paste and inserting a doc | Microsoft Word Help | |||
What is the difference in using 'paste' and 'paste special'? | Microsoft Word Help |