Excel 2003 - formala fill / paste problem

[Number6]

One of our bursary staff has a weird problem that I've not seen before. She is using a spreadsheet with a simple summation formula in one cell, it's just adding up cells to the left. If she copies and pastes the cell content to another cell, or if she fills a range of cells then the new cells display the result of the cell copied from instead of what it should be. The summation ranges in the cells copied to are correct and if the formula is manually typed into a new cell it's fine.

 

Anyone seen this before?

[danrhodes]

You've confused me!

[linkazoid]

/\ /\ /\ /\ /\ /\ /\ /\ As previous poster said /\ /\ /\ /\ /\ /\ /\ /\

 

Try Paste Special Values only...

 

Michael

[echo]

Sounds like it's not recalculating the formula to me. Go to tools > options > calculation and check automatic is selected.

 

We find that sometimes it is set to manual by default.

[danrhodes]

Sounds like it's not recalculating the formula to me. Go to tools > options > calculation and check automatic is selected.

 

We find that sometimes it is set to manual by default.

 

Or just press f7 i think!

[Number6]

You've confused me!

 

/\ /\ /\ /\ /\ /\ /\ /\ As previous poster said /\ /\ /\ /\ /\ /\ /\ /\

 

Try Paste Special Values only...

 

Michael

 

Tried all the paste options with no success.

[Number6]

Sounds like it's not recalculating the formula to me. Go to tools > options > calculation and check automatic is selected.

 

We find that sometimes it is set to manual by default.

 

I'll try that one, thanks.

[MattMitchell]

Press f9 to recalculate will sometimes fix it

[Number6]

Sounds like it's not recalculating the formula to me. Go to tools > options > calculation and check automatic is selected.

 

We find that sometimes it is set to manual by default.

 

Thanks everyone, it was this one.