Hi, I tried to use the search fucntion but it kept giving me memory errors... So I oppologise if this has been answered..

I have a spreedsheet with neumorous formuli over 4 sheets, all of which use cell ranges off each other and a data sheet.

A large amount of data is pasted into the data sheet and most formuli get there cell ranges from here.

The problem Im having is that some times the formuli loose their cell references and I have to manually recreate the formula's.

EG: the formula should be SUMPRODUCT(--('friday data'!$P$2:'friday data'!$P$65000))

However it changes to SUMPRODUCT(--('friday data'!#REF!:'friday data'!#REF!))

I have tried locking the cells with the formuli and protecting the worksheet, however it stills happens. another note would be to add that this does not happen all the time...

could it be something to do with the data being pasted into the 'friday data' sheet?