Excel 2010 Adds three worksheets when I click the 'add new' tab. I want only one worksheet added

Posted on 2014-12-03
Last Modified: 2014-12-14
Excel 2010 Adds three worksheets when I click the 'add new' tab. I want only one worksheet added

I do not mean when a new Excel workbook opens, i mean when I am in an existing workbook and want to add a single new worksheet.

I consider it the height of unprofessinal laziness to distribute workbooks with empty meaningless worksheets - and this function of adding three empty worksheets is reprehensible

please help - otherwise this OCD condition of mine may completely overcome me
Question by:Flying_High_71
  • 3
  • 2

Expert Comment

by:Network Zero
ID: 40480042

Try this.. Go to control panel then go to programs and features then go to Microsoft office 2010 and right click go to change or click repair. make sure its closed and try that.

IF that does not work. Reboot your computer. open excel and the make sure you don't have any recovered old sheets there and just make a sheet and save it with any name and just close it, now open it excel again and try it.

good luck :)
LVL 23

Expert Comment

ID: 40480427
The procedures outlined in this article cover the repair mentioned above

I also mentions the removal add-ons, and some registry repairs.tweaks
and there is a link to Microsoft's Fixit utility.

Author Comment

ID: 40486180
Unfortunately this is a computer on a Corporate Domain and access to things such as Control Panel to change a program require a higher level of elevation than I have been afforded.  

At any rate the suggestions above are hinting at a corrupted version of Excel - however I am wondering whether corporate settings are at play.

I have noticed that even if I select:

"File > Options > When creating new Workbooks - Include this many sheets"

and change the number to 1 or any other number, it makes no difference to the actual number of sheets that are opened in a newly created workbook.  Much less being able to change how many sheets are added when clicking  the add new sheet.

I guess what I really want to know is, where is the function that controls how many worksheets are opened when I click the "Insert Worksheets tab (Shift F11)"  

The above function in the settings ""File > Options > When creating new Workbooks - Include this many sheets"  has always referred only to the number of worksheets opened by default in a new workbook.  It has never before been used to control the number of worksheets opened when using the "Insert Worksheet" function in an already open workbook

Is it the consensus of the experts that this version of Excel is corrupted or is there a new function I need to know about?
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.


Expert Comment

by:Network Zero
ID: 40486186
This does not sound like a regular issue in excel, when these types of issues come up its best to try and repair excel first.

In order for this to be some sort of corporate policy  - it would have to be some sort of GPO and it would most likely be targeting a group of people, if such thing is being applied at a custom level to one user would be an extreme waste of time and it would have to be created since I've never heard of a template for such thing.

It could be possible... have your IT department check but it would doubt it might waste more time then anything I would try and repair excel first then anything.

depending on the files opened excel could be trying to open up tabs that either don't exist or maybe you have lost access to like a file on a server that is no longer present or has changed.

try saving a new file with 1 tab or no tabs and close everything and open it again

Accepted Solution

Flying_High_71 earned 0 total points
ID: 40490462

It was not a corrupt file or corurupt version of Excel.  Tech support have put it down the standard excel templates used here. They changed my template and presto none of the above behaviour is exhibited and all is working normally.

Author Closing Comment

ID: 40498680
This was the only solution that worked

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Moving applications to the cloud or switching services to cloud-based ones, is a stressful job.  Here's how you can make it easier.
We have come a long way with backup and data protection — from backing up to floppies, external drives, CDs, Blu-ray, flash drives, SSD drives, and now to the cloud.
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
Video by: Zack
Viewers will learn about various customizable options in Excel 2013.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now