+ Reply to Thread
Results 1 to 4 of 4

data in excel file changed, all rows changed to data in first row..pls help

  1. #1
    Registered User
    Join Date
    11-08-2014
    Location
    saudi arabia
    MS-Off Ver
    2007
    Posts
    2

    data in excel file changed, all rows changed to data in first row..pls help

    Recently, i had closed an excel file...and when i opened it all data had got changed, the data in all rows have got replaced with data in first row.....kindly help

  2. #2
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: data in excel file changed, all rows changed to data in first row..pls help

    Hi, Welcome to the forum, all the cell's refer any formula ? , or accidently you selected shift down arrow and pressed ctrl+d ?
    Click just below left if it helps, Boo?ath?

  3. #3
    Registered User
    Join Date
    11-08-2014
    Location
    saudi arabia
    MS-Off Ver
    2007
    Posts
    2

    Re: data in excel file changed, all rows changed to data in first row..pls help

    no, i am trying to help someone who is affected by this. Is there anyway to recover the old version of the file??

    I checked previous versions, but nothing available in it. Pls help

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: data in excel file changed, all rows changed to data in first row..pls help

    If you are on a network, you may be able to recover a backup there. If this is a stand-alone, and the file was saved that way (without a backup), I dont think there is a way to recover what you had
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Replies: 0
    Last Post: 06-30-2014, 10:19 AM
  2. Protecting cells/data so they can't be changed after saving the file
    By thanhie in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-18-2014, 11:41 PM
  3. [SOLVED] Excel 2010 Identifying data changed in cells and Identifying the changed rows
    By SandyLake in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-13-2013, 01:12 AM
  4. [SOLVED] Hide All Rows with 0 Each time a Data Validation is Changed
    By Sky188 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-28-2013, 03:33 PM
  5. [SOLVED] Import External Data Source File Location Changed
    By Louise in forum Excel General
    Replies: 3
    Last Post: 01-04-2006, 10:50 AM

Tags for this Thread

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