PDA

View Full Version : Excel. Row-wise calculations



22-04-2001, 11:40 AM
In earlier versions of Excel and in Lotus 123 you used to be able to select the mode of calculations so that one calculation iteration was done - either on a row by row basis or on a column by column basis. This enabled you to avoid circular reference errors where it was deliberately created as a 'switch' in certain models.
Question - Is there any way in Excel 97 and Excel 2000 to achieve this method of calculation ???