Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


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

Posted on 2014-12-03
Medium Priority
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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 24

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?
Enroll in September's Course of the Month

This month’s featured course covers 16 hours of training in installation, management, and deployment of VMware vSphere virtualization environments. It's free for Premium Members, Team Accounts, and Qualified Experts!


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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Viewers will learn how to share Excel data with others from desktop Excel, as well as Excel Online via OneDrive, and embed an Excel file on a website.
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.

670 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