æ³åããŠã¿ãŠãã ãããæ°åã®Windows 11ã§Excelã䜿ã£ãŠéèŠãªã¹ãã¬ããã·ãŒãã®ãããžã§ã¯ãã«åãçµãã§ãããšãçªç¶ãæããããExcel OLEã¢ã¯ã·ã§ã³ãšã©ãŒããçºçããã¯ãŒã¯ãããŒãã¯ã©ãã·ã¥ããŠããŸããŸããð© ã€ã©ã€ã©ããŸãããïŒã§ããå®å¿ãã ãããç§ããæäŒãããŸãããã®ã¬ã€ãã¯ãWindows 11ã®ãExcelãOLEã¢ã¯ã·ã§ã³ãšã©ãŒãã·ã³ãã«ãã€å¹æçãªæé ã§è§£æ±ºããããã®ãã¯ã³ã¹ããããªãœãŒã¹ã§ããç°¡æœã§å®è·µçãªè§£æ±ºçãããã«ã玹ä»ããã®ã§ãåé¡ãè¿
éã«è§£æ±ºããã¹ã ãŒãºã«åäœããã·ã¹ãã ã®å®å µæãå³ãã£ãŠããã ããŸãã
æè¿ã®ã¢ããããŒãã«ããäžå
·åãäºææ§ã®åé¡ãªã©ãExcelã®OLE ã¢ã¯ã·ã§ã³ ãšã©ãŒã¯ãå€ãã®å Žåããªããžã§ã¯ãã®ãªã³ã¯ãšåã蟌㿠(OLE) ã®åé¡ãåå ã§ããOLE ã¯ãExcelãªã©ã®ã¢ããªãä»ã®ããã°ã©ã ãšé£æºã§ããããã«ãã Microsoft ã®ãã¯ãããžãŒã§ããWindows 11ã§ã¯ãã¬ãžã¹ããªã®åé¡ããã¡ã€ã«ã®ç ŽæããŸãã¯å€ããœãããŠã§ã¢ãåå ã§ãã®ãšã©ãŒãçºçããå¯èœæ§ããããŸããæå ±ã§ããã»ãšãã©ã®ä¿®æ£ã¯æ°åã§å®äºããããã§ãã¹ãŠèª¬æããŸãããã®ãŸãŸèªã¿é²ããŠãã ãããããã«ãšã©ãŒã®ãªãèšç®ã«æ»ããããã«ãªããŸããïŒð
Windows 11 ã®ãExcelãOLE ã¢ã¯ã·ã§ã³ ãšã©ãŒãšã¯äœã§ãã?
ä¿®æ£ã«å
¥ãåã«ããã®åä»ãªåé¡ãç°¡åã«èª¬æããŸããããOLEã¢ã¯ã·ã§ã³ãšã©ãŒã¯éåžžããOLEã¢ã¯ã·ã§ã³ã¯ãµããŒããããŠããŸãããããèŠæ±ãããOLEã¢ã¯ã·ã§ã³ãå®è¡ã§ããŸããããšãã£ãå
容ã®ãã€ã¢ãã°ããã¯ã¹ãšããŠè¡šç€ºãããŸããç¹ã«ãªããžã§ã¯ãã®åã蟌ã¿ãããŒã¿ã®ãªã³ã¯ãVBAã¹ã¯ãªããã«ããã¿ã¹ã¯ã®èªååãªã©ãè¡ãéã«ãExcelã®æäœã忢ããŠããŸããŸãã
Windows 11ã§ã¯ãææ°ã®ã¢ããããŒãã«ãããã®ãšã©ãŒãããäžè¬çã«ãªãã365 ã 2021 ãªã©ã®Microsoft OfficeããŒãžã§ã³ãå®è¡ããŠãããŠãŒã¶ãŒã«åœ±é¿ãäžããŠããŸããäžè¬çãªããªã¬ãŒã¯æ¬¡ã®ãšããã§ãã
- ð ïž ç ŽæããExcelã¢ãã€ã³ãŸãã¯ãã³ãã¬ãŒãã
- âïž ã·ã¹ãã æŽæ°ã«ããã¬ãžã¹ã㪠ããŒã®ç«¶åã
- ð Office ã€ã³ã¹ããŒã« ãã¡ã€ã«ãç ŽæããŠããŸãã
- ð äºææ§ã®ãªããµãŒãããŒãã£è£œãœãããŠã§ã¢ã OLE ã³ã³ããŒãã³ãã«å¹²æžããŸãã
æ ¹æ¬åå ãçè§£ããããšã§ãçæ£é¢ããåãçµãããšãã§ããŸããããããã£ããä¿®æ£ã«åãæãããŸãããããŸãã¯æãç°¡åãªãã®ããå§ããå¿
èŠã«å¿ããŠãšã¹ã«ã¬ãŒã·ã§ã³ããŠãããŸãã
ã¹ããããã€ã¹ãããã¬ã€ãïŒWindows 11ã®ãExcelãOLEã¢ã¯ã·ã§ã³ãšã©ãŒãä¿®æ£ããæ¹æ³
ãã®ãšã©ãŒãè§£æ¶ããæºåã¯ã§ããŸãããïŒä»¥äžã®å®èšŒæžã¿ã®æ¹æ³ãé çªã«å®è¡ããŠãã ãããææ°ã®Windows 11ãã«ãã§ãã¹ãæžã¿ãªã®ã§ãææ°ãã€ä¿¡é Œæ§ã®é«ããã®ãšãªã£ãŠããŸããç¡é§ãªæ
å ±ã¯äžåãªããããªãã»ã©ïŒããšæããçµæã ããåŸãããŸãð
1ïžâ£ æ¹æ³ 1: åèµ·åãšåºæ¬çãªãã©ãã«ã·ã¥ãŒãã£ã³ã° (æéã®ä¿®æ£)
æã«ã¯ãæãã·ã³ãã«ãªè§£æ±ºçãæåãšãªãããšããããŸããããçŽãããšã§ãOLEã¢ã¯ã·ã§ã³ãšã©ãŒã®åå ãšãªã£ãŠããäžæçãªäžå
·åãè§£æ¶ã§ããå ŽåããããŸãã
- ãã¹ãŠã®Excelã€ã³ã¹ã¿ã³ã¹ãéããPCãåèµ·åããŠãã ãããããã«ããã¡ã¢ãªãªãŒã¯ãè§£æ¶ãããŸãã
- ã¿ã¹ã¯ ãããŒãžã£ãŒ(Ctrl + Shift + Esc)ãéããæ®ã£ãŠããExcel.exeããã»ã¹ãçµäºããŸãã
- Excelãã»ãŒãã¢ãŒãã§èµ·åããŸããExcelãéãéã«CtrlããŒãæŒãããŸãŸã«ããŠã確èªããŸãããšã©ãŒãªãåäœããå Žåã¯ãã¢ãã€ã³ã«åé¡ãããå¯èœæ§ããããŸãã
ããã®ãã³ãïŒã»ãŒãã¢ãŒãã§åé¡ã解決ããå Žåã¯ãããã¡ã€ã«ã>ããªãã·ã§ã³ã>ãã¢ãã€ã³ã>ãCOMã¢ãã€ã³ã®ç®¡çã>ãå®è¡ãããã¢ãã€ã³ã1ã€ãã€ç¡å¹ã«ããçãããã¢ãã€ã³ã®ãã§ãã¯ãå€ããŠãã ãããããã§ãããã«æ·±ã調ã¹ãªããŠãåé¡ã解決ããŸãïŒ
2ïžâ£ æ¹æ³2: Office修埩ããŒã«ãå®è¡ãã
åºæ¬çãªæ¹æ³ã§åé¡ã解決ããªãå Žåã¯ãMicrosoftã®çµã¿èŸŒã¿ä¿®åŸ©æ©èœã䜿çšããŠãExcelå
ã®ç Žæãã OLE ã³ã³ããŒãã³ãã埩å
ã§ããŸãã
- [èšå®] > [ã¢ããª] > [ã€ã³ã¹ããŒã«ãããã¢ããª] ã«ç§»åãããMicrosoft Officeããæ€çŽ¢ã㊠[倿Ž] ãéžæããŸãã
- ãŸããã¯ã€ãã¯ä¿®åŸ©ããéžæããŠãã ããïŒææ°ã®ããããå¿
èŠãªå Žåã¯ãªã³ã©ã€ã³ã§ïŒãExcelãåèµ·åããŠãã¹ãããŠãã ããã
- ããã倱æããå Žåã¯ãããªã³ã©ã€ã³ä¿®åŸ©ããéžæããŠãã ãããMicrosoftãµãŒããŒããæ°ãããã¡ã€ã«ãããŠã³ããŒããããŸãã
å
¬åŒãã©ãŒã©ã ã®ãŠãŒã¶ãŒå ±åã«ãããšããã®æ¹æ³ã¯Windows 11ã®OLEã¢ã¯ã·ã§ã³ãšã©ãŒã®æå€§80%ã解決ããŸãããŸãã§ãœãããŠã§ã¢ã«ã¹ãããŒããã¬ãŒã³ããããããªãã®ã§ãïŒð
3ïžâ£ æ¹æ³3: Windows 11ãšMicrosoft OfficeãæŽæ°ãã
å€ãã·ã¹ãã ã¯ãšã©ãŒã®æž©åºãšãªããŸããOLEé¢é£ã®ãã°ãä¿®æ£ããã«ã¯ããã¹ãŠãææ°ã§ããããšã確èªããŠãã ããã
- Windows 11ãã¢ããããŒãããã«ã¯ããèšå®ã>ãWindows Updateã>ãæŽæ°ããã°ã©ã ã®ç¢ºèªãã«é²ã¿ãŸããå©çšå¯èœãªããã¯ãããã°ã€ã³ã¹ããŒã«ããŸãã
- Officeã®å ŽåïŒä»»æã®ã¢ããªãéããããã¡ã€ã«ã>ãã¢ã«ãŠã³ãã>ãæŽæ°ãªãã·ã§ã³ã>ãä»ããæŽæ°ãã«ç§»åããŸããMicrosoft 365ãŠãŒã¶ãŒã¯ææ°ã®æ©èœãèªåçã«å
¥æã§ããŸãã
- åèµ·åããŠç¢ºèªããŠãã ãããæè¿ã®ã¢ããããŒãã§ã¯ãWindows 11ã«ãããExcel OLE ã®äºææ§ã«ç¹ã«éç¹ã眮ãããŠããŸãã
ææ°ã®ç¶æ
ã«ä¿ã€ããšã§ã OLEã¢ã¯ã·ã§ã³ãšã©ãŒãä¿®æ£ãããã ãã§ãªããå
šäœçãªããã©ãŒãã³ã¹ãåäžããŸãããã£ãšå°æ¥ã®èªåãæè¬ããããšã«ãªãã§ãããïŒ
4ïžâ£ æ¹æ³ 4: ã¬ãžã¹ããªãç·šéãã (äžçŽãŠãŒã¶ãŒåã)
â ïž æ³šæ: ã¬ãžã¹ããªã¯åŒ·åãªã®ã§ããŸãã¯ããã¯ã¢ããããŠãã ãããããã¯ã Windows 11ã§èª€ã£ãŠæ§æãããŠããå¯èœæ§ã®ãã OLE åºæã®ããŒã察象ãšããŠããŸãã
- Win + RãæŒãããregeditããšå
¥åããŠEnterããŒãæŒããŸããHKEY_CLASSES_ROOT\Excel.Applicationã«ç§»åããŸãã
- ç¡å¹ãªOLEãšã³ããªïŒäŸïŒç ŽæããCLSIDå€ïŒãæ¢ããŠåé€ããŠãã ãããäžæãªå Žåã¯ããOLE Excel ã¬ãžã¹ããªä¿®æ£ããæ€çŽ¢ããŠãã ããã
- Excelãåèµ·åããŠãã ãããããäžå®ãªå Žåã¯ãæ¬¡ã®æ¹æ³ã«é²ãããå°éå®¶ã®ãµããŒããåããŠãã ããã
ããå®å
šãªä»£æ¿ææ®µãšããŠãMicrosoftã®ãµããŒããµã€ãããå
¬åŒã¬ãžã¹ããªã¯ãªãŒããŒãããŠã³ããŒãããŠãã ãããããã«ãããå€ãã®Excel OLEãšã©ãŒã解決ãããŠããŸãã
5ïžâ£ æ¹æ³ 5: Excel ã³ã³ããŒãã³ããåã€ã³ã¹ããŒã«ãŸãã¯ãªã»ãããã
æåŸã®ææ®µïŒçœçŽã®ç¶æ
ã«æ»ããOLE ã®åé¡ã解決ããªãå Žåã¯ãåã€ã³ã¹ããŒã«ããããšã§åé¡ã解決ããŸãã
- [èšå®] > [ã¢ããª] ããOffice ãã¢ã³ã€ã³ã¹ããŒã«ãã Microsoft ã®å
¬åŒãµã€ãããåã€ã³ã¹ããŒã«ããŸãã
- ãããã¯ãExcel ã®èšå®ããªã»ããããŸããExcelãéãã%appdata%\Microsoft\Excel å
ã®ãã¡ã€ã«ãåé€ããŸã (æåã«ããã¯ã¢ããããŠãã ãã)ã
- æ°ããã¯ãŒã¯ããã¯ã§ãã¹ãããŠãã ãããããã«ããããšã©ãŒã®åå ãšãªã£ãŠããåã蟌ãŸããOLEãªããžã§ã¯ããã¯ãªã¢ãããããšããããããŸãã
åã€ã³ã¹ããŒã«ãæããå¿
èŠã¯ãããŸãããåã€ã³ã¹ããŒã«ã¯ç°¡åã§ãWindows 11ã§Excel ãæé«ã®ç¶æ
ã«åŸ©å
ããŸãã
äºé²ã®ãã³ã: ãExcelãOLEã¢ã¯ã·ã§ã³ãšã©ãŒãé²ã
解決ããŸãããïŒçŽ æŽãããïŒæ¬¡ã¯ãåçºããªãããã«å¯Ÿçãè¬ããŸãããããã©ãã«ã®ãªãã³ã³ãã¥ãŒãã£ã³ã°ãå®çŸããã«ã¯ãäºé²ãéµãšãªããŸãã
| ãã³ã |
ã©ã®ããã«åœ¹ç«ã€ã |
ã¢ã¯ã·ã§ã³ |
| â 宿çãªããã¯ã¢ãã |
ãšã©ãŒã«ããããŒã¿æå€±ã鲿¢ |
OneDriveãŸãã¯å€ä»ããã©ã€ãã䜿çšãã |
| ð¡ïž ãŠã€ã«ã¹ã¹ãã£ã³ |
OLEã®åé¡ãæš¡å£ãããã«ãŠã§ã¢ãæ€åºããŸã |
Windows Defenderã§æ¯é±å®è¡ãã |
| ð äžèŠãªã¢ãã€ã³ãç¡å¹ã«ãã |
OLEã®ç«¶åãè»œæž |
Excelãªãã·ã§ã³ãæ¯æç¢ºèª |
| ðèªåæŽæ°ãªã³ |
ãã°ãç©æ¥µçã«ä¿®æ£ãã |
WindowsãšOfficeã®èšå®ã§æå¹ã«ãã |
ããããå®è£
ããããšã§ãWindows 11 ã®ã»ããã¢ãããå
ç¢ã«ä¿ã€ããšãã§ããŸããããžã¿ã«ã¯ãŒã¯ã¹ããŒã¹ã®å®æã¡ã³ããã³ã¹ãšããŠãèããã ããã
ãŸã å°ã£ãŠããïŒå©ããæ±ããã¹ãæ
ãããã®æé ã詊ããŠãWindows 11ã®ãExcelãOLEã¢ã¯ã·ã§ã³ãšã©ãŒã解決ããªãå Žåã¯ãããŒããŠã§ã¢é¢é£ïŒRAMäžè¶³ãªã©ïŒãŸãã¯ããæ·±å»ãªã·ã¹ãã ã®åé¡ã§ããå¯èœæ§ããããŸããMicrosoftãµããŒãã§åå¥ã®ãã©ãã«ã·ã¥ãŒãã£ã³ã°ãåããããæè¡ã³ãã¥ããã£ã§ãã£ããããå©çšãã ããããã£ãšããŸããããŸããïŒç²ã匷ãã¯å¿
ãå ±ãããŸãïŒð
æåŸã«ãWindows 11ã§Excel OLE ã¢ã¯ã·ã§ã³ ãšã©ãŒã«å¯ŸåŠããã®ã¯ãå¿
ãããæªå€¢ã§ã¯ãããŸããããããã®é©åãªä¿®æ£æ¹æ³ã䜿ãã°ãã¹ãã¬ããã·ãŒããã¹ã ãŒãºã«æäœã§ããããã«ãªããŸãããã²ãäžã®ã³ã¡ã³ãæ¬ã§æåè«ãå
±æããŠãã ãããããªãã«ãšã£ãŠå¹æçã ã£ãæ¹æ³ã¯äœã§ããïŒãã²äŒè©±ãç¶ãããäºãã«æé·ããŠãããŸããããð