Macro coding to hide formulas in cells

Friends,

I have excel data where i am calculating my employees performance against the volume of work they do.

I have written simple formulas in every cell like multiplying the values in two cells(A1*B1),to add(A1+B1) etc... But when i paste this formulas for more than 500 cells the excel size is getting huge and it takes lot of time to open the file.

Is there anyway to do with macros so that all the formulas behind the cells should go to the backend(Visual Basic window) and do its function.