What is the best way to replace a table that is referenced by multiple formulas ?

Hi aimster1525 ,

The best way is to re-build your solution where it does not involve using formulas.

Question: what does your formula do? Not asking what the function does in terms of excel functions but your formulas are getting information from the dataset and where is that information going to? show us that elaborated on your formula is getting info from the dataset and being used where? In that context.  So we can figure out how we can create a solution without using formulas. So we need to know the lay of your spreadsheet land since we already know that the information is coming from the dataset, where is the destination? your formula is streaming information from the dataset to where? a table? a calculation? to feed what. a form?

thank you 

cheers