Copy & Paste

  • Thread starter Thread starter jr
  • Start date Start date
J

jr

What's wrong with Excel in office XP?

When I copy information from worksheet and try to paste
them in a new worksheet, Excel will paste whole different
text in the new worksheet? Simply the original text will
disappear and something new is created in the new
worksheet.

Is there some options that I should put on/off which would
make this problem disappear?

I hope that someone can understand this english.

thank you!
 
This is not a known Excel 2002 problem and I think it has something to do
with your local setup. Try starting Excel in "safe mode" (from Start->Run
type "Excel.exe /s" [no quotes]). If the problem does not occur in safe
mode then it is probably due to an add-in or some other automatically
loading file. Check Tools, Add-ins for the add-ins and your XLSTART
folders. Any files in XLSTART are opened automatically by Excel when it
starts.
 
I tried out starting in "safe mode" but it didn't work or
I didn't do it right.

The problem is that I have one large file with 8 sheets
and about 2000 rows/sheet. I need to copy different
information for it by time to time. I found out that the
problem doesn't occur when I copy information from the
first sheet but if I copy information from other sheets
(same row but different sheet), problem will come back.
Could it have something to do with column "coding",
because when we enter information, we write it to the
first sheet and information will be copied to other sheets
automatically.

I don't know if this makes thing any easier to understand.

Thank you!
 
What are you copy|Pasting?

If it's formulas, could it be that your formulas are just evaluating to
something different? If I copy a cell that contains =A1 to a different sheet,
it'll evaluate to what's in A1 of that new sheet.

(Is that what you mean by column coding--it kind of sounds like it. If you're
only interested in what's in the cells, you can edit|copy, then edit|paste
special|Values (and maybe followed by edit|paste special|formats) to eliminate
the formulas/coding.)

And a silly guess: Any chance you've hidden rows/columns and selected a range
that included those hidden rows/columns. Maybe you're just seeing the cells
that were hidden on the original sheet.
I tried out starting in "safe mode" but it didn't work or
I didn't do it right.

The problem is that I have one large file with 8 sheets
and about 2000 rows/sheet. I need to copy different
information for it by time to time. I found out that the
problem doesn't occur when I copy information from the
first sheet but if I copy information from other sheets
(same row but different sheet), problem will come back.
Could it have something to do with column "coding",
because when we enter information, we write it to the
first sheet and information will be copied to other sheets
automatically.

I don't know if this makes thing any easier to understand.

Thank you!
-----Original Message-----
This is not a known Excel 2002 problem and I think it has something to do
with your local setup. Try starting Excel in "safe mode" (from Start->Run
type "Excel.exe /s" [no quotes]). If the problem does not occur in safe
mode then it is probably due to an add-in or some other automatically
loading file. Check Tools, Add-ins for the add-ins and your XLSTART
folders. Any files in XLSTART are opened automatically by Excel when it
starts.

--
Jim Rech
Excel MVP


.
Click to expand...
Click to expand...
 
Back
Top