circular references

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Circular References

Circular References

resolvedResolved · Low Priority · Version 2003

Gareth has attended:
Dreamweaver 8 Introduction course
Excel Intermediate course
Excel Advanced course

Circular References

I have a spreadsheet with many pages feeding off each other. There is a constant 'Circular Reference' error that keeps coming up and various cells do not want to add up properly. Is there an easy way of identifying the issue and resolving?

RE: Circular References

Hi Gareth

Thank you for your question

Can you just clarify the following? Was the workbook originally constructed in Excel 2003, or 2009

Thanks

Stephen

RE: Circular References

Hi Stephen,

It was orginally 2003.

Thanks

Gareth

RE: Circular References

Hi Gareth

Thanks for your question

I'm sorry for the delay in replying. I have been away from work for the last few weeks due to illness. I appreciate that you may have already solved the problem, if this is not the case could you please advise me so that I can giver it my urgent attention

Regards

Stephen

Mon 27 Jul 2009: Automatically marked as resolved.


 

Excel tip:

Outlining - ungrouping rows or columns

Highlight want you want to ungroup and press ALT + SHIFT + right cursor arrow

View all Excel hints and tips


Server loaded in 0.09 secs.