{"id":3067,"date":"2024-08-02T11:20:30","date_gmt":"2024-08-02T11:20:30","guid":{"rendered":"https:\/\/howtogeek.blog\/da\/?p=3067"},"modified":"2024-08-02T11:20:30","modified_gmt":"2024-08-02T11:20:30","slug":"how-to-fix-there-isnt-enough-memory-to-complete-this-action-error-in-excel-da","status":"publish","type":"post","link":"https:\/\/howtogeek.blog\/da\/how-to-fix-there-isnt-enough-memory-to-complete-this-action-error-in-excel-da\/","title":{"rendered":"S\u00e5dan rettes fejlen &#8216;Der er ikke nok hukommelse til at fuldf\u00f8re denne handling&#8217; i Excel"},"content":{"rendered":"<h2 id=\"solution-1-change-dynamic-data-exchange-settings\">L\u00f8sning 1: Skift indstillinger for dynamisk dataudveksling<\/h2>\n<p>Indstillingen Dynamic Data Exchange (DDE) i Excel lader andre apps opdatere data i dine regneark, men de kan nogle gange f\u00e5 programmet til at l\u00f8be t\u00f8r for hukommelse. For at forhindre det, kan du deaktivere det.<\/p>\n<ul>\n<li>\u00c5bn Excel og klik p\u00e5 &#8216;Indstillinger&#8217; nederst til venstre.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"524\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/08\/Screenshot-2024-08-01-113452-1.webp\" title=\"\" width=\"932\"\/><\/figure>\n<ul>\n<li>N\u00e5r vinduet Indstillinger \u00e5bnes, skal du klikke p\u00e5 fanen &#8216;Avanceret&#8217; til venstre.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"538\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/08\/Screenshot-2024-08-01-113646-1.webp\" title=\"\" width=\"956\"\/><\/figure>\n<ul>\n<li>Rul nu ned til sektionen &#8216;Generelt&#8217;, klik p\u00e5 &#8216;Ignorer andre applikationer, der bruger Dynamic Data Exchange (DDE)&#8217; og fjern markeringen. Klik derefter p\u00e5 knappen &#8216;OK&#8217;.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"547\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/08\/Screenshot-2024-08-01-114022-1.webp\" title=\"\" width=\"972\"\/><\/figure>\n<h2 id=\"solution-2-clear-excel-appdata\">L\u00f8sning 2: Ryd Excel AppData<\/h2>\n<p>Nogle gange kan midlertidige filer og konfigurationsfiler f\u00e5 Excel til at vise dig &#8216;ikke nok hukommelse til at fuldf\u00f8re denne handlingsfejl&#8217;. Du kan pr\u00f8ve at rydde Excels AppData-mappe for at l\u00f8se problemet.<\/p>\n<ul>\n<li>Brug <code>Win + R<\/code>genvejen til at \u00e5bne dialogboksen &#8216;K\u00f8r&#8217;. Inds\u00e6t derefter f\u00f8lgende <code>%appdata%\\Microsoft\\Excel\\<\/code>i det, og klik p\u00e5 knappen &#8216;OK&#8217;.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"467\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/08\/Screenshot-2024-08-01-115116-1.webp\" title=\"\" width=\"830\"\/><\/figure>\n<ul>\n<li>Et nyt File Explorer-vindue \u00e5bnes. Hvis den indeholder filer og mapper, skal du v\u00e6lge dem alle og derefter slette dem. Du kan bruge <code>Ctrl + A<\/code>genvejen til at v\u00e6lge alt p\u00e5 \u00e9n gang og slette det, s\u00e5 mappen er helt tom.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"536\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/08\/Screenshot-2024-08-01-121339-1.webp\" title=\"\" width=\"952\"\/><\/figure>\n<h2 id=\"solution-3-open-excel-in-safe-mode\">L\u00f8sning 3: \u00c5bn Excel i fejlsikret tilstand<\/h2>\n<p>Tilf\u00f8jelsesprogrammer kan nogle gange ikke fungere og f\u00e5 Excel til at vise dig fejlen &#8216;Der er ikke nok hukommelse til at fuldf\u00f8re denne handling&#8217;. Pr\u00f8v at k\u00f8re programmet i fejlsikret tilstand og se, om det er \u00e5rsagen til problemet.<\/p>\n<ul>\n<li>Brug <code>Win + R<\/code>genvejen til at \u00e5bne dialogboksen K\u00f8r, skriv <code>excel -safe<\/code>i boksen, og tryk p\u00e5 &#8216;Enter&#8217; eller klik p\u00e5 &#8216;OK&#8217;-knappen.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"525\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/08\/Screenshot-2024-08-01-123305-1.webp\" title=\"\" width=\"933\"\/><\/figure>\n<ul>\n<li>Dette vil starte Excel i fejlsikret tilstand, og du kan se &#8216;Sikker tilstand&#8217; \u00f8verst. Hvis det ikke viser nogen fejl, skal du deaktivere dine tilf\u00f8jelser og derefter aktivere dem \u00e9n efter \u00e9n for at identificere, hvilken der for\u00e5rsager problemet.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"583\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/08\/Screenshot-2024-08-01-124001-1.webp\" title=\"\" width=\"926\"\/><\/figure>\n<ul>\n<li>I Excel skal du klikke p\u00e5 menuen Filer \u00f8verst til venstre.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"444\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/08\/Screenshot-2024-08-01-124255-1.webp\" title=\"\" width=\"789\"\/><\/figure>\n<ul>\n<li>Klik derefter p\u00e5 &#8216;Indstillinger&#8217; nederst til venstre.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"469\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/08\/Screenshot-2024-08-01-124533-1.webp\" title=\"\" width=\"833\"\/><\/figure>\n<ul>\n<li>I vinduet Indstillinger skal du klikke p\u00e5 &#8216;Tilf\u00f8jelser&#8217; til venstre.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"528\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/08\/Screenshot-2024-08-01-124959-1.webp\" title=\"\" width=\"939\"\/><\/figure>\n<ul>\n<li>Klik p\u00e5 rullemenuen &#8216;Administrer&#8217; nederst, og klik derefter p\u00e5 COM-tilf\u00f8jelser. Med COM-tilf\u00f8jelsesprogrammer valgt, klik p\u00e5 &#8216;Go&#8217;-knappen.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"487\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/08\/Screenshot-2024-08-01-125204-1.webp\" title=\"\" width=\"866\"\/><\/figure>\n<ul>\n<li>I den boks, der vises, skal du klikke p\u00e5 hvert af afkrydsningsfelterne for at deaktivere dem, f\u00f8r du klikker p\u00e5 knappen &#8216;OK&#8217;.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"473\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/08\/Screenshot-2024-08-01-125725-1.webp\" title=\"\" width=\"841\"\/><\/figure>\n<ul>\n<li>N\u00e5r du har deaktiveret tilf\u00f8jelsesprogrammerne, skal du lukke Excel og \u00e5bne det igen. G\u00e5 derefter til tilf\u00f8jelsesprogrammerne og aktiver dem \u00e9n efter \u00e9n, indtil du f\u00e5r fejlen. N\u00e5r fejlen vises, kan du deaktivere og fjerne tilf\u00f8jelsesprogrammet, der for\u00e5rsager det.<\/li>\n<\/ul>\n<h2 id=\"solution-4-run-the-office-repair-tool\">L\u00f8sning 4: K\u00f8r Office-reparationsv\u00e6rkt\u00f8jet<\/h2>\n<p>Office-reparationsv\u00e6rkt\u00f8jet kan hj\u00e6lpe med at diagnosticere og l\u00f8se problemer med programmer som Office-programmer.<\/p>\n<ul>\n<li>\u00c5bn dialogboksen K\u00f8r med <code>Win + R<\/code>genvejen, skriv <code>appwiz.cpl<\/code>og klik p\u00e5 OK.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"455\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/08\/Screenshot-2024-08-01-130844-1.webp\" title=\"\" width=\"808\"\/><\/figure>\n<ul>\n<li>Dette vil vise dig listen over programmer, der er installeret p\u00e5 din pc. Klik p\u00e5 Microsoft Office og derefter p\u00e5 knappen &#8216;Skift&#8217; \u00f8verst.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"492\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/08\/Screenshot-2024-08-01-131148-1-1-1.webp\" title=\"\" width=\"874\"\/><\/figure>\n<ul>\n<li>I pop op-vinduet, der vises, skal du klikke p\u00e5 &#8216;Reparer online&#8217; for at v\u00e6lge det. Klik derefter p\u00e5 knappen Reparer.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"514\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/08\/Screenshot-2024-08-01-131417-1-1.webp\" title=\"\" width=\"914\"\/><\/figure>\n<ul>\n<li>N\u00e5r processen er f\u00e6rdig, skal du starte Excel igen og se, om problemet er l\u00f8st.<\/li>\n<\/ul>\n<h2 id=\"solution-5-enable-manual-calculation-mode\">L\u00f8sning 5: Aktiver manuel beregningstilstand<\/h2>\n<p>Hvis din Excel-fil indeholder flere regneark eller har mange formler, kan skift fra automatisk til manuel beregning hj\u00e6lpe med at l\u00f8se problemet.<\/p>\n<ul>\n<li>\u00c5bn dialogboksen Indstillinger fra menuen Filer i Excel som forklaret ovenfor.<\/li>\n<li>I dialogboksen Indstillinger skal du klikke p\u00e5 &#8216;Formler&#8217; til venstre. Under &#8216;Beregningsindstillinger&#8217; skal du klikke p\u00e5 &#8216;Manuel&#8217; mulighed for regnebogsberegning. Klik p\u00e5 &#8216;OK&#8217; og genstart Excel for at \u00e6ndringerne tr\u00e6der i kraft.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"496\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/08\/Screenshot-2024-08-01-133435-2-1.webp\" title=\"\" width=\"881\"\/><\/figure>\n<h2 id=\"solution-6-change-larger-files-to-smaller-ones\">L\u00f8sning 6: Skift st\u00f8rre filer til mindre<\/h2>\n<p>Du kan pr\u00f8ve at flytte nogle regneark fra st\u00f8rre filer til mindre for at g\u00f8re dem nemmere for Excel at h\u00e5ndtere.<\/p>\n<ul>\n<li>H\u00f8jreklik p\u00e5 den regnearksfane, du vil flytte, og klik derefter p\u00e5 &#8216;Flyt eller kopier&#8217;.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"457\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/08\/Screenshot-2024-08-01-134400-1.webp\" title=\"\" width=\"812\"\/><\/figure>\n<ul>\n<li>Klik p\u00e5 rullemenuen &#8216;Til bog&#8217; og klik derefter p\u00e5 &#8216;Ny bog&#8217;. Kontroller, at indstillingen &#8216;Opret en kopi&#8217; nederst ikke er aktiveret, og klik derefter p\u00e5 knappen &#8216;OK&#8217;.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"460\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/08\/Screenshot-2024-08-01-134641-1-1.webp\" title=\"\" width=\"817\"\/><\/figure>\n<ul>\n<li>Gem den nye projektmappe med et andet navn, og gentag derefter processen for andre st\u00f8rre filer.<\/li>\n<\/ul>\n<h2 id=\"solution-7-ensure-excel-is-updated\">L\u00f8sning 7: S\u00f8rg for, at Excel er opdateret<\/h2>\n<p>Opdateringer kan rette fejl som &#8220;ikke nok hukommelse til at fuldf\u00f8re denne handling&#8221;, s\u00e5 du b\u00f8r kontrollere, om de seneste Excel-opdateringer er installeret.<\/p>\n<ul>\n<li>Klik p\u00e5 menuen Filer \u00f8verst til venstre og derefter p\u00e5 &#8220;Konto&#8221; til venstre.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"444\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/08\/Screenshot-2024-08-01-135149-1.webp\" title=\"\" width=\"789\"\/><\/figure>\n<ul>\n<li>P\u00e5 kontosiden skal du klikke p\u00e5 knappen &#8216;Opdater indstillinger&#8217; til h\u00f8jre og derefter p\u00e5 &#8216;Opdater nu&#8217; i de indstillinger, der vises.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\" class=\"wp-image\" decoding=\"async\" height=\"467\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/08\/Screenshot-2024-08-01-141002-1.webp\" title=\"\" width=\"830\"\/><\/figure>\n<ul>\n<li>Hvis opdateringer er tilg\u00e6ngelige, installerer Excel dem automatisk. Vent, indtil de er installeret, og pr\u00f8v derefter at bruge det igen.<\/li>\n<\/ul>\n<h2 id=\"solution-8-turn-off-graphics-acceleration\">L\u00f8sning 8: Sl\u00e5 grafikacceleration fra<\/h2>\n<p>Grafikacceleration kr\u00e6ver meget hukommelse og kan for\u00e5rsage problemer, n\u00e5r du k\u00f8rer Excel. F\u00f8lg disse trin for at sl\u00e5 det fra.<\/p>\n<ul>\n<li>\u00c5bn dialogboksen Indstillinger i Excel, og klik p\u00e5 fanen &#8216;Avanceret&#8217; til venstre.<\/li>\n<li>Rul derefter ned til sektionen &#8216;Vis&#8217; og klik p\u00e5 &#8216;Deaktiver hardwaregrafikacceleration&#8217;. Klik p\u00e5 knappen &#8216;OK&#8217; og genstart Excel.<\/li>\n<\/ul>\n<h2 id=\"solution-9-upgrade-your-ram\">L\u00f8sning 9: Opgrader din RAM<\/h2>\n<p>Programmer som Excel kr\u00e6ver i stigende grad mere og mere hukommelse. Hvis ovenst\u00e5ende l\u00f8sninger ikke hj\u00e6lper dig, kan du overveje at opgradere din computers RAM.<\/p>\n<h3 id=\"things-to-know\">Ting at vide<\/h3>\n<ul>\n<li>Udover ovenst\u00e5ende l\u00f8sninger kan du pr\u00f8ve at deaktivere dit antivirusprogram midlertidigt og k\u00f8re Excel for at kontrollere, om problemet stadig opst\u00e5r. Hvis det ikke g\u00f8r det, forstyrrer dit antivirus dets funktion, og du b\u00f8r overveje at \u00e6ndre det.<\/li>\n<li>Det er ogs\u00e5 en god id\u00e9 at lukke alle andre programmer og applikationer, n\u00e5r du k\u00f8rer Excel for at frig\u00f8re den maksimale m\u00e6ngde hukommelse, der er mulig for Excel.<\/li>\n<li>Hvis du bruger brugerdefinerede visninger i Excel, kan du pr\u00f8ve at slette dem fra menuen &#8216;Vis&#8217; \u00f8verst og se, om det hj\u00e6lper.<\/li>\n<li>Almindelige rettelser som opdatering af Windows og geninstallation af Office kan v\u00e6re et fors\u00f8g v\u00e6rd, f\u00f8r du beslutter dig for at opgradere din pc&#8217;s RAM.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>L\u00f8sning 1: Skift indstillinger for dynamisk dataudveksling Indstillingen Dynamic Data Exchange (DDE) i Excel lader andre apps opdatere data i dine regneark, men de kan nogle gange f\u00e5 programmet til at l\u00f8be t\u00f8r for hukommelse. For at forhindre det, kan du deaktivere det. \u00c5bn Excel og klik p\u00e5 &#8216;Indstillinger&#8217; nederst til venstre. N\u00e5r vinduet Indstillinger [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[64,130,286],"class_list":["post-3067","post","type-post","status-publish","format-standard","hentry","category-how-to","tag-apps","tag-microsoft","tag-microsoft-excel"],"acf":[],"_links":{"self":[{"href":"https:\/\/howtogeek.blog\/da\/wp-json\/wp\/v2\/posts\/3067","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/howtogeek.blog\/da\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/howtogeek.blog\/da\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/da\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/da\/wp-json\/wp\/v2\/comments?post=3067"}],"version-history":[{"count":1,"href":"https:\/\/howtogeek.blog\/da\/wp-json\/wp\/v2\/posts\/3067\/revisions"}],"predecessor-version":[{"id":3068,"href":"https:\/\/howtogeek.blog\/da\/wp-json\/wp\/v2\/posts\/3067\/revisions\/3068"}],"wp:attachment":[{"href":"https:\/\/howtogeek.blog\/da\/wp-json\/wp\/v2\/media?parent=3067"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howtogeek.blog\/da\/wp-json\/wp\/v2\/categories?post=3067"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howtogeek.blog\/da\/wp-json\/wp\/v2\/tags?post=3067"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}