Excel 2003 Freezes when copy/paste cells into different workbooks/

[RManning]

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!

 

[Jan Karel Pieterse]

Hi RManning,

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.

Maybe there is a file corruption involved, try roundtripping the file(s)
through html (save-as web page (html), close, open html in Excel and save-as
workbook).

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

 

[RManning]

Thanks, Jan for responding so quickly.
I tried out your suggestion and still had the same results unfortunately. Do
you have any other ideas I could try? Would it help to upgrade to Office
2007? This is not something I really want to do because our company standard
right now is Office 2003 but I do need this issue resolved because this user
uses Excel extensively.
Any suggestions are welcome!
Thanks
Rabia

 

[Jan Karel Pieterse]

Hi RManning,

Do
you have any other ideas I could try? Would it help to upgrade to Office
2007? This is not something I really want to do because our company standard
right now is Office 2003 but I do need this issue resolved because this user
uses Excel extensively.

Does this happen when another user logs on to the same computer? If not, it
might help to remove the profile from the client.
(I know, you loose all your settings, don't forget to salvage the My Documents
folder!!)

Have you tried a Help, Detect and Repair from Excel?

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com