Tool-Options-Calculations

W

Wendy

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save workbook without shapes 0
VBA Coding Help for Beginner 0
VBA for Dependents shortcut menu 0
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
Code does not error but no copy either 4
Code copies twice...? 13
Ignoring a runtime error 1
Auto Calculate selected worksheets 5

Top