Forum Discussion
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!
Sheet3 has gone, so the Excel is supposed to give its name to the new sheet that was created.
Excel should be more intelligent in this aspect!
Do you support this idea?
I prefer to create new workbook with only one sheet and if some sheet is deleted new added has new name, as it is now.
Otherwise it's bit hard to recognize what appears when. If having Sheet11 you again have Sheet2 and Sheet3 (adding new by drill-down or manually) some later it could take time to understand Sheet2 and Sheet3 are old ones I forgot to delete or new ones which I have to rename.
- You can post suggestions like this to excel.uservoice.com. And then invite all your friends to vote for it :-)
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.
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.
