Forum Discussion

Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Jan 14, 2018

The way the new sheets are named

Let's say that a user has a workbook with three sheets in it as follows: Sheet1 Sheet2 Sheet3   When he removes the Sheet3 and later decides to add it again, its name will be Sheet4! Sheet...
excel
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Jan 15, 2018

Jan,

 

I already posted this idea here in Excel User Voice, but I wanted to discuss the subject here and then give you the link of the idea.

 

Thank you.

Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Feb 23, 2018

Hey guys, any ideas about this!

 

There is someone who has replied to the idea on the UserVoice with a good point of view as below:

No. Think of the situation that your sheet2 uses something like INDIRECT("Sheet3!A" & row())
--------------------------------------------------------------------------------------------------

My reply to him:

Your point of view is respected!

But this situation is rare and not considered, so the user will be notified immediately after he deletes Sheet3 so that the formulas in Sheet2 will instantly return #REF! error and he will fix that as soon as possible before he thinks to add a new sheet!

 

On the other hand, please note that the same situation will happen when a user uses something like INDIRECT("Sheet3!A" & row()), then deletes Sheet3 and then renames another sheet with the same name as Sheet3!

 

Don't think that this idea can be dangerous, and may ruin some existing formulas, and make them deliver unexpected results!

 

I consider the user that use INDIRECT function is an intermediate or advanced user, so he is supposed to be smart enough and careful from situations like this.

Resources