I am having some issues with excel clearing out formulas out of column
on its automatic refresh. This is a live data workbook that pulls its
information from our database. I have created a VLOOKUP formula to
adjust the quantities to the correct amounts of assemblies i.e. one
assemble may have 4 subassemblies. I want that column to reflect the
total work not just the main assemblies.1 vs. 4.The formula is
=IF(ISERROR(VLOOKUP(B2,lookuptable!$A$1:$B$25,2,FA LSE)),E2,VLOOKUP(B2,lookuptable!$A$1:$B$25,2,FALSE )*E2).
This formula has been dragged down some 20000 rows and the actual data
only takes up about 4000 rows. After the refreshes blanks start to
appear and they keep growing. The blank cells are random and change
after each refresh.


Any Ideas what this could be caused by?

Thanks,

ANYBODY HAVE ANY IDEAS??????????????????




wrote:
I am having some issues with excel clearing out formulas out of column
on its automatic refresh. This is a live data workbook that pulls its
information from our database. I have created a VLOOKUP formula to
adjust the quantities to the correct amounts of assemblies i.e. one
assemble may have 4 subassemblies. I want that column to reflect the
total work not just the main assemblies.1 vs. 4.The formula is
=IF(ISERROR(VLOOKUP(B2,lookuptable!$A$1:$B$25,2,FA LSE)),E2,VLOOKUP(B2,lookuptable!$A$1:$B$25,2,FALSE )*E2).
This formula has been dragged down some 20000 rows and the actual data
only takes up about 4000 rows. After the refreshes blanks start to
appear and they keep growing. The blank cells are random and change
after each refresh.


Any Ideas what this could be caused by?

Thanks,