View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Formula Question
 
Posts: n/a
Default Formula Question

How do you automatically calculate information in unhidden cells that contain
a formula to calculate from another spreadsheet that shows data and hidden
cells that have a formula to calculate from another spreadsheet that returns
a Div/0! because data is unavailable without the formula result being Div/0!
because the hidden cells do not contain any data?