Formulas not working in Excel sheet without Edit, linked to SQL table
Posted on 2011-09-23
I have seen similar questions but not this exact one yet.
I have a SQL table linked into my excel workbook. On one sheet I have populated the data in tabular format, on another, I have a report that uses several formulas similar to: =Countif(Section3!AF2:AF200, TRUE)
The formulas generate 0 until I click through each field in the table, which is pretty extensive. The column in SQL is Varchar, the column in Excel says General. And because it is linked, anything I do to the excel sheet is temporary...
Any ideas for a permanent fix for this?
(Using Excel 2007)