I have a workbook in Excel 2002 that is linked to my ACCPAC (accounting)
database using an ODBC driver called F9. The workbook has 29 worksheets
which access the database to produce a set of financial statements. For some
reason, formulas will convert to numbers without warning. It's different
formulas each month. I don't know if they change when I recalculate
(calculation is set to manual) or when I save the workbook, or when I open
it, but it happens on a regular basis.
I've tried locking the cells, but then the ODBC driver doesn't work
My questions a
1) Is there a way to fix this problem?
2) Is there an easy way to
search through the entire workbook and find the
formulas that have converted to numbers? Currently I have to do this
manually and it can take a very long time to search through all the cells of
29 worksheets each month!