excel is forgetting the values of formulas???

**tibibs** · 08-01-2012, 04:09 PM

Hi!

I got an issue with my file of excel :/

I got a big file. One sheet where all the calculus are done (with some personal functions), and the others sheets link to this worksheet to display the values we want.

my issue is that each time i make a change in my file, the values that are calculated by one of my formulas just become "#values", even if i change a cell which isn't linked to the cells with my formula :/

what can be the problem? is excel releasing memory?? :/ because i have to perform a forced calculation (by pressing CTRL + ALT + F9) on the right sheet! each time i do a modification :/

thank's in advance

**martindwilson** · 08-01-2012, 04:56 PM

what formula does it happen to,or should we guess?

**rkey** · 08-01-2012, 04:58 PM

are you sure you have the option for calculation on Automatic?

**FDibbins** · 08-01-2012, 06:32 PM

make sure you have your calculation set to automatic

**tibibs** · 08-02-2012, 01:50 AM

yes calculatio nis set to automatic!

for the function, here it is :

Please Login or Register  to view this content.

date_debut contains a date
lignes contains a string like that :

173:173,196:196,209:209,212:212,214:214/237:237,250:250,253:253,255:255,278:278,291:291,294:294,296:296

type_cam is a range of cells in column (an entire column) cotainning integers
dates_livr is a range of cells (multiple rows and columns) containing dates

if you have any question, go for it, i know my function is dirty coded :/ and in french so it doesn't help to find the problem for you

**JosephP** · 08-02-2012, 02:06 AM

your function is at fault. it refers to Range and Rows which refer to the active sheet at the time the calculation occurs, not necessarily the sheet where the function is used or where its argument ranges are located. you should really pass all necessary ranges as ranges if you can.