Blog Post

Excel Blog
4 MIN READ

Preview of Stocks and Geography, New Data Types in Excel

John Campbell's avatar
John Campbell
Icon for Microsoft rankMicrosoft
Mar 29, 2018
Hundreds of millions of customers have created truly amazing solutions in Excel – and they’ve done all this while working with cells that most often contain (or evaluate to) just text and numbers. Wh...
Updated Apr 03, 2018
Version 10.0
excel
PRAY00's avatar
PRAY00
Copper Contributor
Feb 04, 2019

Hi,

This new functionality seems to have changed the way the dot operator (".") works in Excel.  Prior to this change, entering =A1.B10 would resolve to =A1:B10 and select the range.  I am working with some older code (that I unfortunately cannot edit), and it has several ranges selected using this shorthand.  Since the change, these ranges now throw a #FIELD! error.

 

Could the dot operator be changed to allow cellname.cellname to be interpreted as a range like it was in the past?  Or is there a way to disable this functionality and restore the previous behavior without rolling back Excel?  This is causing compatibility issues for our clients with the newest versions of Excel.  

 

There's an example of this functionality in the post here: https://techcommunity.microsoft.com/t5/Excel/Cell-Range-Delimiter/m-p/302359

 

 

Thank you!