Thanks for subscribing Well send you future issues right away.

Office for Mere Mortals has been running for over 20 years, weve never, ever revealed or sold subscriber details.

Where Are Tabs In Excel Update As The

Now well take the next step and make an automatic list of worksheets that will update as the workbook changes.

Well break it down so you can understand how the whole thing comes together.

Its an old Excel function thats still necessary and available but not part of the current Excel function list.

You wont find it in the Formulas tab but it works fine with some conditions well mention in a moment.

Its widely quoted on the Internet having been tweaked and adapted over time by various Excel wizards.

Those mostly arise because the formula uses an obsolete function that Microsoft hasnt replaced in modern Excel releases.

Here, the array example has the Hide me away tab listed but its not on the tab list at the bottom of the worksheet.

At least theyre grouped together at the end of your tabs list.

Its only refreshed when Excel thinks its necessary, which isnt good enough in this case.

Changes to the tabs or names might not be quickly reflected in the array list.

A detailed and independent look at Windows 10, especially for Microsoft Office.

T() is a test for a text value with the useful property of returning an empty string ( ) if the function contents are NOT text.

NOW() always returns a datetime (obviously) so T(NOW()) will always add nothing to a string.

Because the name formula has the NOW() function, Excel will recalculate the entire name whenever a recalc occurs.

In Excel parlance NOW() is a volatile function which makes the whole name formula volatile.

If theres a chance that more worksheets will be added later, you might want to keep those error formulas in place.

Were just interested in links to each tabworksheet like this.

Office Watch has been running for over 20 years, weve never, ever revealed or sold subscriber details.

Invalid email address Weve been running secure and private newsletters for over 20 years.

Where Are Tabs In Excel For Mac