+ Reply to Thread
Results 1 to 4 of 4

Data corrupted in multipage spreadsheet

  1. #1
    Registered User
    Join Date
    08-30-2007
    Posts
    5

    Data corrupted in multipage spreadsheet

    Hi,

    I have a spread sheet that I've been maintaining/updating since 2005. It has 60 pages of financial data. I had copies in other places but I recently moved the main one to an alternate location and ran my backup batch which must have copied all the bad spreadsheets to the backup!
    Now in all the sheets some of the financial data is there, but the number of shares columns all got filled with dates! I scoured all drives for other copies and did find a good one from July 2013 ouch! So I lost 6 months of data. I have Excel 2010 currently. I'm thinking possibly the file copy did it. But why mess up only certain columns?
    Has anyone seen something like this? Am I hitting the limit on number of pages that Excel can reliably hold?

    Thanks

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,684

    Re: Data corrupted in multipage spreadsheet

    What do you think whether it happens because of the Macro?


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Expert
    Join Date
    11-26-2013
    Location
    Colac, Victoria, Australia
    MS-Off Ver
    Excel 2016
    Posts
    1,309

    Re: Data corrupted in multipage spreadsheet

    Hi Coolecho,

    Is it possible that you have a cell formatting issue?

    It may look like you have dates, but if you highlight the column and format it as number (or general), you might get your data back.

    Regards,

    David


    When you reply please make it clear WHO you are responding to by mentioning their name.
    If this has been of assistance, please advise. A little thanks goes a long way.
    - Please click on the *Add Reputation button at the bottom of helpful responses.
    Please mark your thread as SOLVED:
    - Click Thread Tools above your first post, select "Mark your thread as Solved".

  4. #4
    Registered User
    Join Date
    08-30-2007
    Posts
    5

    Re: Data corrupted in multipage spreadsheet

    David,
    Wow that is exactly what happened! Amazing I never would have imagined. This saved me a ton of work! I'll just have to go thru and format paint back the correct formats.

    Thank You so much!

+ 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. Data corrupted during pasting
    By PhilippeR in forum Excel General
    Replies: 1
    Last Post: 01-05-2011, 12:38 PM
  2. Corrupted Spreadsheet
    By Declan93 in forum Excel General
    Replies: 2
    Last Post: 11-04-2007, 05:06 PM
  3. CORRUPTED spreadsheet
    By Bogdan in forum Excel General
    Replies: 3
    Last Post: 04-25-2005, 02:06 AM
  4. Embedded Excel Spreadsheet in MS Word Corrupted
    By Mary in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-24-2005, 02:06 PM
  5. [SOLVED] excel 2000 - corrupted data
    By john pilcher in forum Excel General
    Replies: 1
    Last Post: 03-14-2005, 02:53 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