S
Scopar
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
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