Calculate Problem

[Trappy]

I have a problem with Excel returning 0 on all formulas on certain spreadsheets. I have tried going into options and ensuring that calculation is set to Auto and tried F9 to manually calculate but none of this helps. I've tried saving these files to a memory stick and then watched the same formula work on a colleagues PC. Sending it back to me it still doesn't work.

If I try to open a blank spread sheet using Ctrl+N, then the new sheet suffers from the same problem. As soon as I write in a forumla, the word calculate appears at the bottom left of my window underneath where a second tab would be. Any ideas?

Strangely if I open an Excel document using the programs list under the start bar, it doesn't have this problem?

To top it all off, if I paste a formula along with the related cells, onto a working document, it only pastes the 0 where the formula should be as if I had used paste special- values. Seeing this I tried to paste special hoping to just paste the formula and I get a box asking if I want to paste the data as a Microsoft Excel Worksheet Object with a list of other types to chose from.

I assume this is some option in Excel that has been changed but can't see any differences between these files and unnaffected ones. I believe these files are being affected somehow when I load them onto my memory stick.

I do have another PC at home and have opened the files from time to time on that. At home the formulae have always worked properly. Could it be something to do with differing Excel versions?

It's probably something really simple but it's really got me and is so annoying.

Thanks

[Mark@Work]

Does this happen with every formula, or just selected formulas?

Do you have any macros, VBA etc. that might effect the way EXCEL processes the cells.

It appears to be behaving as if the auto-calculate option is off, but you say you have looked at that.

Another option might be that the re-calculation is failing to complete for some reason, hence my question about macros and VBA.
Perhaps some bit of code is failing and returning to the default screen before the re-calculation is done.

Mark

[Trappy]

It happens to every formula on the same sheet. There are no macros running either.

I opened the file this morning and it was working properly, it's just a matter of time until it goes like it again I guess...