MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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

Posted by Ed on January 06, 2001 8:15 AM

I had a similiar issue, what I did to resolve my issue was copy the formula to the new column. Past special value the data in the previous column and then formated the source data. Not sure if this will help your situation