In the file you want to hide click Window, Hide. When you close Excel itselt it will ask you if you want to save changes to that workbook - say yes. Then when you next open the file it'll be hidden but you'll still be able to use formulae and add/retrieve data from it. Does that do the trick?
HTH,
D