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

File crashes Excel!!

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

Events


Excel VBA for Financials (Dutch)

Third party tools

Speed up your file

FastExcel
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: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. I have added an option to display your formula as a mathematical equation.
Tue, 21 Jun 2016 14:55:00 GMT
Updated: An MSForms (all VBA) treeview.
Our All VBA treeview control now has a professional version which is ready for beta testing.
Thu, 16 Jun 2016 15:50:00 GMT

Excel Experts Nederland

Excel Expert Nederland Blog
Tref ons op de 10e Excel Experience Day!
Vrijwel al onze Excel Experts zullen op de 10e Excel Experience Day als spreker fungeren. Dus als u ons wilt ontmoeten (en -wellicht- spreken over toekomstige projecten), dan is dat een uitgelezen gelegenheid! Dus schrijf u nu in en tref ons 10 december in Burgers Zoo! Jan Karel Pieterse
Wed, 04 Nov 2015 16:47:27 +0000

Daily Dose Of Excel

By Dick Kusleika (et al)

An error has occured while trying to process http://www.dailydoseofexcel.com/feed/
Please contact web-master.


The Ken Puls Blog

By Ken Puls
June 2016 Power Query Update

Yesterday, Microsoft released the June 2016 Power Query update.  Even though there are only four items on the list of new features, some of them are quite impactful. What’s new in the June 2016 Power Query Update The four new … Continue reading

The post June 2016 Power Query Update appeared first on The Ken Puls (Excelguru) Blog.


Wed, 22 Jun 2016 16:57:47 +0000

.NET & Excel

By Dennis Wallentin

An error has occured while trying to process http://xldennis.wordpress.com/feed
Please contact web-master.


PTS Blog

By Jon Peltier
Copy Chart to New Sheet and Link to Data on New Sheet

This is a quick post to answer this rather common question from the forums: I have a worksheet that has data in a particular arrangement and a chart that plots this data. I have another worksheet with the identical data arrangement. How can I copy the chart to the new worksheet and have the chart link […]

The post Copy Chart to New Sheet and Link to Data on New Sheet appeared first on Peltier Tech Blog.


Wed, 06 Jul 2016 13:00:28 +0000

Contextures Blog

By Debrah Dalgleish
How to Show Excel Table Name on the Sheet

If you have an Excel workbook with lots of tables and pivot tables, it can be hard to remember what they’re named, or what source data they're using. To help you keep track of them, AlexJ is sharing the User Defined Function (UDF) that he uses to help manage his files. With AlexJ's code in your file, just add a formula, click on a cell, and show Excel table name, or pivot table name, on the sheet.

The code is shown below, and there is also a link for downloading a sample file with the code installed in it. You

Continue reading How to Show Excel Table Name on the Sheet

The post How to Show Excel Table Name on the Sheet appeared first on Contextures Blog.


Thu, 21 Jul 2016 04:01:00 +0000

Microsoft Excel on MSDN

By various Authors
Office 365 news roundup

Find out how you can learn more about Office 365, share best practices with others and keep up-to-date on everything you need to know about the service. We also catch you up on the recent news about Office 365.

The post Office 365 news roundup appeared first on Office Blogs.


Fri, 22 Jul 2016 20:25:42 +0000