+ Reply to Thread
Results 1 to 10 of 10

Excel Inserting Empty Row on every Save

  1. #1
    Registered User
    Join Date
    05-15-2017
    Location
    Alabama
    MS-Off Ver
    2010
    Posts
    6

    Excel Inserting Empty Row on every Save

    Every time I click Save I am getting an Empty Row at the top.

    How do I disable this?

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: Excel Inserting Empty Row on every Save

    Is your workbook saved as a Macro-Enabled workbook?
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

  3. #3
    Registered User
    Join Date
    05-15-2017
    Location
    Alabama
    MS-Off Ver
    2010
    Posts
    6

    Re: Excel Inserting Empty Row on every Save

    I have no idea.
    It happens with any excel file.
    Last edited by mojoala; 05-15-2017 at 02:54 PM.

  4. #4
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: Excel Inserting Empty Row on every Save

    Can you attach an example file?

  5. #5
    Registered User
    Join Date
    05-15-2017
    Location
    Alabama
    MS-Off Ver
    2010
    Posts
    6

    Re: Excel Inserting Empty Row on every Save

    attachment feature here is not working.
    Not user friendly to say the least.
    Get nice dialog box for image but not for attachments.
    Getting off work in a few mins. will check back in the morning.
    Last edited by mojoala; 05-15-2017 at 04:10 PM.

  6. #6
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,223

    Re: Excel Inserting Empty Row on every Save

    Without attachment difficult.
    For attach file process
    >Click "Go Advanced"
    >Click Manage Attachment
    >Brows file from respective folder
    >Click on upload
    >After complete uploading file click on closed this windows.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  7. #7
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,887

    Re: Excel Inserting Empty Row on every Save

    It it happens with every file... likely culprit is Personal.XLSB

    Try going to "C:\Users\XXX\AppData\Roaming\Microsoft\Excel\XLSTART" and set folder option to show hidden files and delete the Personal.XLSB file.
    Where "XXX" is your username on the computer.

    If it isn't there, try repair of Office installation.

  8. #8
    Registered User
    Join Date
    05-15-2017
    Location
    Alabama
    MS-Off Ver
    2010
    Posts
    6

    Re: Excel Inserting Empty Row on every Save

    attachment....

    no Personal.XLSB file.

    Did repair of Office Installation. Still the same.

    Sent same file to coworker....no problems. Going to uninstall Excel and then Reinstall.

    No change in behavior there. Complete uninstall and reinstall of Microsoft Office will involve IT Dept getting involved....
    Attached Files Attached Files
    Last edited by mojoala; 05-16-2017 at 09:20 AM.

  9. #9
    Registered User
    Join Date
    05-15-2017
    Location
    Alabama
    MS-Off Ver
    2010
    Posts
    6

    Re: Excel Inserting Empty Row on every Save

    Well, I found the problem. There was an add-in that was suspect. Looked at coworkers add-ins and I had on extra one. Deleted it. And Bam, problem gone.

  10. #10
    Registered User
    Join Date
    05-15-2017
    Location
    Alabama
    MS-Off Ver
    2010
    Posts
    6

    Re: Excel Inserting Empty Row on every Save

    Thanks for everyone's suggestions.

+ 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 empty rows
    By karenff in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 12-26-2016, 03:57 PM
  2. Finding page breaks in excel sheets & inserting empty row
    By Ouka in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-09-2015, 09:54 PM
  3. Inserting Formula Based On Another Cell Empty Or Not
    By StormStrikes in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-01-2015, 03:55 PM
  4. [SOLVED] Need help in code to add save data from userform to next empty line in excel
    By MedSter2015 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-23-2014, 01:51 AM
  5. Inserting an empty row above every highlighted row of data
    By terryhenderson in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-12-2014, 02:41 AM
  6. [SOLVED] Save file from excel-vba without excel automatically inserting quotes
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-06-2013, 09:22 AM
  7. Inserting a empty Row if the value change
    By kaffal in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-29-2009, 01:36 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