Hi,

I have 2 questions: -

1. I have quite a large workbook with formulas connected to several sheets; the problem is when I go to copy (highlight the column, right click, copy) Excel freezes and I get the error message 'not responding', then it closes. I'm using Excel on Office 10. Any suggestions?

2. I want to hide all zero amounts and have done this by tools, options, unticked zero values and just to be sure conditional format using white text; even after this there are some zero amounts that are still visible, why is this?

Any help appreciated.