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