I have an excel file that is 17mb in size and it has recently been giving me
problems calculating. Whenever I hit F9 to recalculate, it does not
calculate the file. The only solution so far is using the F2 key in each
cell that is not calculating and then hitting the enter key. Any suggestions?

Thanks.

Try rebuilding the dependency tree with CTRL+ALT+SHIFT+F9
Please let us know whether it helped you

--
Kind regards,

Niek Otten

"ss" wrote in message
...
I have an excel file that is 17mb in size and it has recently been giving
me
problems calculating. Whenever I hit F9 to recalculate, it does not
calculate the file. The only solution so far is using the F2 key in each
cell that is not calculating and then hitting the enter key. Any
suggestions?

Thanks.

Use CNTRL-ALT-F9 instead
--
Gary''s Student


"ss" wrote:

I have an excel file that is 17mb in size and it has recently been giving me
problems calculating. Whenever I hit F9 to recalculate, it does not
calculate the file. The only solution so far is using the F2 key in each
cell that is not calculating and then hitting the enter key. Any suggestions?

Thanks.