N
N|X6S|X
Not every time, but very often after i save a file i have been working on the
data corrupts somehow..
Even though the input data for the formula is right, the formula says it has
an error, and i have to delete lines till i find the one causing the problem
then re-enter the data.
This only happens after i have saved it and and reopen it the next morning.
Really annoying as i have to go and fix it nearly every morning, which takes
about 10-15 mins, depending on the amount of data i have to sift through..
I am using Excel 2003, and it is a =SUMPRODUCT(--(X3:X299+AJ3:AJ299=2))
formula. Basically putting 1's into different cells to make different stats.
there are quite a few of these formulas just corresponding to different cells
(people/sales). And even though there is only a 1 in the cell, the formula
says it has an error, yet all the info is right..
Any idea's??
data corrupts somehow..
Even though the input data for the formula is right, the formula says it has
an error, and i have to delete lines till i find the one causing the problem
then re-enter the data.
This only happens after i have saved it and and reopen it the next morning.
Really annoying as i have to go and fix it nearly every morning, which takes
about 10-15 mins, depending on the amount of data i have to sift through..
I am using Excel 2003, and it is a =SUMPRODUCT(--(X3:X299+AJ3:AJ299=2))
formula. Basically putting 1's into different cells to make different stats.
there are quite a few of these formulas just corresponding to different cells
(people/sales). And even though there is only a 1 in the cell, the formula
says it has an error, yet all the info is right..
Any idea's??