| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| tool: options disabled | Excel Discussion (Misc queries) | |||
| Why would excel tool bar options be grayed out? | Excel Discussion (Misc queries) | |||
| why does the tools-options calculations reset to automatic after | Charts and Charting in Excel | |||
| Right to Left Tab in Options of tool menu | Setting up and Configuration of Excel | |||
| I am missing view tool bar from tool menu. | New Users to Excel | |||
![Wendy[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
