# Using ODBC with Excel

**Category:** [Yahoo Archive](https://www.epiusers.help/c/yahoo-archive/9)
**Created:** 2001-01-11 12:42 UTC
**Views:** 343
**Replies:** 1
**URL:** https://www.epiusers.help/t/using-odbc-with-excel/1930

---

## Post #1 by @system

<div id="ygrps-yiv-2011821524">&quot;If the number of open quotes changes when I refresh the data in sheet<br/>
3, the formulas in each cell on sheet 1 permanently change to<br/>
=sheet3!#REF! because there is no longer any data in the corresponding<br/>
cell in sheet 3.&quot;<br/>
<br/>
A &quot;#REF!&quot; error occurs when an entire row or column is deleted, not just the<br/>
contents.  Make sure your macro is clearing cell contents instead of<br/>
deleting columns/rows.  To make sheet 1 cleaner, you can change to formula<br/>
to &quot;=if(sheet3!a1 =&quot;&quot;,&quot;&quot;,sheet3!a1).  This way, if the cells in sheet 3 are<br/>
empty, nothing will be displayed on sheet 1.<br/>
<br/>
HTH<br/>
Danice</div>

---

## Post #2 by @system

<div id="ygrps-yiv-953754340">I created an Excel workbook that has an ODBC query in sheet 3, with <br/>
Vantage Open Quote information loading into each column. <br/>
<br/>
I have the columns in sheet 1 linked to a corresponding column in <br/>
sheet 3 using the =sheet3!a1 formula for each cell.<br/>
<br/>
If the number of open quotes changes when I refresh the data in sheet <br/>
3, the formulas in each cell on sheet 1 permanently change to <br/>
=sheet3!#REF! because there is no longer any data in the corresponding <br/>
cell in sheet 3.<br/>
<br/>
Is there a better way to link the cells in sheet 1 to sheet 3 so I <br/>
don&#39;t lose my formulas when the data is refreshed? <br/>
<br/>
Thanks,<br/>
Brad</div>

---


**Canonical:** https://www.epiusers.help/t/using-odbc-with-excel/1930
**Original content:** https://www.epiusers.help/t/using-odbc-with-excel/1930