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
88 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
[X]
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
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
On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

 
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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.

734 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