Formula being replaced by =#N/A
 

Hi,

I have a spreadsheet saved on a server at work. It has multiple tabs one of
which is a summary tab containing various formulas to summarise data. Over
the last few months, some of the formulas are being "deleted" and replaced by
"=#N/A". Just to make sure this is clear, the "#N/A" isn't just displayed as
the answer to the formula, it is now the actual formula.

This spreadsheet is protected and I'm reasonably sure it's not someone doing
it deliberately, although I guess that is always a possibility.

One of the tabs is linked to our SQL server to obtain data from the previous
workday. A query is used to obtain data over a given period of time.

Another tab is a pivot table of that data and then we have the summary tab
which contains the formulas to split up the data (quite possibly a lot of
double work there, I know).

So, my question, is there any reason that you can suggest that might cause a
formula to disappear and be replaced by "#N/A" - assuming that it's not a
user doing it deliberately?

I've tried changing the query so that it is only returning recent data and
not going back too far. I thought maybe the spreadsheet was being worked too
hard, so I am now getting data for just a few months rather than 2 years ...
but that doesn't seem to help either.

Please let me know if any further information is required for this.

Thanks,
Scott

Formula being replaced by =#N/A
 

A similar thing once happened to one of my spreadsheets- i would also be
interested in what the reason was.

R.

"Scopar" wrote:

Hi,

I have a spreadsheet saved on a server at work. It has multiple tabs one of
which is a summary tab containing various formulas to summarise data. Over
the last few months, some of the formulas are being "deleted" and replaced by
"=#N/A". Just to make sure this is clear, the "#N/A" isn't just displayed as
the answer to the formula, it is now the actual formula.

This spreadsheet is protected and I'm reasonably sure it's not someone doing
it deliberately, although I guess that is always a possibility.

One of the tabs is linked to our SQL server to obtain data from the previous
workday. A query is used to obtain data over a given period of time.

Another tab is a pivot table of that data and then we have the summary tab
which contains the formulas to split up the data (quite possibly a lot of
double work there, I know).

So, my question, is there any reason that you can suggest that might cause a
formula to disappear and be replaced by "#N/A" - assuming that it's not a
user doing it deliberately?

I've tried changing the query so that it is only returning recent data and
not going back too far. I thought maybe the spreadsheet was being worked too
hard, so I am now getting data for just a few months rather than 2 years ...
but that doesn't seem to help either.

Please let me know if any further information is required for this.

Thanks,
Scott