- Microsoft Excel 4.0
- Microsoft Excel 4.0 Worksheet
- Microsoft Excel 4.0 For Mac
- Microsoft Excel 400 Error
Connection to Excel .XLS data sources fails when using Microsoft Jet 4.0 OLE DB Provider
Article ID: 293 - Updated: Nov 21, 2018 - Version: Any - Category: Fixed Issues
This article describes the formula syntax and usage of the CUMPRINC function in Microsoft Excel. Returns the cumulative principal paid on a loan between startperiod and endperiod. CUMPRINC(rate, nper, pv, startperiod, endperiod, type). (A2/12,A3.12,A4,13,24,0) The total principal paid in the second year of payments. Microsoft Excel 4.x Excel, from Microsoft, is a powerful spreadsheet application for Mac, Windows, and OS/2. Excel was first released for the Mac. When it was ported to Windows 2.x, they started at version '2.0' to one up current Mac version. Microsoft Excel 4.0 for Windows 1992 NEW OLD STOCK NIB. $19.99 + $6.52 shipping. Rare Vintage Macintosh Microsoft Word software Version 4.0 or 3.0? Check out the HKEYLOCALMACHINESOFTWAREMicrosoftJet4.0EnginesExcel located registry REGDWORD 'TypeGuessRows'. That's the key to not letting Excel use only the first 8 rows to guess the columns data type. Set this value to 0 to scan all rows. This might hurt performance.
Microsoft Excel 4.0
Problem
When you use NiceLabel to connect to Excel .XLS type of data files, NiceLabel will use database driver 'Microsoft Jet 4.0 OLE DB Provider' by default. After October 10, 2017, you might not be able to connect to such data sources anymore.
NOTE: Connection to .XLSX type of Excel file is unaffected.
The following would happen in NiceLabel software:
- NiceLabel V2017. You would see the system error message 'Unexpected error from external database driver (1).'
- NiceLabel V6. You would see the 'Database Login' dialog box, prompting you for the user name and password.
Windows updates from October 10, 2017 were the culprit for this problem.
Microsoft Excel 4.0 Worksheet
Solution
THE SOLUTIONMicrosoft has published known issues for the October 10th Windows update. Read this document.
The problem is solved with .NET Framework November 2017 Security and Quality Rollup released on November 14 with the following updates. We recommend that you update your Windows system with the latest updates.
NOTE: Connection to .XLSX type of Excel file is unaffected.
The following would happen in NiceLabel software:
- NiceLabel V2017. You would see the system error message 'Unexpected error from external database driver (1).'
- NiceLabel V6. You would see the 'Database Login' dialog box, prompting you for the user name and password.
Windows updates from October 10, 2017 were the culprit for this problem.
Microsoft Excel 4.0 Worksheet
Solution
THE SOLUTIONMicrosoft has published known issues for the October 10th Windows update. Read this document.
The problem is solved with .NET Framework November 2017 Security and Quality Rollup released on November 14 with the following updates. We recommend that you update your Windows system with the latest updates.
- Windows 10 Version 1709: KB4048955
- Windows 10 Version 1703: KB4048954
- Windows 10 Version 1607 and Windows Server 2016: KB4048953
- Windows 10 Version 1511: KB4048952 (for Windows 10 Enterprise and Windows 10 Education editions only), KB4052232
- Windows 10 Version (initial version released July 2015): KB4048956
- Windows 8.1 and Windows Server 2012 R2: KB4048958 (Monthly Rollup), KB4048961 (Security-only update)
- Windows Server 2012: KB4048962
- Windows 7 and Windows Server 2008 R2: KB4048957 (Monthly Rollup), KB4048960 (Security-only update)
If you cannot update the system with the November 14 updates just yet, the following workarounds are available.
WORKAROUND 1This workaround is applicable in NiceLabel V2017 and NiceLabel V6.
Remove the Windows update that causes the problem. Find the update id for your Windows system in the list below and remove it.
Microsoft Excel 4.0 For Mac
- Windows 10 1703: KB4041676
- Windows 10 1607 and Windows Server 2016: KB4041691
- Windows 10 1507: KB4042895
- Windows 8.1 and Windows Server 2012 R2: KB4041693
- Windows Server 2012: KB4041690
- Windows 7 and Windows Server 2008 R2: KB4041681, KB4041678 and KB4041686.
To remove the update, do the following:
- Open Control Panel.
- Navigate to Programs and Features>Installed Updates.
- Find the update with the KB number in its description.
- Click Uninstall.
Then make sure to temporary disable automatic updates, or Windows will install the update again at next update check. If you do now know how to change the update mode, read this article for details.
Microsoft Excel 400 Error
WORKAROUND 2This workaround is applicable only in NiceLabel V2017.
NiceLabel 2017.3 has been released on October 27, 2017. NiceLabel 2017.3 will use ACE provider to connect to .XLS Excel data sources, even if you have initially configured JET provider on the labels. The switch happens automatically in the background, when you open a label. ACE provider is backwards compatible with JET provider, so there will be no issues making the switch.
NiceLabel 2017.3 will use ACE provider also for each new .XLS Excel file that you will use on the label. If ACE provider is not available, NiceLabel 2017.3 will downgrade to JET provider.
The ACE provider is installed with Microsoft Office products, but can also be installed separately, if needed (you can download it from Microsoft). You can install either 32-bit or 64-bit ACE provider, NiceLabel 2017 will use the one you have installed.
To upgrade your NiceLabel 2017 to 2017.3 release, download the trial installer here and install new version on top of the existing one, overwriting it, but keeping all settings and preferences.
If you cannot upgrade to NiceLabel 2017.3 (from one reason or another), you can change the data provider yourself. Change the provider from 'Microsoft Jet 4.0 OLE DB Provider' (JET) to 'Microsoft Office XX.0 Access Database engine OLE DB Provider' (ACE) (XX represents a version number of your database provider). You will have to do it for each label separately.
Print documentEmail document
