Opravy alebo alternatívne riešenia nedávnych problémov v Exceli pre Windows

Opravy alebo alternatívne riešenia nedávnych problémov v Exceli pre Windows

Posledná aktualizácia: 13. októbra 2017

Zlyhanie a pomalý výkon v Exceli

Last updated: October 11, 2017

ISSUE

If you use a button in a worksheet to start a macro and later close this workbook, subsequent attempts to calculate user-defined functions provided by an XLL add-in might crash.

This issue impacts Excel 2016 in Version 1608 (Build 7301.xxxx).

STATUS: FIXED

This issue is now fixed in Version 1708 (8431.2017). To get the update immediately, open any Office 2016 app and choose File > Account > Update Options > Update Now.

Last updated: Sep 18, 2017

ISSUE

You may experience Excel freezing or crashing after attempting to publish a workbook as a web page using File > Save As > Browse > Save as Type: Web Page (*htm, *.html).

This issue impacts Excel 2016 in Version 1707 (Build 8326.xxxx).

STATUS: FIXED

This issue is now fixed in Version 1708 (8431.2079). To get the update immediately, open any Office 2016 app and choose File > Account > Update Options > Update Now.

Last updated: August 11, 2017

ISSUE

When using Excel for Windows, you may experience intermittent crashing when connecting to or updating data from SQL Server Analysis Services. For example, Excel might crash when you try to refresh a PivotTable with data from an Analysis Services server or OLAP cubes.

This issue only impacts Excel for Windows Version 1707 (8326.20xx).

STATUS: FIXED

This issue is now fixed in Version 1707 (8326.2073). To get the update immediately, open any Office 2016 app and choose File > Account > Update Options > Update.

Last updated: September 6, 2017

ISSUE

When opening a file in Office that contains a Common Control, you may encounter one of two errors:

  • Where a file is opened containing a Common Control that uses a tooltip, the Office application may crash.

  • Where a file is opened containing a Common Control, users may get messaging related to a missing license.

This issue impacts Office Version 1707 (Build 8326.2058) installed on either a 32-bit or 64-bit Windows OS.

STATUS: FIXED

A fix for this issue is currently rolling out to customers in Office Version 1707 (Build 8326.2087). To update Office, go to File > Account > Update Options >Update Now.

Last updated: June 7, 2017

ISSUE

After updating Office, you may experience a brief flashing window every hour, which triggers the OfficeBackgroundHandlerRegistration task to start running.

STATUS: FIXED

This issue is now fixed in Version 1705 (Build 8201.2075). To get the update Office, open any Office 2016 app and choose File > Account > Update Options > Update.

Problémy týkajúce sa funkcií a doplnkov Excelu

Posledná aktualizácia: 13. októbra 2017

PROBLÉM

Ak používate skúšobnú verziu služieb Office 365, pri každom otvorení súboru balíka Office sa automaticky nastaví ako predvolená aplikácia pre Word, Excel alebo PowerPoint vo všetkých verziách Windowsu najnovšia verzia. Ak máte napríklad nainštalovaný Excel 2013 a tiež používate skúšobnú verziu služieb Office 365, zošit sa otvorí v Exceli 2016.

STAV: ALTERNATÍVNE RIEŠENIE

Odporúčame vám používať Office 365, kde máte najnovšie funkcie. Skúšobnú verziu však môžete odinštalovať a súbory sa otvoria v tej verzii Excelu, ktorú máte nainštalovanú.

Posledná aktualizácia: 11. októbra 2017

PROBLÉM

Pri otvorení súboru v Exceli 2016, ktorý obsahuje v tej istej bunke viaceré typy formátovania textu, sa môže formátovanie odstrániť. Môžete mať napríklad časť textu vo formáte RTF tučným písmom a inú časť v rámci tej istej bunky, ktorá nebude tučným písmom. Alebo máte v rámci tej istej bunky rozličné farby písma pre rozličné znaky, ako je to na príklade nižšie.

Používanie písma vo formáte RTF vo viacerých typoch formátovania textu

STAV: ALTERNATÍVNE RIEŠENIE

Náš tím odborníkov momentálne pracuje na oprave. Zatiaľ môžete použiť toto alternatívne riešenie:

  • Ak je to možné, použite v bunkách, kde potrebujete mať viaceré typy formátovania, iné písmo (nie RTF).

  • Nepoužívajte viacero typov formátovania písma v rámci tej istej bunky.

Posledná aktualizácia: 11. októbra 2017

PROBLÉM

Pri použití klávesovej skratky Ctrl + H alebo tlačidla Nahradiť na páse s nástrojmi zobrazí dialógové okno Hľadanie a nahradenie namiesto karty Nahradiť kartu Nájsť. Tento problém sa týka verzie 1708 (zostava 8420.xxxx).

Príkaz Nahradiť na páse s nástrojmi

STAV: OPRAVENÉ

