자동수식 계산이 안될때

<DIV> ======================================================================================== 현재 사용하는 엑셀 버젼을 기재하시면 좀더 정확하고 신속한 답변을 얻으실 수 있습니다.    엑셀 버젼(예: 2007) : 2007 ========================================================================================   <a href='javascript:fileFilterViewer("http://cfile267.uf.daum.net/attach/2573954057EC862A1B03A2", "/cfile267/25/73954057EC862A1B03A2", "16.9월매출2.xlsx", "grpid%3D1GIVp%26fldid%3DK4Nh%26dataid%3D2936%26fileid%3D1%26regdt%3D20160929121526&url=http%3A%2F%2Fcfile267.uf.daum.net%2Fattach%2F2573954057EC862A1B03A2")'><img src="https://t1.daumcdn.net/daumtop_deco/icon/icon.hanmail.net/editor/p_etc_s.gif" border="0" alt="첨부파일" class="vam"/> 16.9월매출2.xlsx</a>   <a href='javascript:fileFilterViewer("http://cfile285.uf.daum.net/attach/2558324057EC8633282697", "/cfile285/25/58324057EC8633282697", "일일보고서2.xlsx", "grpid%3D1GIVp%26fldid%3DK4Nh%26dataid%3D2936%26fileid%3D2%26regdt%3D20160929121526&url=http%3A%2F%2Fcfile285.uf.daum.net%2Fattach%2F2558324057EC8633282697")'><img src="https://t1.daumcdn.net/daumtop_deco/icon/icon.hanmail.net/editor/p_etc_s.gif" border="0" alt="첨부파일" class="vam"/> 일일보고서2.xlsx</a> <TABLE style="WIDTH: 347pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=460> <COLGROUP> <COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 1888" width=59> <COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 1856" width=58> <COL style="WIDTH: 37pt; mso-width-source: userset; mso-width-alt: 1568" span=2 width=49> <COL style="WIDTH: 37pt; mso-width-source: userset; mso-width-alt: 1568" span=2 width=49> <COL style="WIDTH: 37pt; mso-width-source: userset; mso-width-alt: 1568" span=3 width=49> <TBODY> <TR style="HEIGHT: 16.5pt" height=22> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 88pt; HEIGHT: 16.5pt; BORDER-TOP: black; BORDER-RIGHT: black" class=xl275 height=22 width=117 colSpan=2>제품명</TD> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 74pt; BORDER-TOP: black; BORDER-RIGHT: black" class=xl275 width=98 colSpan=2>규 격</TD> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 74pt; BORDER-TOP: black; BORDER-RIGHT: black" class=xl274 width=98 colSpan=2> 조 장 </TD> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 111pt; BORDER-TOP: black; BORDER-RIGHT: black" class=xl275 width=147 colSpan=3>금 액</TD></TR> <TR style="HEIGHT: 16.5pt" height=22> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; HEIGHT: 16.5pt; BORDER-TOP: black; BORDER-RIGHT: black" class=xl276 height=22 colSpan=2>IEC08</TD> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black" class=xl275 colSpan=2>0.75SQ</TD> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black" class=xl274 colSpan=2>         10,000 </TD> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black" class=xl274 colSpan=3>                 558,000 </TD></TR> <TR style="HEIGHT: 16.5pt" height=22> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; HEIGHT: 16.5pt; BORDER-TOP: black; BORDER-RIGHT: black" class=xl275 height=22 colSpan=2>IEC52</TD> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black" class=xl275 colSpan=2>0.75SQ</TD> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: yellow; BORDER-TOP: black; BORDER-RIGHT: black" class=xl277 colSpan=2>         10,000 </TD> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: yellow; BORDER-TOP: black; BORDER-RIGHT: black" class=xl277 colSpan=3>                 558,000 </TD></TR> <TR style="HEIGHT: 16.5pt" height=22> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; HEIGHT: 16.5pt; BORDER-TOP: black; BORDER-RIGHT: black" class=xl275 height=22 colSpan=2>IEC53(몰딩)</TD> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black" class=xl275 colSpan=2>0.75SQ </TD> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: yellow; BORDER-TOP: black; BORDER-RIGHT: black" class=xl277 colSpan=2>                - </TD> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: yellow; BORDER-TOP: black; BORDER-RIGHT: black" class=xl277 colSpan=3>                          - </TD></TR> <TR style="HEIGHT: 16.5pt" height=22> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; HEIGHT: 16.5pt; BORDER-TOP: black; BORDER-RIGHT: black" class=xl275 height=22 colSpan=2>IEC53(몰딩)</TD> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black" class=xl275 colSpan=2>1.0SQ </TD> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: yellow; BORDER-TOP: black; BORDER-RIGHT: black" class=xl277 colSpan=2>                - </TD> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: yellow; BORDER-TOP: black; BORDER-RIGHT: black" class=xl277 colSpan=3>                          - </TD></TR> <TR style="HEIGHT: 16.5pt" height=22> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; HEIGHT: 16.5pt; BORDER-TOP: black; BORDER-RIGHT: black" class=xl275 height=22 colSpan=2>IEC53(시장)</TD> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black" class=xl275 colSpan=2>2.5SQ </TD> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: yellow; BORDER-TOP: black; BORDER-RIGHT: black" class=xl277 colSpan=2>                - </TD> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: yellow; BORDER-TOP: black; BORDER-RIGHT: black" class=xl277 colSpan=3>                          - </TD></TR> <TR style="HEIGHT: 16.5pt" height=22> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; HEIGHT: 16.5pt; BORDER-TOP: black; BORDER-RIGHT: black" class=xl275 height=22 colSpan=2>TFR-CV</TD> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black" class=xl275 colSpan=2>4SQ </TD> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: yellow; BORDER-TOP: black; BORDER-RIGHT: black" class=xl277 colSpan=2>                - </TD> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: yellow; BORDER-TOP: black; BORDER-RIGHT: black" class=xl277 colSpan=3>                          - </TD></TR> <TR style="HEIGHT: 16.5pt" height=22> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; HEIGHT: 16.5pt; BORDER-TOP: black; BORDER-RIGHT: black" class=xl275 height=22 colSpan=2>TFR-CV</TD> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black" class=xl275 colSpan=2>2.5SQ</TD> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: yellow; BORDER-TOP: black; BORDER-RIGHT: black" class=xl277 colSpan=2>                - </TD> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: yellow; BORDER-TOP: black; BORDER-RIGHT: black" class=xl277 colSpan=3>                          - </TD></TR> <TR style="HEIGHT: 16.5pt" height=22> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; HEIGHT: 16.5pt; BORDER-TOP: black; BORDER-RIGHT: black" class=xl275 height=22 colSpan=2>TFR-CV (OEM)</TD> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black" class=xl275 colSpan=2>6SQ </TD> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: yellow; BORDER-TOP: black; BORDER-RIGHT: black" class=xl277 colSpan=2>                - </TD> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: yellow; BORDER-TOP: black; BORDER-RIGHT: black" class=xl277 colSpan=3>                          - </TD></TR> <TR style="HEIGHT: 16.5pt" height=22> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; HEIGHT: 16.5pt; BORDER-TOP: black; BORDER-RIGHT: black" class=xl275 height=22 colSpan=2>TFR-CV (OEM)</TD> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black" class=xl275 colSpan=2>2.5SQ </TD> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: yellow; BORDER-TOP: black; BORDER-RIGHT: black" class=xl277 colSpan=2>                - </TD> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: yellow; BORDER-TOP: black; BORDER-RIGHT: black" class=xl277 colSpan=3>                          - </TD></TR> <TR style="HEIGHT: 16.5pt" height=22> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; HEIGHT: 16.5pt; BORDER-TOP: black; BORDER-RIGHT: black" class=xl275 height=22 colSpan=2>WOAS</TD> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black" class=xl275 colSpan=2>240SQ</TD> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black" class=xl274 colSpan=2>         23,789 </TD> <TD style="BORDER-BOTTOM: black; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: black; BORDER-RIGHT: black" class=xl274 colSpan=3>           337,803,800 </TD></TR></TBODY></TABLE>   수식삽입 하여 복사를 하면 두번째행은 첫번째값을 그대로 불러오고 세번째 행부터는 불러오지 못하다 마지막행은 정상적으로 실행이 되고 있습니다. 옵션에 수동수식이 되어있을까봐서 확인했는데 자동수식으로 체크가 되어 있습니다. 해결 방법을 알려주셨음 합니다  </DIV>