+ Reply to Thread
Results 1 to 2 of 2

Excel 2010 Crashes Whenever Worksheet Tab is Renamed

  1. #1
    Registered User
    Join Date
    09-23-2013
    Location
    U.S.
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    36

    Excel 2010 Crashes Whenever Worksheet Tab is Renamed

    I have an Excel 2010 workbook with about 10 worksheets and vba. When I create a new worksheet in the workbook and then go to the tab that reads "Sheet11" and change to anything else, Excel crashes. It first shows "calculating" in the lower right followed by a percentage and right before it gets to 100% it crashes. When the file auto recovers the tab has the new name I've given it, which is good, but I'd prefer not to have the workbook crashing so often. The workbook has vba created by someone else, which I suspect is the problem but he insists it cannot be his work because the problem is occurring with a brand new worksheet that has no vba. I've tried turning off all COM add-ins and that doesn't help.

  2. #2
    Registered User
    Join Date
    01-08-2014
    Location
    Irvine, CA ,USA
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: Excel 2010 Crashes Whenever Worksheet Tab is Renamed

    One place you can check is in VBA, go to Alt+F11.
    When Visual Basic opens, take a look at 'Microsoft Excel Objects' (upper left corner) see if you have very long sheet name.
    If you do, you can change it on properties window.

+ 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. [SOLVED] Macro works but crashes Excel 2010
    By Willardio in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-09-2012, 08:49 AM
  2. Excel 2010 crashes when macros are enabled
    By meera77c in forum Excel General
    Replies: 6
    Last Post: 09-05-2012, 08:36 AM
  3. Loop Macro Crashes excel 2010
    By jmoon3 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-03-2012, 07:57 PM
  4. MS Excel 2010 crashes
    By Richard_G in forum Excel General
    Replies: 0
    Last Post: 07-11-2011, 08:57 AM
  5. MS Excel 2010 crashes
    By Richard_G in forum Excel General
    Replies: 1
    Last Post: 06-25-2011, 12:18 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