Bruce White 9.Sep.09 01:09 PM a Web browser 1-2-3 All Releases All Platforms
OK, first I'm a 123 user since 1982, and even used Visicalc before that! Never made the switch to Excel. Never used this forum before either. I'm using 123 Version 9.5.
For the very first time, I've created a complex Sheet A that I want to copy 10 times in the workbook (Sheets B to K) and then modify each so that the 10 copies (Sheets B to K) will essentially be added up to Sheet A as a grand total. Cells in the original Sheet A are made up of a combination of absolute, relative and mixed cell references. All cell references use only column and row letters and numbers, never the worksheet letter A.
Problem is that some of the formulas on sheet A that get copied to Sheets B to K end up with formulas that incorrectly refer to cells in Sheet A (absolute versus relative). This happens in particular for the formula @COUNT which I use extensively to calculate the number of columns in a range.
Are there any fixes out there to get the worksheet copy function to correctly copy the cells relative, that is with no reference to Sheet A? Is this issue solely related to the @COUNT function? Do I need to upgrade to Version 9.8? Any ideas? Thanks.