You have probably generated a circular reference.

The reason? How should we know without knowing your script nor your data??

So prepare yourself for a serious debugging-session. The following hints may be helpful:

• try to compare last weeks data with the current one - are there any special values?
• and compare the amount of data - do you have more this week? And are you now crossing some hard-coded limits?
• check all cells containing formulas - either in your excel-sheet or formulas written by your perl-script
• check all cells referencing other cells: are some constant rows/columns referenced (which might now be overwritten by your script?)
• try to "simulate" your script by hand, so you might find out when the circular reference occurs ... and if it is due to some data already present in your excel-sheet (e.g. a reference or a macro) or due to your perl-script
• generate a lot of debugging-output to localize where the error occurs

Good luck and happy debugging

Rata

PS.: don't forget to prepare a sufficient amount of coffee to support your efforts ;-)

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.