If you downfill a formula into more than 9 rows in an existing workbook and save it, the formulas will contain #REF!. This also occurs if you downfill a row containing a formula to more than 6 rows. I used the BiffViewer and the length of the recsize and expression length does not seem to be correct when the error occurs. They are off by 6 bytes. This causes the formula record to be interpreted into a ExpPtg instead of a MultiplyPtg. I can provide example excel files if needed.
Created attachment 5783 [details] Sample workbook with formula problem
That's next on my todo list. How do you downfill in Excel (Im not a user, just a dealer)? Thanks
You can select the cell or row with the formula and then move the cursor to the lower right corner. When the cursor changes to a thin black plus sign, you can drag it into the following rows.
Committed fix for this issue 05/07/2003