Tento problém je vyriešený vo verzii 1708 (8431.2094). Ak chcete okamžite získať aktualizáciu, otvorte ľubovoľnú aplikáciu balíka Office 2016 a vyberte položky Súbor > Konto > Možnosti aktualizácie > Aktualizovať.

Last updated: September 29, 2017

ISSUE

When in Page Layout view, applying a fill formatting such as a pattern style to a cell or table does not render correctly after adding a header or a footer to the spreadsheet. You may see a black background or other formatting issues.

This issue impacts Version 1708 (Build 8431.2079).

STATUS: FIXED

This issue is now fixed in Version 1708 (Build 8431.2094). To get the update immediately, open any Office 2016 app and choose File > Account > Update Options > Update Now.

Last updated: September 22, 2017

ISSUE

You receive an error when saving a workbook after inserting a chart in an existing workbook (previously saved) or copying values from an existing workbook.

Errors were detected while saving <workbook name>. Microsoft Excel may be able to save the file by removing or repairing some features. To make repairs in a new file, click Continue. To cancel saving the file, click Cancel.

If you click Continue, you get the following error:

Excel encountered errors during save. However, Excel was able to minimally save your file to <file name>.

This issue impacts build Version 1707 (Build 8326.2086) and later, and also only occurs with files that are stored locally, such as on the desktop. This problem does not occur if you manually enter values or insert a chart in a newly created workbook.

STATUS: WORKAROUND

Our engineering team is working on a fix. In the meantime, you can do the following as a workaround:

  1. Change the number format referred to in the chart in the workbook to Custom.

  2. Under Additional Regional Settings, change the Format Setting to English (U.S.). Afterwards, you should be able to save, even after you change your regional settings back to their original place.

Last updated: September 29, 2017

ISSUE

AutoSave is no longer available or appearing in the Office toolbar in Office 2016 Version 1707 (Build 8326.2058) or higher.

STATUS: PARTIALLY FIXED

For Excel: This issue is now fixed in Version 1708 (Build 8431.2094). To get the update immediately, open any Office 2016 app and choose File > Account > Update Options > Update Now.

For Word: We are working on a releasing the fix soon. Thanks for your patience.

Last updated: September 29, 2017

ISSUE

After opening a file saved in OneDrive, OneDrive for Business, or SharePoint that is synced using a sync client, you may experience that the AutoSave is incorrectly disabled or greyed out. Hovering over the AutoSave toggle, the tool tip will prompt you with the following message:

AutoSave Not Available. This file location doesn't support AutoSave. Save to OneDrive or SharePoint Online if you want to use AutoSave.

Oznámenie Automatické ukladanie nie je k dispozícii

This issue impacts the Office 2016 August 2017 update, Version 1708 (Build 8431.2079) and later.

STATUS: FIXED

This issue is now fixed in Version 1708 (Build 8431.2094). To get the update immediately, open any Office 2016 app and choose File > Account > Update Options > Update Now.

If you are continuing to experience or have not updated yet, you can use the following workaround:

  • Open the Office app, click on File > Open and navigate to the server location (OneDrive or SharePoint).

  • Using a web browser, open the file directly from SharePoint or OneDrive where the file is stored.

Last updated: Sep 14, 2017

ISSUE

After installing the September 12, 2017 update for Excel 2016 (KB4011050), dark borders may appear around rows or cells in Excel spreadsheets when you enter text.

Tmavé orámovanie okolo buniek počas písania po inštalácii verzie KB4011050

STATUS: FIXED

This issue is now fixed in the KB4011165 update, released on September 12, 2017. If you have KB 4011050 installed, you do not need to uninstall this before installing KB4011165.

Last updated: September 18, 2017

ISSUE

When using Office 2016 apps and opening, editing, or saving Word files stored in OneDrive, you may be prompted to login with the following message: "Tell us the account you want to open _vti_rpc."

Výzva na prihlásenie, ktorým sa otvorí _vti_rpc

STATUS: FIXED

This issue is now fixed in Version 1708 (8431.2079). To get the update immediately, open any Office 2016 app and choose File > Account > Update Options > Update Now.

Last updated: August 16, 2017

ISSUE

When opening Office 2016 files, you may experience files are opening as read-only unexpectedly. This issue most commonly impacts Excel and Word in Version 1706 (Build 8229.2045) or later. Sometimes this issue manifests after you attempt to sync a document that requires check-in on OneDrive. Upon opening the file in Word or Excel, the file opens as read only.

STATUS: WORKAROUND

Our engineering team is actively fixing this issue. In the meantime, please refer to this article for workaround.

Need more help troubleshooting? Talk to support.

If you have an Office 365 for home subscription, or you purchased a one-time download of Office 2016, click the Contact Us button at the bottom of this page.

If you are an admin for Office 365 for business subscription, contact Office 365 for business support.

Last updated: August 28, 2017

ISSUE

After updating to the August 1, 2017 update for Office 2016 (KB 4011051), clicking a hyperlink in an Excel workbook that points to another Excel workbook no longer works and you might receive a hyperlink warning message. You may also experience issues accessing WMI programmatically from Excel and Word.

