Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas spontaneously convert to numbers
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 properly. 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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Text to Numbers | Excel Worksheet Functions | |||
convert negative numbers to positive numbers and vice versa | Excel Worksheet Functions | |||
How to convert a series of numbers | Excel Worksheet Functions | |||
extract numbers, convert to date | Excel Discussion (Misc queries) | |||
How to convert Numbers to text | Excel Worksheet Functions |