Copy and Paste

[S. Kissing]

I have a master sheet that I copy to from another workbook. Sometimes it
works fine and other times my sheet that I copy to crashes. Any ideas why
coping and pasting could cash a crash?

 

[des-sa]

try this: right click on the master sheet's name tab>click "move or copy",
select new book from "to Book" list, click in "Create copy" box.

 

[S. Kissing]

I copy cells, not sheets.........

try this: right click on the master sheet's name tab>click "move or copy",
select new book from "to Book" list, click in "Create copy" box.

 

[JoeSpareBedroom]

Has anything changed on your computer? New hardware or software? Power
outages or crashes?

 

[RManning]

I am actually having the same exact issue.
I have two workbooks - one is a master workbook sent to me by a customer and
I need to paste information from certain cells into an existing workbook. I
use keyboard shortcuts to move between workbooks as well as the copy and
paste shortcuts. In the beginning it works fine but as I progress, when I
change to a workbook, some cells are 'empty' and it takes a few seconds for
the information to re-appear in the cells. Eventually, one of the workbooks
completely locks up and I have to do an End Task.
These are the actions I've taken to try to resolve the issue but have not
had any success:
1- I've tried different files (so it's not necessarily this particular
master file).
2- I've also tried copying into a brand new workbook.
3- I've tried putting the information in one single workbook but different
tabs and copying/pasting between tabs instead of workbooks.
4- Downloaded latest service pack (3) and any updates to Excel 2003
5- Un-installed/Re-installed Excel
6- Checked hardware (i have a 2.2 ghz Intel Centrino laptop w/ 4GB of RAM
and 70GB of HDD free)

Please help!

 

[JoeSpareBedroom]

I wonder if this could be a new feature (also known as a curse) introduced
by a windows or office update. Do you have your update thing set for fully
automatic, meaning that Microsoft can inject your computer with new diseases
while you're not looking?

 

[RManning]

Definitely not set as automatic but I have downloaded everything available
(critical updates only). I can't remember if problem this coincided w/ an
update or not. It's very frustrating though!!

 

[JoeSpareBedroom]

Subscribe to this free and very dependable newsletter:
www.windowssecrets.org

Any time you see an update available, wait a month or two and pay close
attention to that newsletter, which reports disasters experienced by other
users. Very often, the reports come from corporate IT departments where they
test all new updates on expendable machines that don't affect users.

 

[Gord Dibben]

Try a little cleanup.

Delete all your TIF files.

Delete your *.tmp files from Windows>TEMP and Users>Local Settings TEMP folders.

Perform the latter after a re-boot.


Gord Dibben MS Excel MVP

 

[JoeSpareBedroom]

TIF files? Aren't those graphics files? If so, why delete them?

 

[Gord Dibben]

TIF...........Temporary Internet Files found at Start>Control Panel>Internet
Options>General>Temporary Internet Files>Delete Files

Perhaps you were thinking of TIFF.........Tagged Image Format File.

Can also be known as TIF


Gord