Solved

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

Posted on 2014-12-03
6
81 Views
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
0
Comment
Question by:Flying_High_71
  • 3
  • 2
6 Comments
 
LVL 7

Expert Comment

by:Network Zero
ID: 40480042
Hey,

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 :)
0
 
LVL 23

Expert Comment

by:Eirman
ID: 40480427
The procedures outlined in this article cover the repair mentioned above
https://social.technet.microsoft.com/Forums/office/en-US/85970700-c17b-46dc-97fc-db6ec3b6d394/reset-excel-2010-to-installation-defaults

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

Author Comment

by:Flying_High_71
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?
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 7

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
0
 

Accepted Solution

by:
Flying_High_71 earned 0 total points
ID: 40490462
Hi EE

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.
0
 

Author Closing Comment

by:Flying_High_71
ID: 40498680
This was the only solution that worked
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micr…
Viewers will learn the basics of printing in Excel 2013 and how to adjust some common settings.
Video by: Zack
Viewers will learn the basics of using Excel Tables, the benefits found with them, and some pitfalls.

863 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

26 Experts available now in Live!

Get 1:1 Help Now