
06 Feb 2015  #1 

Excel 2007 iterating formula half a million rows
Hi all,
Well, I've done it somehow. I have a spreadsheet in Excel 2007 in which I keep all our accounts. Since I had to come up with a Minimum Required Distribution this year, I tried tacking it onto later columns in this sheet. Worked great, once. Then the formula I used: =IF($L9="","",$L9/$K$3) which was supposed to follow the IRA's changing value. But, what it did was iterate for 500,000 rows, making a 12MB file out of a 16K file. Now I can't get rid of that formula. I've deleted it, but it's obviously hiding somewhere in the markup for that spreadsheet, and I can't stop it. In a word, HELP. (I've already copied the necessary part of the spreadsheet to a new one, so that's no problem, but I'd sure like to know how stop this thing. Any ideas? Bill2? Irene? 
My System Specs 
. 
06 Feb 2015  #2 

Have a look at this MS website to see if it helps you.
https://support.office.microsoft.com...rs=enGB&ad=GB Also this Youtube video, while very simple & brief might help as well. https://www.youtube.com/watch?v=8mk2QZnLiG0 
My System Specs 
07 Feb 2015  #3 

Thanks a lot, Ranger4. I finally decided to quit while I was behind and just redid the spreadsheet. Sure would like to know how I ended up with 1,048,065 rows, though. I got rid of the formula, but couldn't get rid of the rows. I'm sure the formula at one time had them all sitting there waiting for eventual data, but after the formula left the rows danced on. I've still got it, I'll pull it up and have another go, someday. Thanks again.

My System Specs 
. 

07 Feb 2015  #4 

Thanks for your reply & glad to hear you have it sorted out.
Did it end duplicating a whole lot of data, which could explain the sudden expansion of the spreadsheet. Obviously something went wrong when you used the formula, so the formula may be the problem. 
My System Specs 
Thread Tools  Search this Thread 
Similar help and support threads  
Thread  Forum  
Excel Formula Hello Sir, Can you let me know the formula in Excel: I have a table as below: This table, At the column "A,Status" when i Put the word" Completed", it's will automatic put current Date to Column "B, Row 2". But i don't know after that when tomorrow arrived,at the column "B,Row 2",... 
Microsoft Office  
Excel: Combining Rows Based on An Equal Value in One Column I have attached two images of an Excel worksheet. I have gone to the trouble of taking multiple sets of three columns of associated data, that is data of x, y, z where y and z are associated with x. In building a new table with six sets of data, I put x1, x2, ..., x6 in a single column, and then... 
Microsoft Office  
Re: EXCEL resorting rows so they each relate to original rows Hi, I couldn't find an answer in the Forums for this in the past half hour of looking through them there are so many, and I need an answer sooner than in the 4 or 5 days it will take me to get through them in HOPES of finding my answer. Sorry. So could someone who knows Excel in Windows 7... 
Microsoft Office  
Excel 2003 sum formula problem I have been entering currency data in Column B in Euros to an EXCEL 2003 s/s and the formula used has added these totals entered in that Column correctly until I reached a total sum of 74364.70 Euros ,this being the sum of entries in Rows B6 to B82 . This was reached with the formula showing as... 
Microsoft Office  
Excel Formula Help please... This is probably very simple and I have got it working but it isn't working how I want it to work. I have created an Excel document to show my monthly payments of a bank loan. I have created 3 columns in the first column is the payment number, in the second column is the amount that the loan... 
Microsoft Office  
Cant scroll while editing formula Excel 2007 Hi I'm unable to scroll while editig a formula in excel 2007. i know it can be done if i edit directly in cell but i prefer editing in the formula bar. I've seen an apparent solution in some forum which says change the mouse setting in the control panel (the wheel tab). Start > Settings >... 
Microsoft Office 
Our Sites 
Site Links 
About Us 
Find Us 
Windows 7 Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows 7" and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd All times are GMT 5. The time now is 13:34. 
