iankids
2008-10-21, 10:54 PM
Hi All,
I think (?) something seriously weird is happenning when I copy and paste text from one sheet to another.
Having work through a number of sheets where the text is different on each sheet, I get to the first of several sheets where the text is pretty much the same for the subsequent sheets.
I select all of the text using the select all instances in the right click dialog. I then proceed to the following sheet to paste the text in and make a minor modification or two to the text.
This gets repeated for five or six times for the next five or six sheets.
When I go back to review earlier sheets, I find that the text on those sheets (and sometimes completely differnt text) has been copied and pasted as well, leaving a hrrible mess of text jumbled on one another. (see attached pdf)
Does the "select all instances" select all text on ALL sheets? Logically, this wouldn't seem right to me.
Likewise, when I use the select all instances for the multiple text on one sheet and then delete the text, all other text on all other sheets is also deleted!+
Further update. If I select every item idividually and then crtl C, everything is fine, it pastes into the next sheet OK and no duplicates are created on any other sheet.
I am running 2009 64 bit on a clean install of Vista 64bit OS
Any help or advice greatly appreciated.
Cheers,
Ian
I think (?) something seriously weird is happenning when I copy and paste text from one sheet to another.
Having work through a number of sheets where the text is different on each sheet, I get to the first of several sheets where the text is pretty much the same for the subsequent sheets.
I select all of the text using the select all instances in the right click dialog. I then proceed to the following sheet to paste the text in and make a minor modification or two to the text.
This gets repeated for five or six times for the next five or six sheets.
When I go back to review earlier sheets, I find that the text on those sheets (and sometimes completely differnt text) has been copied and pasted as well, leaving a hrrible mess of text jumbled on one another. (see attached pdf)
Does the "select all instances" select all text on ALL sheets? Logically, this wouldn't seem right to me.
Likewise, when I use the select all instances for the multiple text on one sheet and then delete the text, all other text on all other sheets is also deleted!+
Further update. If I select every item idividually and then crtl C, everything is fine, it pastes into the next sheet OK and no duplicates are created on any other sheet.
I am running 2009 64 bit on a clean install of Vista 64bit OS
Any help or advice greatly appreciated.
Cheers,
Ian