Excel

[KP]

Excel 2003 - inserting a line into worksheet, causes the columns
(w/formulas) to get misaligned. Worksheet has some 3300 lines and 12
columns, we use this to track our inventroy. Any suggestions would be
helpful.

 

[bj]

what do you mean by "misaligned"?
is the data off horizontally or vertically?
are all of the locations off, or just some?

 

[Daniel CHEN]

What do you mean mis-aligned? The reference in the formula does not change
automatically after line insertion?
One possible reason is that how to cell address is referred in your formula.
Please be more specific about your problem.

===== * ===== * ===== * =====
Daniel CHEN

[email protected]
www.Geocities.com/UDQServices

Free Data Processing Add-in<

===== * ===== * ===== * =====