Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Excel Errors / May 2008

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
RManning - 20 May 2008 16:45 GMT
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 - 21 May 2008 11:19 GMT
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
[quoted text clipped - 3 lines]
> 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 - 21 May 2008 16:40 GMT
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

> Hi RManning,
>
[quoted text clipped - 18 lines]
> Professional Office Developer Association
> www.proofficedev.com
Jan Karel Pieterse - 21 May 2008 18:20 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.