Calculated column to only calculate populated rows?

I have a few calculated columns that fill down to the very very last row (which is going to cause the application to freeze).
When I refresh data, the last populated row will change, but will never go all the way down to the bottom of excel.

Can I make it so my calculated columns only calculate populated rows? ie, if there is data in any row, calculate the cell in the calculated column, but when there is no data, do not calculate. I dont need 0's all the way down to row 6666666666666

*the last populated row will always vary

So you have a bunch of rows of data (let's say rows 1 to 100 are populated with data), but you have formulas which reach all the way down to the bottom of Excel, just in case the data should go that far down?

I think you want to create a table of your data. Then, when rows are added, the default is for formulae to be copied over to the new row.

Delete all of the 'empty' rows with their unused formulae.
Select your data.
Hit Ctrl-T (and answer if headers are included or not)
You may then need to go to the first row of the table and enter in each formula for it to track, but I don't think so.
To add a row, go to the end of your table and then hit Tab.

32000 rows is really not taht much (especially when compared to 1.04 million rows)

I would suggest that you copy your formulas down that far ONLY, and begin them with something like this...

=if(A2="","",your-formula)
you could even have another formula somewhere to test how many rows you have, and to flash a warning is it exceeds 32000