Worksheet copy does not preserve AVEDEV formula


#1

I have a spreadsheet that has a single worksheet with several blocks of cells formatted and with a few formulas added. At runtime, I open this spreadsheet, make as many new sheets as required by copying the original sheet, and then populate the new sheets with data.

Within my first sheet, I use the formula AVEDEV (e.g., the cell's content is "=AVEDEV(U4:U6)"). However, after I perform the worksheet copy, the cell's content is "=U4:U6". It appears that the "AVEDEV" formula is not getting copied.

Is this not supported?

Thanks,

Pam


#2

Hi Pam,

Please try this attached fix. Now this function is supported.