How to solve a Circular Reference problem

[Guest]

I have a complex workbook (Excel 2003) (2mb) and am trying to add a macro
that will reset (clear) all inputted data & change the dates in the
workbook. Everything works as expected except the date change. when I try ro
change the first date (cell A4) which only has an inputted date, not a
formula, with the last date (cell F46) by using the =F46+1, I get a circular
reference error. If I change the the calculation to iteration with a max of 2
it works, until I try to exit, then the calculation keeps progressing. I
tried a Max of 1, but only half of the dates were changed and a 3 will
continue to calculate further. Any Ideas? Thanks

 

[Guest]

It sounds as though the date you have in Cell F46 is a formula, and one that
is ultimately dependent on your initial date in A4 - if you open up Circular
Reference toolbar it will show you in which cells the circulation is.

(I set up a test one for myself where F4=A4, then F5=F4+1, F6=F5+1 etc. down
to F46)...

Please reply with the content of Cell F46 so that I can be sure?

Steve

 

[Guest]

Steve:F46=F45+1. also I utilize hyperlinks from A4 to all other worksheets
giving me the same date range on every page. A4 is the first cell and the
starting date, then each additional cell is the +1 for the next date.
Thanks for your help.
Larry

 

[Guest]

Sorry...and A4 is (for example) 02/11/2005
Larry

Steve:F46=F45+1. also I utilize hyperlinks from A4 to all other worksheets
giving me the same date range on every page. A4 is the first cell and the
starting date, then each additional cell is the +1 for the next date.
Thanks for your help.
Larry

 

[Guest]

Larry

I would suggest that you replace the part of your macro that makes A4=F46+1
with a copy and paste routine - that way you will avoid creating this
circular calculation
~
Steve