+ Reply to Thread
Results 1 to 3 of 3

Excel isn't responsive to simple actions

  1. #1
    Registered User
    Join Date
    12-01-2016
    Location
    Birmingham, AL
    MS-Off Ver
    standard 2016
    Posts
    8

    Excel isn't responsive to simple actions

    Hello,

    I have a comprehensive workbook that i've been using for a year now. Lately, i've been experiencing difficulty executing the simplest of actions. Some of which are:

    Selecting a cell and the cell isn't highlighted. (i see the cell change in NameBox, but doesn't allow editing)
    Changing formatting of a cell.
    Deleting a worksheet tab.
    selecting a range (i see the cell or range change in the Name Box, but doesn't allow editing)


    Other notes:
    I have had macros in this book, but have since deleted them all.
    Workbook and/or sheets are unprotected.
    I am the Creator of this workbook and no one else has access.

    Current work around.. I can change worksheets, click in a blank cell (i then see the highlight), hit space bar the backspace, the return to original tab and i can perform modifications to cell. However, i still am unable to delete the sheet. Also, i have to go through this exercise for every cell i wish to modify. I'm also experiencing this in other workbooks. I'm an above average excel user (not a pro by any means). Any suggestions are appreciated. I am unable to post the workbook due to confidential and PHI data.
    Thanks,

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,461

    Re: Excel isn't responsive to simple actions

    How big is the workbook in Megabytes? Check in Windows File Explorer.

    Note: please make a copy of the workbook before attempting any remedial action.

    Do you have any workbook or worksheet event handlers? Have you removed the code modules, not just deleted the code?

    How many worksheets are there? How many columns and rows in each worksheet? Press Ctrl-End to go to the last cell (as far as Excel is concerned) on each sheet. If ths is beyond the last row/column of "real data", that is likely the problem. You will need to select and delete the excess rows and columns. Use the Delete icon on the ribbon. Save, Close and Re-open the workbook after each .

    Have you copied the any formulae down to the last row, intentionally or inadvertently? Do you use Conditional Formatting excessively? Do you delete and add rows to the sheets?
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Excel isn't responsive to simple actions

    There is a small chance that the workbook is corrupted. If you continue to be stuck try copying all sheets into a clean workbook. You could also delete all of the data on the sheets, leaving formatting, etc., intact, and attach that.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. Non responsive Excel while editing
    By ITTechperson in forum Excel General
    Replies: 2
    Last Post: 01-05-2016, 03:40 PM
  2. [SOLVED] Responsive Excel Sheet (Fit to screen)
    By freeofcost in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-14-2014, 03:09 PM
  3. no responsive excel resets when use on network based folders. ONLY.
    By Abbadon486 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-24-2014, 11:20 AM
  4. Replies: 1
    Last Post: 10-18-2010, 11:10 AM
  5. when I autofill and save excel becomes non responsive
    By caponti33 in forum Excel General
    Replies: 1
    Last Post: 01-15-2010, 05:50 PM
  6. Excel non responsive
    By Ann Vamsi in forum Excel General
    Replies: 3
    Last Post: 03-23-2009, 07:46 AM
  7. [SOLVED] How to fix keys t s h c v non-responsive only in Excel?
    By bareedy in forum Excel General
    Replies: 1
    Last Post: 07-08-2005, 01:05 PM

Tags for this Thread

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