Tuesday, August 21, 2007

Microsoft Excel : CUBE Functions 3: Formula AutoComplete revisited

 

Formula Auto-Complete for CUBE function arguments
Formula AutoComplete for CUBE function arguments has some special behaviours relative to the other functions in Excel.   As a brief refresher, Formula AutoComplete is a feature that provides a list of values from which to choose as you write formulas … here is a blog post that describes this in detail.  In most Formula AutoComplete scenarios, Excel knows the list of values (formulas, named ranges, table names) that it should display because those values are part of the Excel application.  For example, when you start typing a function name, Excel can give you a list of all the other functions that start with the same character(s), as is shown in this screenshot.

Microsoft Excel : CUBE Functions 3: Formula AutoComplete revisited

2 comments:

Alex said...

Once I added a new table in my excel file on job and all my info were damaged.In this situation familiar recommended to use-excel 2007 recovery.Tool is free as he told.It helped me,and program as well supports almost all existing versions of XLS and XLSX formats: Microsoft Excel 97, 2000, XP, 2002, 2003 and 2007 (xlsx repair).

Alexis said...

Once I converted from xls to xlsx and something happened and data were lost.But I solved this issue-check xls repair.This tool did it very quickly.Moreover tool is free and can too helps to prevent a broad range of issues that lead to the corruption of Microsoft Excel worksheets.