View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Silena K-K Silena K-K is offline
external usenet poster
 
Posts: 37
Default Calculated fields in Records

Hi there

I have a template set-up that is used to insert new records into an excel
workbook. However if I set-up columns with calculated fields what I find is
when I enter a new record it is inserted into the next available row that
does not have a calculated field.

Other than deleting the calculated field, is there a way to insert records
into blank rows that have calculated fields?

Thanks Silena