+ Reply to Thread
Results 1 to 5 of 5

Cannot insert new worksheets.....sounds simple???

  1. #1
    Registered User
    Join Date
    11-27-2013
    Location
    Lancashire
    MS-Off Ver
    Excel 2007
    Posts
    43

    Cannot insert new worksheets.....sounds simple???

    Hi folks, hope you're all well. I have a stupidly simple, yet frustrating, problem!

    Background - I use Windows 10 and have been quite content with Excel 2007. I've been saving files as Excel 97/2003 version. I have a number of spreadsheets that I use for my (very) small business. One of them is used to create invoices - these are saved and then converted to pdf for emailing my clients. Recently, sany saved sheets have been opened as "compatability mode" - I'm afraid I have no idea why that is the case! However, I have noticed that - sometimes, not every time! - if I try to open a sheet from my desktop, it opens it in Excel Professional Plus 2016 and tells me the copy is not activated. I have no idea how to proceed from there but suspect I can't do anything to activate as I do not have any original software (my laptop was bought as a reconditrioned item a few years ago and came with MS Office already loaded).

    Yesterday, I wanted to add an extra worksheet to my "invoice" workbook. But, I found that it was a) not possible to do this by right=clicking on another worksheet tab or b)by selecting "insert sheet" in the Home toolbar as it is greyed out. The "Review" toolbar shows that the neither the sheets or workbook are protected.

    If you have a few minutes, please feel free to look at the attached workbook. It is basically the same as the one I want to add a sheet to, but with all "confidential" data removed to protect the innocent!

    You'll see that some columns are hidden, and that some of the formulas use look-ups from a hidden sheet as well I'd quite like to "unhide" that sheet, but I can't seem to do that either!!

    Thanks in advance for any help you can give me. I really appreciate it.

    Mike
    Attached Files Attached Files

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Cannot insert new worksheets.....sounds simple???

    I found protection turned on for changes to the workbook structure. Turned off protection and could unhide your sheet.

  3. #3
    Registered User
    Join Date
    11-27-2013
    Location
    Lancashire
    MS-Off Ver
    Excel 2007
    Posts
    43

    Re: Cannot insert new worksheets.....sounds simple???

    Quote Originally Posted by kersplash View Post
    I found protection turned on for changes to the workbook structure. Turned off protection and could unhide your sheet.
    Ok thanks.....urm, how do I do what you suggest??

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,886

    Re: Cannot insert new worksheets.....sounds simple???

    Click the Protect Workbook button. (unlike the Worksheet one, the caption doesn't change to reflect the protection status.)
    Rory

  5. #5
    Registered User
    Join Date
    11-27-2013
    Location
    Lancashire
    MS-Off Ver
    Excel 2007
    Posts
    43

    Re: Cannot insert new worksheets.....sounds simple???

    Quote Originally Posted by rorya View Post
    Click the Protect Workbook button. (unlike the Worksheet one, the caption doesn't change to reflect the protection status.)
    Great, thanks for all your help. Problem now solved!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Need simple way to insert new row
    By SJMaye in forum Excel General
    Replies: 15
    Last Post: 12-01-2015, 03:53 PM
  2. Formula that shows value between multiple number range.
    By HarrBarr in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-22-2015, 04:29 AM
  3. Simple macro to conditionally insert a row?
    By Cam in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-13-2014, 03:47 PM
  4. [SOLVED] How to find two values in one column (sounds so simple..)
    By FlorisL in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-11-2014, 04:04 PM
  5. Replies: 1
    Last Post: 01-22-2012, 11:44 AM
  6. Simple insert value into cell
    By eonizuka in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-06-2009, 06:51 PM
  7. [SOLVED] Simple Question (insert new line)
    By Joe D in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-27-2005, 11:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1