Daily Dose of Excel - Daily posts of Excel tips…and other stuff
Ron's Excel Page

MSDN - Office 2003 - VBA Language Reference:

• Excel VBA Reference
  
• Word VBA Reference
  

Branders.name - Excel Function Reference bevat link naar downloadbare pdf met NL en EN namen voor functies binnen Excel.

Excel Memory Limits
Excel’s Smart Recalculation Engine

Kies voor opslaan, klik op Extra→Algemene Opties…→vinkje bij “Alleen-lezen aanbevolen”

archive.org - Microsoft Support - How to use Excel startup folders in Excel 2002
Microsoft Support - Customize how Excel starts
Microsoft Support - Automatically open a specific workbook or template when you start Excel

Via registry:

Windows Registry Editor Version 5.00

// For Excel 2007
[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security]
"ExtensionHardening"=dword:00000000

// For Excel 2010
[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Security]
"ExtensionHardening"=dword:00000000

Via Group Policy: User Configuration\Policies\Administrative Templates\Microsoft Excel 2007\Excel Options\Security
Force file extension to match file type: Enabled, Allow different

User Configuration\Policies\Administrative Templates\Microsoft Excel 2010\Excel Options\Security
Force file extension to match file type: Enabled, Allow different

Sources:
Like a Cheese and Tech Sandwich Without the Cheese or Bread - "The file you are trying to open, '[filename]', is in a different format" Excel Error
MSDN Blogs > VSOfficeDeveloper: Known Problems, Bugs, and Fixes > Excel 2007 Extension Warning On Opening Excel Workbook from a Web Site

Om in een sheet het aantal regels te tellen waarbij in Kolom A, B, C, enz. bepaalde waarden voorkomen kun je SUMPRODUCT gebruiken.

Voorbeeld:

Om uit de deze tabel alle virtuele Server 2003 Standard installaties die in productie staan te selecteren:

=SOMPRODUCT(--(Servers!G2:G6="Virtueel");--(Servers!H2:H6="Productie");--(Servers!B2:B6="Server 2003");--(Servers!C2:C6="Standard"))

Bron:Contextures - Excel -- Worksheet Functions -- Count Cells

Free Excel Workbooks, Templates, Add-ins, Tutorials & More

Ron's Excel Page - Excel Add-ins
Business Functions is a free function library for Microsoft Excel designed to make business plans, budgets, structured financings and cashflows

GitHub - sweenig/ipfromdec Custom Excel Add-In to work with IP Addresses. Via Stuart's Semi-Professional Blog - Custom Formula: IPFromDEC (IP address from decimal)

Excel Password Remover 2008

Excel Startup Problems

Paste Options button does not appear when you paste between two instances of Excel
How to troubleshoot errors when you save Excel files

Bij het openen van een xls-bestand vanuit Excel wordt het bestand geopend, maar bij dubbelklik op een xls-bestand in Explorer opent Excel wel, maar het bestand niet.

1. Tools>Options>General en haal het vinkje weg bij Ignore Other Applications.
2. Sluit Excel vanuit Start>Run. Type in:

C:\Program Files\Microsoft Office\Office11\Excel.exe /unregserver

Voer vervolgens uit:

C:\Program Files\Microsoft Office\Office11\Excel.exe /regserver

Bron:Opening Excel Files From Windows Explorer

When trying to refresh a pivot table in an Excel sheet with data from a SQL Server Analysis Services cube the following error appears:

Workaround: either remove the Locale Identifier property from the connection string in the .odc file and re-add it to the Excel sheet or open the properties of the connection in the Excel sheet and place a checkmark in the box “Retrieve data and errors in the Office display language when available”.

Source:Microsoft Support - Error message when you update data in a PivotTable in Excel 2007: "Excel was unable to get necessary information about this cube" or "LocaleIdentifier property is not overwritable and cannot be assigned a new value"