I've lost my page view, only shows in print preview?

Firstly, apologies for the poor heading that closed my question. I've read the rules now!

I could really do with some help asap please!

I set up a passworded spreadsheet and saved it to my documents folder. I then copied it across to a network area I use to link to a company I work with. The file opens ok on the password but the page is completely white and I can see nothing at all! When I print preview the page I can see all my information but this doesn't help when I need to update it.

Not only that, the whole lot of excel spreadsheets I have both on my documents and the network area are doing the same thing! I've no idea how it's happened or what to do to retrieve the page view.

Can anyone help me? I can't work without putting this right and i've a mountain to get through!

Much appreciated
Jo