Most Valuable Professional

View Jan Karel Pieterse's profile on LinkedIn subscribe to rss feed
Subscribe in a reader

Subscribe to our mailing list

* indicates required

Audit !!!

Check out our RefTreeAnalyser
the ultimate Excel formula auditing tool.


Excel VBA Masterclass (English)
Excel VBA for Financials (Dutch)

Third party tools

Speed up your file

The best tool to optimise your Excel model!

Repair your file

Stellar Phoenix Excel Repair
Best tool to repair corrupt Excel sheets and objects
Home > English site > Headlines

Excel Headlines

My very own list of news on Excel, gathered from various sources!

This site

Update: Name Manager
Name Manager has just been updated to build 666. Name Manager will now recognize names starting with _xlfn as Excel system names.
Tue, 22 Jan 2019 13:50:00 GMT
Updated : Flexfind
Flexfind has been updated with a small number of improvements: better search in chart items and better grouping of cells with identical formulas.
Wed, 16 Jan 2019 07:50:00 GMT

Excel Experts Nederland

Excel Expert Nederland Blog
Nieuw: ons Excel Forum
Wij kregen tamelijk veel Excel gerelateerde vragen in onze commentaren. Om deze vragen beter te kunnen kanaliseren zijn we daarom een Excel forum gestart. Heb je een vraag? Word lid van ons forum en stel hem hier: Excel Experts Nederland Forum
Mon, 30 Jan 2017 16:38:13 +0000

Daily Dose Of Excel

By Dick Kusleika (et al)
Keyboard Metrics III
In the grand tradition of Keyboard Shortcut Metrics and More Keyboard Metrics, here’s this: Procedure 2016 2017 2018 Grand Total MakeComma 20.54% 18.67% 19.01% 19.19% WrapSheetsDown 13.80% 17.15% 9.93% 14.93% WrapSheetsUp 8.60% 15.36% 7.33% 12.16% FillVirtualScreen 10.50% 11.04% 8.42% 10.40% CopyPasteValues 14.00% 4.84% 2.20% 6.54% ShowFormatting 5.85% 5.13% 7.04% 5.68% IncrementDate 4.25% 4.08% 9.77% 5.23% […]
Mon, 12 Nov 2018 13:00:34 +0000

The Ken Puls Blog

By Ken Puls
Check the application version in Modern Office

In the good old days, it was easy to check the application version in Office with VBA.  You just used a little test of Val(Application.Version) to return the number.  12 was Office 2007, 14 was Office 2010, 15 was Office … Continue reading

The post Check the application version in Modern Office appeared first on The Excelguru Blog.

Mon, 11 Feb 2019 17:00:51 +0000

PTS Blog

By Jon Peltier
Reference SeriesCollection Item by Name or Index

SeriesCollection(Item) Working on a project last week, I encountered a somewhat amusing source of potential confusion. In VBA, you can reference a SeriesCollection item by name or by index. In the screenshot above, I can reference the first series in the chart using or using Series 1 is Series “alpha”, pretty clear cut. Well, in […]

The post Reference SeriesCollection Item by Name or Index appeared first on Peltier Tech Blog.

Mon, 18 Feb 2019 15:00:13 +0000

Contextures Blog

By Debrah Dalgleish
Excel Pivot Table Troubleshooting
If you have a big Excel file, with lots of pivot tables and their source data, I've written a macro that might help you. The macros creates a detailed list of all the pivot tables in the workbook, so it's useful for documentation, and some types of troubleshooting. Macro Lists Pivot Table Details Here's a … Continue reading "Excel Pivot Table Troubleshooting"
Thu, 21 Feb 2019 05:01:00 +0000

Microsoft Excel on MSDN

By various Authors

An error has occured while trying to process
Please contact web-master.