Stop Autocell formula changes...
Posted by Rickey Bowers Jr. on January 03, 2001 2:16 PM
I have some formulas that I roll over to another column each month and they mostly reference another sheet that I build the source data on from a external database. As I format the data, I have to delete rows and columns on the source sheet. When I do this the formulas change what cells they are referencing. I want to stop Excel from updating those cell references until I'm done formating the data.
Thanks in advance, Rickey