ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Corrupt data question.. (https://www.excelbanter.com/excel-discussion-misc-queries/153181-corrupt-data-question.html)

N|X6S|X[_2_]

Corrupt data question..
 
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??


All times are GMT +1. The time now is 08:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com