<div>
One trick for getting formulas to update is:<br />
1) Select the range containing the formulas<br />
2) In the Home menu, go to the Find &amp;&nbsp;Select item, choose Replace...<br />
3) Put an equals sign in both the Find what and Replace with fields, then click Replace All
</div>


One trick for getting formulas to update is:
1) Select the range containing the formulas
2) In the Home menu, go to the Find & Select item, choose Replace...
3) Put an equals sign in both the Find what and Replace with fields, then click Replace All

<div>
This worked perfectly, thank you! Unfortunately the &quot;True&quot; is text rather than boolean, but this totally fixed the formulas. <br />
<br />
thank you!
</div>


This worked perfectly, thank you! Unfortunately the "True" is text rather than boolean, but this totally fixed the formulas.

thank you!

<div>
<div class="content wysiwyg-content">
I have seen similar questions but not this exact one yet. <br />
<br />
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: &nbsp; =Countif(Section3!AF2:AF20<wbr />0, TRUE)<br />
<br />
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... <br />
<br />
Any ideas for a permanent fix for this? <br />
<br />
thank you!<br />
<br />
(Using Excel 2007)
</div>
</div>


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? 

thank you!

(Using Excel 2007)

Formulas not working in Excel sheet without Edit, linked to SQL table

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.