STATUS: FIXED

This issue is now fixed. Please manually install the August 22, 2017 update for Office 2016 (KB 4011093). This KB 4011093 will be available as an automatic update and for those using Windows Server Update Services (WSUS) in the next monthly update for Office.

Last updated: September 27, 2017

ISSUE

When inserting an icon or a picture via Insert > Icons or Insert > Pictures, you receive the following error message:

An error occurred while importing this file. http://hubblecontent.osi.office.net/ContentSVC/Content/Download?provider=MicrosoftIcon&FileName=[icon].svg

STATUS: WORKAROUND

As a workaround you can do the following:

  1. Open Internet Explorer.

  2. Click on the Settings icon and then click Internet Options.

  3. Choose the Advanced tab and then find the Security section.

  4. Uncheck the option Do not save encrypted pages to disk.

Last updated: July 25, 2017

ISSUE

After updating Office, When using CreateObject(“Scriptlet.TypeLib”).GUID in Visual Basic for Applications in an Office application, you get this error: “Run-time error ‘70’ Permission denied”. To help prevent malicious code from running in Office applications this control is blocked as a security measure.

STATUS: BY DESIGN/WORKAROUND

There are a couple options for working around this security change. Please reference this forum post for details.

Last updated: September 14, 2017

ISSUE

When using Excel 2016, the AutoFilter drop-down is not showing all available checkboxes. This happens when the number of rows exceeds 10,000. Other symptoms may occur as well. For example, the checkboxes may not be clickable, or the filtered result may not return expected results.

STATUS: FIXED

This issue is now fixed in Version 1707 (8326.2073) or later. To get the update immediately, open Excel and choose File > Account > Update Options > Update Now.

Last updated: July 20, 2017

ISSUE

After updating Office, if you launch the Ribbon or the Quick Access Toolbar customization dialogs, the dialog might not show any commands available. For example, the list of “Popular Commands” or “Commands Not in the Ribbon” may be empty.

STATUS: FIXED

This issue is fixed in Version 1706 (Build 8229.2103) for production customers. To update Office, open any Office 2016 app and choose File > Account > Update Options > Update.

The previous workaround for this issue for the Quick Access Toolbar (or if the fix hasn't rolled out to your Insider ring yet): type the name of the command in the Tell Me box (keyboard shortcut Alt+Q), then right-click the command and select “Add to Quick Access Toolbar”.

Last updated: June 21, 2017

ISSUE

Can’t set password programmatically for sheet protection in older files, in Excel for Win32 Office 365

STATUS: FIXED

In builds 16.0.8067.2115 and later (production), and 16.0.8201.2064 and later (Insiders), there is an issue with setting sheet protection with a password programmatically. In this scenario, the password will not be applied. The issue only affects files created in Excel 2010 or prior, when sheet protection with a password is turned on programmatically. This means, for example, using Sheet1.Protect “password”. It will not occur when sheet protection is enabled through the user interface. This will not happen in any files created in Excel 2013 or later. Some users may experience that sheet protection can be switched off without providing a password.

This issue has been fixed in builds 16.0.8201.2102 and later.

Potrebujete ďalšiu pomoc?

Zavolajte na oddelenie podpory

Obráťte sa na oddelenie podpory
Ak máte predplatné na Office 365 pre domácnosti alebo ste si kúpili jednorazové stiahnutie balíka Office 2016, kliknite na tlačidlo Kontaktujte nás v dolnej časti tejto stránky.
Ak ste správcom predplatného na Office 365 pre podniky, obráťte sa na oddelenie podpory služieb Office 365 pre podniky.

Fóra komunity používateľov služieb Office 365

Opýtajte sa komunity
Požiadajte o pomoc odborníkov v našich fórach:
Fórum používateľov balíka Office vo Windowse pre používateľov verzií Personal, Home alebo University
Fórum komunity používateľov služieb Office 365 pre podnikových používateľov

Chat

Poskytnite pripomienky v aplikácii balíka Office
Pripomienky môžete odoslať priamo našim tímom balíka Office:

Office 2016 vo Windowse 10 otvorte aplikáciu balíka Office a kliknite na položky Súbor > Pripomienky.

Máte požiadavku na funkciu?

Žiarovka – nápad

Radi si prečítame vaše návrhy na nové funkcie a pripomienky týkajúce sa používania našich produktov. Zdieľajte svoje nápady na lokalite Excel UserVoice. Váš názor nás zaujíma.

Rozšírte svoje zručnosti
Preskúmať školenie
Buďte medzi prvými, ktorí získajú nové funkcie
Pridajte sa k insiderom pre Office

Boli tieto informácie užitočné?

Ďakujeme za vaše pripomienky!

Ďakujeme vám za pripomienky. Pravdepodobne vám pomôže, ak vás spojíme s pracovníkom podpory pre Office.

×