+ Reply to Thread
Results 1 to 7 of 7

1 Sheet slow to respond within workbook

  1. #1
    Registered User
    Join Date
    08-08-2014
    Location
    Ipswich, England
    MS-Off Ver
    2003, 2011, 2013
    Posts
    4

    1 Sheet slow to respond within workbook

    Hello,

    1st post due to a problem I can't fix. I'll try to keep it brief.

    Excel sheet (simple sheet, no formula or inserts although a large text box) created on Mac in Excel 2011 (365). Moved to a windows PC running XP & Excel 2003. Inserted into a wookbook of identical sheets. You can edit all the sheets apart from the inserted sheet which is slow to respond to commands, sucking up 100% of the CPU usage to complete the command - say 5 seconds.

    Copied workbook to another PC running the same (XP & Excel 2003) and it works fine.

    Would appreciate any comments.

    Mark

  2. #2
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: 1 Sheet slow to respond within workbook

    are there any external links to the old workbook?....sometimes that happens when you copy worksheets from workbook to workbook
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  3. #3
    Registered User
    Join Date
    08-08-2014
    Location
    Ipswich, England
    MS-Off Ver
    2003, 2011, 2013
    Posts
    4

    Re: 1 Sheet slow to respond within workbook

    No, It was a brand new sheet. I've also checked to see if there are any formulae loose in the sheet... nothing. Also bare in mind the sheet/workbook works fine on a identical machine it was then copied to from the problem machine.

    Im wondering if it is something to do with the minimum specification of the windows machine. Would a converted 2003 xls file (from 2011) have problems running on XP?

  4. #4
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: 1 Sheet slow to respond within workbook

    any thing is possible with windows (take that however you wish )...

    that was the only thing I could think of....sorry....

  5. #5
    Registered User
    Join Date
    08-08-2014
    Location
    Ipswich, England
    MS-Off Ver
    2003, 2011, 2013
    Posts
    4

    Re: 1 Sheet slow to respond within workbook

    Cool, Not a problem.

    I have had problems with this machine becoming unresponsive with excel, but some custon installs off the microsoft website solved those. I've gone back to that well, but it's dry.

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,050

    Re: 1 Sheet slow to respond within workbook

    Another thing to try...

    If all that copied sheet contains is values, highlight the entire thing, Copy/Paste Values, see if that changes anything?

    Or, if you copied the entire sheet over, delete that sheet (to start over), then just highlight the range you need, and again, use Copy/Paste values
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  7. #7
    Registered User
    Join Date
    08-08-2014
    Location
    Ipswich, England
    MS-Off Ver
    2003, 2011, 2013
    Posts
    4

    Re: 1 Sheet slow to respond within workbook

    Good call. I'll try that.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel Slow to respond
    By akbar in forum Excel General
    Replies: 10
    Last Post: 12-19-2013, 03:15 PM
  2. [SOLVED] Excel slow to respond..
    By akbar in forum Excel General
    Replies: 11
    Last Post: 08-14-2012, 07:44 AM
  3. Extreme Slow respond time
    By Patrick Cloutier in forum Excel General
    Replies: 2
    Last Post: 08-16-2006, 08:33 AM
  4. [SOLVED] Excel 2003 slow to respond
    By fenny@friis.com in forum Excel General
    Replies: 0
    Last Post: 08-09-2005, 06:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1