Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Default Active Cell? = Iteration / Maximum Change Issue

Greetings!

I'm new to this forum, but not to Excel. I've run into a problem that has
me stumped. I'm hoping someone here knows a trick they might share.

I've got a really large workbook (16meg) with many iterative calculations.
Most all of these calculations settle out or seem to twiddle
back and fourth in the hundredths or thousandths places.

I'd like to set "Maximum Change" to 1 and have 25 or so iterations.

However, there seems to be some calculation somewhere that is
flopping around in the range of 50 and makes my iterations keep
going infinitely unless I set "Maximum Change" to 50 or so. If I can
find this calculation, I'm sure I can settle it down.

This workbook is huge and I can't for the life of me find the flipping
flopper. Does anyone have a technique for finding the cells that are
changing? I'm watching all sorts of cells, but I can't find the changers.

I know it sounds odd, but this is making me nuts...

Thanks in advance for any suggestions or assistance or ideas.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't change the active cell when navigating a spreadsheet Russ Excel Discussion (Misc queries) 1 March 24th 10 05:44 PM
Is there a way to change the active cell by a text box? [email protected] Excel Discussion (Misc queries) 1 March 30th 07 03:15 PM
Active Cell To Change Formula PaulW Excel Discussion (Misc queries) 7 September 21st 06 04:03 PM
Change Formatting In 'Active' Cell JB2010 Excel Discussion (Misc queries) 4 February 2nd 06 05:58 PM
How do I change color of active cell in Excel lfletcher Excel Discussion (Misc queries) 4 April 4th 05 06:29 PM


All times are GMT +1. The time now is 08:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"