VB deleting all my valid references before finished

[bcmacuser]

Hi, I need the help of a guru because I'm hitting my head over here and nothing I've searched answers this question, I have a bunch of tables in excel that are populated from a stored proc on MS server. I want to delete the table and create a new one each time since as I make changes to the code on the back end all the time for use in other applications. And, I can't keep on updating new copies of the workbook.

I want to use a table array function so that I can easily do v/h lookups without unnecessary clutter.

Here is an example of my array function -

=IFERROR(INDEX(LTV_ORIG[ORIGBALANCE_SUM], MATCH(1, (LTV_ORIG[CUSIP] = SelectedCusip) * (LTV_ORIG[LTV_BUCKET] = "LTV_70_80"), 0)),"")

Now if I add column in the stored proc and rerun the vb the column names switch even though I am actually returning the same column names....

Is there any way that I can tell excel just to chill out and not touch any of the formulas in my spreadsheet? I want to stop it from putting "#REF" when I haven't even finished yet. By the way, enable.calculation = false does not work.

If you know how to keep excel from deleting my formulas before the sub is finished I would be much obliged. Not to sound curt, but if you don't know the answer please don't post unnecessary answers that don't help anyone.

Thanks very much, you guys rock!