Excel Not Responding after I Click Solve or Resolve Buttom

I have Microsoft Macro Excel file and having trouble when i click solve or resolve. I get a spinning circle and i see Not Responding message on top of Excel like a picture that i attached. I think the code is perfect enough because i'm not get any error or debug message. I think it's because the file need many data so it get error.

Can you kindly explain it to me how to fix it? I attach my file too, thank you.

Screenshot (241).png

Debug Module1 is showing 'SOLVER' missing in > Tools > References.

Are you sure you have run debug - (spelling mistake for 'TRUE')

Please Login or Register  to view this content.

i have make sure that i tick the solver box

Attachment 708986

Your attachment is invalid - see big yellow banner - how to upload.
Ah!, but do you have Solver installed.

thank you, after your reply i've check all of typo but it still not responding

a couple of more typo's
sheet name 'Results' should be 'Result'

Please Login or Register  to view this content.

Originally Posted by Hydraulics

There may be other problems in your macro, anyhow I guess this line

Please Login or Register  to view this content.

should actually be

Please Login or Register  to view this content.

HTH,

Francesco

Thanks a lot, it can be run now!