Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-12-2014, 08:32 AM
BobBridges's Avatar
BobBridges BobBridges is offline Excel simplify formula - array of sequential numbers Windows 7 64bit Excel simplify formula - array of sequential numbers Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

I thought maybe someone else would have a better answer, Wries, so I waited. But no one else has come up with a response yet, so I'll take a whack at it.

96 cells? That doesn't sound like very many; it isn't clear to me how that few cells could be slowing things down. How do you define "slow"? How much delay is there between <F9> and the end of the recalculation?

I'm also not convinced that INDIRECT is the probable cause. I used to use it quite a bit—I've found some better ways since, or ways at least that I think are better—and although I thought it would slow things down, I didn't usually find it so.



So what do you count as "slow"?
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel simplify formula - array of sequential numbers Creating a TOC with sequential letters instead of page numbers at the right margin shansen Word 1 03-11-2014 12:43 PM
Excel simplify formula - array of sequential numbers Convert String Array to Integer Array from a User Input? tinfanide Excel Programming 4 12-26-2012 08:56 PM
Excel simplify formula - array of sequential numbers Sequential document numbering excel'97 Scottlambert Excel 1 05-11-2012 03:40 AM
Excel simplify formula - array of sequential numbers Complex array formula andrei Excel 9 02-03-2012 03:40 AM
How to count the frequency of data and also tally value from an array of Excel record KIM SOLIS Excel 5 09-07-2011 09:01 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:18 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