Sandy,
Recording a macro did the trick. Thanks so much!!
--
Susan


"Sandy Mann" wrote:

Susan,

I assume that you have a 'rolling spreadsheet' that conitnually cycles
through the months. If so you need to break the cycle. Try recording a
Macro to copy December's cell to January as a value instead of a formula.

--
HTH

Sandy

with @tiscali.co.uk


"Susan" wrote in message
...
I have created a worksheet with 12 tabs (Jan-Dec). I am trying to get a
total for each month using the previous month's total. When I try to get
Jan's total by using Dec's total, I get an error message refering to
circular
reference and it cannot calculate the total. What do I need to do??
--
Susan