View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Wendy[_3_] Wendy[_3_] is offline
external usenet poster
 
Posts: 11
Default Tool-Options-Calculations

HI...

Does anyone know how the Iterations affects your workbook? I have this
template that I store on this workbook.

Whenever a user opens this up, you get 1 sheet and if they want to add more
sheets to the workbook, it takes the template and copies it over to the new
workbook....but I have formulas in the template that refers to the sheet 1,
so A1 =A1 (from Sheet 1) so of course I"m going to get a circular reference
error..but when I click on Iterations and set it to 1, I dont' get the error
anymore. Just wanted to know how this will affect anything else...

Thanks

wEndy