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
Newsletter Archive

File crashes Excel!!

Save my workbook!
The best tool for salvaging problematic workbooks.


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

Summer sale at
Yes we're having a summer sale at From July 1 to July 10 we offer a 25 % discount on both our products: RefTreeAnalyser and The Excel File Remediation Utility
Thu, 25 Jun 2015 06:15:00 GMT
New product: The Excel File Remediation Utility
I have launched a new product you can try and buy directly from my site: The Excel File Remediation Utility. This tool helps you to try and salvage Excel models with problematic content accumulated during a long editing history.
Thu, 25 Jun 2015 06:15:00 GMT

Excel Experts Nederland

Excel Expert Nederland Blog
The Amsterdam Excel Summit 2015
Hallo! Na het enorme succes van vorig jaar, hebben we besloten opnieuw dit unieke evenement te organiseren: The Amsterdam Excel Summit Excel Experts Van Wereldklasse Een absoluut unieke groep Excel MVP’s zal in april 2015 in Amsterdam zijn om hun geweldige Excel kennis met u te delen. Deze MVP’s zijn in Amsterdam voor een bijeenkomst en wij zijn erin geslaagd om deze mensen voor ons evenement te boeken! Hoor het direct van de makers van Excel Iemand van het BI team van Microsoft zal tijdens dit evenement presentaties verzorgen, dus als je wilt weten welke kant het op gaat bij Microsoft Excel, zorg dan dat je erbij bent! Programma We hebben … Continue reading
Mon, 26 Jan 2015 16:28:42 +0000

Daily Dose Of Excel

By Dick Kusleika (et al)

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

The Ken Puls Blog

By Ken Puls
MultipleUnclassified/Trusted error

If you’ve been using my fnGetParameter function to build dynamic content into your queries, you may have noticed that passing some variables recently started triggering an error message that reads as follows: We couldn’t refresh the connection ‘Power Query – … Continue reading

The post MultipleUnclassified/Trusted error appeared first on The Ken Puls (Excelguru) Blog.

Wed, 01 Jul 2015 17:31:59 +0000

.NET & Excel

By Dennis Wallentin

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

PTS Blog

By Jon Peltier
Reciprocal Chart Axis Scale

Many physical phenomena exhibit behavior that shows faster rates or greater solubilities at higher temperatures. An Arrhenius equation gives the following relationship between some measure of reaction rate or chemical solubility and temperature: K = A exp (-Q/RT) where K is the rate or solubility, A is a constant, Q is an activation energy, R […]

The post Reciprocal Chart Axis Scale appeared first on Peltier Tech Blog.

Thu, 02 Jul 2015 13:00:05 +0000

Contextures Blog

By Debrah Dalgleish
Excel Roundup 20150706

In this week's roundup, create bullet charts, export dashboards, use the Rank feature in pivot tables, and many other Excel tips

We're on our summer schedule now, so the next roundup will be published on Monday, July 20th.

1. Contextures Posts

In case you missed them, here are the articles that I posted recently:

Use the Rank calculation in an Excel pivot table, to make it easier to compare data For a humorous peek at what other people are saying about spreadsheets, read the latest collection of Excel tweets, on my Excel Theatre blog. 2. Bullet Charts


Continue reading Excel Roundup 20150706

Mon, 06 Jul 2015 04:02:00 +0000

Microsoft Excel on MSDN

By various Authors

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