+ Reply to Thread
Results 1 to 6 of 6

Inserting New Spreadsheets

  1. #1
    Registered User
    Join Date
    09-30-2015
    Location
    Phoenix, Arizona
    MS-Off Ver
    2013
    Posts
    3

    Inserting New Spreadsheets

    Hi everyone. I am new to this forum and I'm hoping that you all will be able to help me. I have access to several PCs and a laptop and have 2013 on all of them. On a couple of the PCs when I open up a new blank Workbook, it opens with the one default worksheet. But when I insert a new Worksheet either from the Ribbon or by clicking on the plus sign next to Sheet1, it automatically inserts THREE new worksheets as Sheet1, Sheet2, Sheet3 and changes the original Worksheet to Sheet1(2)--as if a copy has been made of Sheet 1. The only thing I could think to check was File-Options and, yes, it is set to open a new workbook with just one default Worksheet. I am totally confused as to why three sheets are being inserted. I have Googled but not found any answers. Any assistance you could provide would be appreciated. Thanks so much.

  2. #2
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: Inserting New Spreadsheets

    Hi, welcome to the forum.

    The only thing I can think of is that a template with three sheets is being inserted, instead of the default worksheet.

    If I make a file with three blank sheets (Sheet1,Sheet2,Sheet3) and save it as a template (for example newsheet.xltx), then open a new file (with just Sheet1), then right-click Sheet1, select 'Insert' and select the template I just created (newsheet.xltx), then I get Sheet1 (2), Sheet2, Sheet3.
    If someone has saved a template called 'Sheet.xltx' in the 'XLSTART' folder, then this will over-ride the normal default worksheet template, so that's probably what has happened. The XLSTART folder is here: C:\Users\<yourusername>\AppData\Roaming\Microsoft\Excel\XLSTART. You may need to select 'view hidden folders' through folder options before you can find it.

    Hope that helps...and that it makes sense!
    Regards,
    Aardigspook

    I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

  3. #3
    Registered User
    Join Date
    09-30-2015
    Location
    Phoenix, Arizona
    MS-Off Ver
    2013
    Posts
    3

    Re: Inserting New Spreadsheets

    Thank you SO much! I will go check this out. We were having problems on some of the PCs with gridlines not showing, and IT was trying to give us A New Blank Workbook with "gridlines applied" (if that makes sense) so we could at least have something that "looked like" a real spreadsheet and I bet that is affecting what is now happening. I really do appreciate your input.

  4. #4
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: Inserting New Spreadsheets

    You're welcome and good luck.

  5. #5
    Registered User
    Join Date
    09-30-2015
    Location
    Phoenix, Arizona
    MS-Off Ver
    2013
    Posts
    3

    Re: Inserting New Spreadsheets

    Yes!! That was the issue. Thank you SO much!

  6. #6
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: Inserting New Spreadsheets

    Glad to have been of help.

    Now that the problem is fixed, please help keep the moderators happy by marking your thread as 'Solved', using the 'Thread Tools' at the top of your original post. Thanks.

+ 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. Inserting Excel Spreadsheets into MS-Word Documents
    By bruceisaacson in forum Excel General
    Replies: 2
    Last Post: 10-05-2014, 01:37 AM
  2. Inserting new column across multiple spreadsheets and filling them
    By rsmith10 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2014, 01:03 PM
  3. Replies: 0
    Last Post: 05-20-2014, 11:58 AM
  4. Inserting a row in multiple spreadsheets and copying contents
    By charlesk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-03-2013, 04:38 PM
  5. Replies: 6
    Last Post: 08-29-2010, 08:15 AM
  6. Import Data from multiple spreadsheets into seperate spreadsheets worksheet
    By cablecrt in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-17-2008, 08:01 AM
  7. [SOLVED] Can Excel Spreadsheets be saved as Microsoft Works spreadsheets?
    By EXCEL WORKS CONFUSED in forum Excel General
    Replies: 4
    Last Post: 08-18-2006, 06:25 PM

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