Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 

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:44 PM.


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