+ Reply to Thread
Results 1 to 3 of 3

Worksheet Extremely Slow To Display ???

  1. #1
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Worksheet Extremely Slow To Display ???

    .
    Would you be so kind to review the attached ? The Sr Mgt tab/sheet is extremely slow to display on screen here.
    The MAIN MENU and the workbook itself display fine. The problem only occurs with the Sr. Mgt tab.

    The original workbook has 8 other sheets. All the sheets, except the Sr. Mgt tab, display normally. Very quickly.

    I have gone through the following steps trying to correct this problem :

    Repaired the workbook.
    Highlighted all the empty rows from the bottom of the form to the last row on the Sr Mgt tab and deleted everything.
    Highlighted all the empty columns from the right side of the form to the last column to the right and deleted everything.
    Used several third party software pkgs to remove any extraneous, unseen code and errors.

    Still can't get the sheet to display quickly and normally like the other sheets.


    Also, occasionally the Sr Mgt tab will auto switch from Column Letters to the R1C1 format. I can go into the settings and change
    it to normal display for Column Letters and save it. But the workbook will still auto change for the Sr Mgt tab on occasion. ????

    There is some type corruption but I really don't want to retype everything.

    Does anyone have any ideas ?


    Thank you.
    Attached Files Attached Files
    Last edited by Logit; 02-14-2019 at 01:17 PM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,447

    Re: Worksheet Extremely Slow To Display ???

    Nothing attached - Perhaps try with the "Go advanced" button

  3. #3
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: Worksheet Extremely Slow To Display ???

    .
    Please disregard.

    I have done the untenable ... re-typed the sheet.

    Thank you for looking.

+ 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. Extremely Slow code. Please Help
    By flyersguy4 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-30-2011, 09:26 PM
  2. Extremely slow macro!
    By PSm1th29 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-23-2010, 06:27 AM
  3. FileCopy extremely slow
    By Idiot in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-07-2008, 12:10 AM
  4. Excel is extremely slow now
    By Martindelica in forum Excel General
    Replies: 0
    Last Post: 05-01-2007, 08:32 PM
  5. Extremely slow file
    By Jay in forum Excel General
    Replies: 3
    Last Post: 07-10-2006, 08:19 AM
  6. EXTREMELY slow toolbars?
    By Maury Markowitz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-23-2006, 11:20 AM
  7. [SOLVED] Workbook is now Extremely Slow
    By Dmorri254 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-03-2005, 02:19 PM
  8. [SOLVED] Excel extremely slow opening and using
    By domestic911 in forum Excel General
    Replies: 2
    Last Post: 01-26-2005, 05:06 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