Excel 2007 : Formula copying no longer works

**Aaisha** · 04-16-2010, 01:35 AM

Hi

After years of use my Excel won't paste the formulas I've copied anymore. It also doesn't want to re-calculate my sheet with any new data I capture.

I use Excel 2007.

Please help.

Thanks

Aaisha

**royUK** · 04-16-2010, 01:46 AM

You aren't giving enough details?

How are you copying the formulas?
Is it happening with only one workbook?
Is the sheet or workbook protected?
Is Calculation set to Automatic?

**Aaisha** · 04-16-2010, 03:26 AM

How do I attach a sheet to show an example of my formulae not working & not pasting?

**royUK** · 04-16-2010, 01:20 PM

Use the Post Reply Button,then Go Advanced , Then scroll down the page to find the manage attachments button

**Aaisha** · 04-17-2010, 08:36 AM

Thanks.

The workbook I've attached has two sheets showing two different cases of the problem I have.I've circled the problem.

**NBVC** · 04-17-2010, 08:44 AM

Your SUM formula in F26 of Apr 10 sheet is including the cell it is in causing a circular reference.

Try: =SUM(F5:F25)

The formulas on the other sheet are refering to cells in column P which have no data.

And they don't need to be within SUM() function. Just simply do the subtractions.