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: RefTreeAnalyser
RefTreeAnalyser 2.0 has just been updated. You can now choose whether or not to display references in your formula more than once
Wed, 15 Jan 2020 09:20:00 GMT
Updated : Table Tools
I have updated the TableTools add-in, with a couple of bug fixes.
Mon, 13 Jan 2020 13:30: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)
International Keyboard Shortcut Day 2019
The first Wednesday of every November is International Keyboard Shortcut Day. This Wednesday, people from all over the world will become far less efficient for a short time in an effort to be far more efficient the rest of the year. “WASD V2 88-Key ISO Custom” by Bitboxer is licensed under CC BY-NC-SA 2.0 This […]
Mon, 04 Nov 2019 14:12:45 +0000

The Ken Puls Blog

By Ken Puls
Unfill in Power Query

Recently I received a question on how to Unfill in Power Query.  In other words, we want the opposite of the Fill feature, which fills data into blank cells (cells that contain a null value.)  If we see repeating values, … Continue reading

The post Unfill in Power Query appeared first on The Excelguru Blog.

Mon, 13 Jan 2020 20:22:35 +0000

PTS Blog

By Jon Peltier
Bar lengths on a chart, what do they even mean?

In this article I analyze unusual bar lengths in a newspaper chart, create a chart with appropriate bar lengths, then propose a few better alternatives.

The post Bar lengths on a chart, what do they even mean? appeared first on Peltier Tech Blog.

Thu, 09 Jan 2020 15:58:31 +0000

Contextures Blog

By Debrah Dalgleish
How to Refresh an Excel Pivot Table

Written by Debra Dalgleish from Contextures Blog

If you change any of the information in a pivot table's source data, the pivot table won't immediately show your latest changes. You have to refresh a pivot table, automatically or manually, to see the latest data. Manually Refresh a Pivot Table It's easy to update a pivot table manually: Right-click on the pivot table … Continue reading "How to Refresh an Excel Pivot Table"

How to Refresh an Excel Pivot Table is a post from Contextures Blog and is not allowed to be copied to other sites

Thu, 16 Jan 2020 05:02:00 +0000

Microsoft Excel blog on TechCommunity

By various Authors
Announcing Office Scripts (Preview)


Today we are announcing the availability of a public preview of Office Scripts in Excel on the web. Office Scripts is a feature that enables users with all levels of Excel experiencefrom beginner users to those with advanced coding expertiseto record scripts and automate their tasks. Over the coming weeks, this preview will be rolling out to organizations with Office 365. Get started by opting into the preview within the Microsoft 365 admin center, and create new automations using the script recorder and editor functionality. 


What is Office Scripts? 

With Office Scripts, you can automate tasks and workflows easily, and eliminate the need for repetitive steps as you create and manage workbooks. When the preview is enabled within your Office 365 environment, you can start creating Office Scripts by clicking the Record Actions button in the Automate tab, record the actions desired, stop the recorder, and then save the script.  Once a script is created you have the capability to run the script manually on Excel workbooks you have access to. Because the script is saved to OneDrive for Business, they can be easily reused across workbooks.  


Let’s see it in action:  



Users with all levels of programming experience can get started with script creation. It uses modern, developer-friendly technologies such as JavaScript so these scripts can be easily customized with existing - or new and growing – developer skills.  To edit your scripts, use a full TypeScript-based editor directly within Excel on the web to tailor the scripts you have recorded. Finally, administrators will be able to enforce governance policies around how Office scripts can run. 


Office Scripts will empower you to easily automate tasks and processes, allowing you to manage tasks efficiently anytime and anywhere, including within Excel on the web. Get started with the preview of Office Scripts for Excel on the web – we look forward to your feedback. 


Learn More 

You can learn more about Office Scripts from these resources: 

How do I get Office Scripts? 

Office Scripts will be rolling out over the next few weeks to Excel users who have Office 365 E3 and E5 licenses. Gradual roll outs allow us to gather feedback and ensure feature quality. During this initial preview, Office Scripts will only be available in Excel on the web, though we will look to bring Office Scripts to other Excel endpoints. Office Scripts will need to enabled through the admin center and will become visible in tenants as the feature rolls out. The feature can be enabled by following the steps below: 


  1. Go to admin center. 
  2. Select Settings > Settings and then choose Office Scripts from the list. 
  3. Check the “Let users automate their tasks in Office on the web” box in the Office Scripts panel and save changes. 

Note: Office Scripts is not currently available in Internet Explorer. 

To stay connected to Excel and its community, read the Excel blog posts and send us ideas and suggestions via UserVoice or post your questions about how to create a script via StackOverflow using the “office-scripts” tag. You can also follow Excel on Facebook and Twitter.  

Tue, Jan 07 2020 08:18:42 +0000