Amazingly, there is a workaround! The trick is to make a function, that has the cell with the formula in it as an argument, using "Define Name" hidden under "Name Manager". The nice thing about this is that it obeys the rules of expanding down rows, such that if you define a named function for one cell that uses another cell (presumably but not necessarily in the same row), then you just pull the corner of that cell down and the functions placed into the new cells use the corresponding cells in the same downward direction.
Here is the nicest tutorial online at the moment for how to do this: http://www.myonlinetraininghub.com/excel-factor-12-secret-evaluate-function
