Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel 2007 iterating formula half a million rows

06 Feb 2015   #1
fibbermcghee

Windows 7 Pro x64 SP1
 
 
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 SpecsSystem Spec
.
06 Feb 2015   #2
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

Have a look at this MS website to see if it helps you.

https://support.office.microsoft.com...rs=en-GB&ad=GB

Also this Youtube video, while very simple & brief might help as well.

https://www.youtube.com/watch?v=8mk2QZnLiG0
My System SpecsSystem Spec
07 Feb 2015   #3
fibbermcghee

Windows 7 Pro x64 SP1
 
 

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 SpecsSystem Spec
.

07 Feb 2015   #4
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

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 SpecsSystem Spec
Reply

 Excel 2007 iterating formula half a million rows




Thread Tools Search this Thread
Search this Thread:

Advanced Search




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.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App