Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-04-2014, 03:06 PM
kiersten kiersten is offline Slow Moving Excel Spreadsheet.. Windows 7 32bit Slow Moving Excel Spreadsheet.. Office 2013
Novice
Slow Moving Excel Spreadsheet..
 
Join Date: Sep 2014
Posts: 1
kiersten is on a distinguished road
Angry Slow Moving Excel Spreadsheet..

I have a very large amount of data in one spreadsheet, which causes putting data in to be a REAL frustrating ordeal. Brand new Dell Latitude computer with an i5 processor and barely anything saved to my hard drive. Is there any way i can possibly speed up the process?
Lot of work to be done, dont have time to wait 3 minutes every time i type a single number...
Reply With Quote
  #2  
Old 09-05-2014, 06:48 AM
gebobs gebobs is offline Slow Moving Excel Spreadsheet.. Windows 7 64bit Slow Moving Excel Spreadsheet.. Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

How much is a large amount? I work with some tremendously large spreadsheets and databases on my crappy laptop and don't have any kind of slowing like that at all.
Reply With Quote
  #3  
Old 09-05-2014, 01:49 PM
excelledsoftware excelledsoftware is offline Slow Moving Excel Spreadsheet.. Windows 7 64bit Slow Moving Excel Spreadsheet.. Office 2003
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default

Sounds like you have a large amount of formulas in your worksheet. This can be fixed by turning the calculation to manual and then calculating the sheet before saving it. The other option is to have your formulas rewritten with a VBA script which is what I do now. I do this on spreadsheets where I have around 50,000 vlookups or countifs to complete.
Reply With Quote
  #4  
Old 09-09-2014, 03:03 AM
aleman aleman is offline Slow Moving Excel Spreadsheet.. Windows 7 64bit Slow Moving Excel Spreadsheet.. Office 2010 64bit
Novice
 
Join Date: Sep 2014
Posts: 4
aleman is on a distinguished road
Default

I have the same problem previously & check with IT department. Finally they decide to downgrade to Excel 2010 version which solve all the slow problem.
Reply With Quote
Reply

Tags
data entry, impatient, slow



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2010 slow update of worksheet bosve73 Excel 2 03-28-2012 05:14 AM
Slow Moving Excel Spreadsheet.. PC runs slow when opening excel The Chief Excel 1 01-27-2012 06:02 AM
Moving spreadsheet to Windows 7 don madsen Excel 1 09-30-2011 03:37 AM
Slow Opening Word and Excel files itoa Office 1 05-11-2009 02:01 PM
How do I use an Excel form to populate and Excel spreadsheet apostht Excel 0 05-21-2006 11:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:34 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft