[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Excel scrolling very slow

Posted on 2016-09-23
9
Medium Priority
?
1,273 Views
Last Modified: 2016-09-24
I have a workbook I use every day.  Last night I noticed that scrolling using the arrow keys, it goes very slowly.  It goes to the next cell, then there is a delay before going to the next cell.  This does not happen in any of my other workbooks.
0
Comment
Question by:rrhandle8
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
9 Comments
 
LVL 17

Expert Comment

by:bigeven2002
ID: 41813371
Hello,
Which version of Excel are you using?
Is the scrolling latency happening on just the one workbook or any workbook?
Is the workbook in classic or native format?
Does the workbook use any macros?
If you use Tab to go to the adjacent cell, does it have latency like the arrow keys?
Do you have any other excel files open at the same time?
Did the latency just start?  Have you rebooted the computer to see if it persists?
0
 

Author Comment

by:rrhandle8
ID: 41813406
Which version of Excel are you using?
2010 but this workbook is 2003
Is the scrolling latency happening on just the one workbook or any workbook?
Just the one
Is the workbook in classic or native format?
Please explain the difference
Does the workbook use any macros?
Yes. All my workbooks contain macros
If you use Tab to go to the adjacent cell, does it have latency like the arrow keys?
Yes. Acts just like the arrow keys
Do you have any other excel files open at the same time?
Yes and they all work just fine
Did the latency just start?  Have you rebooted the computer to see if it persists?
 Started last night. Rebooted the computer a few times and also did the "Open and Repair"

Additional note: A week ago I made a back-up of the workbook.  I opened the back-up this evening, and the arrow keys work fine.  I would go back to using the backup, but the workbook gets appended with new information every night.
0
 
LVL 17

Expert Comment

by:bigeven2002
ID: 41813424
Ok thanks for the update.  For Classic vs native, is the workbook in xls or xlsm format?  Since the work book worked fine last week, how many rows of data are in the work book currently?
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

Author Comment

by:rrhandle8
ID: 41813426
Tens of thousands
0
 

Author Comment

by:rrhandle8
ID: 41813427
It is .xls. I converted to .xlsm.  Still does not work.  Previous ones in the .xls format work fine.
0
 
LVL 17

Accepted Solution

by:
bigeven2002 earned 2000 total points
ID: 41813754
OK the old xls format can only handle up to 65000 rows, so as you approach that limit, there will be a performance impact as you are seeing.

Try this, create a brand new blank XLSM file, and then copy over the rows to the new file say 1000 at a time.  When you reach 10000, save and close the file, reopen to see if performance is normal, if so, continue with the next 1000 until reaching 20000, repeat.  If the text has any formatting, be sure to paste without the formatting.

If performance stays normal throughout the entire copy process then copy over the macros, save, close and reopen.  Is performance maintained?

Also, is your Office 2010 up to date with that latest service pack and updates?
0
 

Author Comment

by:rrhandle8
ID: 41813829
I was planning to do what you recommended.  Knowing there were a lot of Defined Names in the workbook, I was wondering how I would move these to the new workbook.  I opened "Manage Names" to see what was all there.  To my surprise, there were hundreds of Defined Names that all started with "ExternalData_".  See image. I do not know where they came from, but I am sure some macro is creating them.  After I deleted all of them, saved, closed and reopened the workbook, everything is working just fine.

Thanks for pointing me in the right direction.

2016-09-24_9-50-35.png
0
 

Author Closing Comment

by:rrhandle8
ID: 41813832
bigeven2002 pointed me in the right direction.
0
 
LVL 17

Expert Comment

by:bigeven2002
ID: 41813835
OK great!  Glad I could help!
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
New style of hardware planning for Microsoft Exchange server.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question