Consulting

Results 1 to 2 of 2

Thread: Month report in excel doc

  1. #1
    VBAX Newbie pipercarney's Avatar
    Joined
    Jun 2018
    Location
    Montreal
    Posts
    1
    Location

    Month report in excel doc

    Pats, how to be? I have huge excel document with a lot of important information. It's my month report to my boss. Today I couldn't open it, next message popped up: "Excel found unreadable content in month_rep.xlsx". I used repair excel tool from Microsoft, it didn't find any problems. But I still haven't been able to access my data. Is there any way out?

  2. #2
    VBAX Newbie Mikvance's Avatar
    Joined
    Jun 2018
    Location
    UK, Glasgow
    Posts
    1
    Location
    Excel keeps a lot of 'extraneous' data in files and it grows over time. If possible try cutting and pasting into a fresh workbook and see if the problem goes away (the 'extra' data will stay with the sheets if you use 'move or copy' at a tab level). NB: this method works through the clipboard so you might find the data set is too large for a single iteration,

    Alternatively try 'Fail Save As and use one of the earlier formats such as 2003 .xls (if you get a warning that some formula won't work in earlier formats abort and try a different one, in theory the formulas WILL be saved under compatibility mode and recreated when you come back so if all else fails its worth a shot).

    The idea is that the Save As process drops all the 'extras' so once that's done you can go back to the 'normal' format. Depending on the integrity/criticality of the data you might want to do some regression to prove that the new file holds the same information as the old one - count of cells, column totals etc

    Another idea might be in using various solutions from Yahoo, Google, Bing and etc.
    https://www.techrepublic.com/blog/10...xcel-workbook/
    https://download.cnet.com/Recuva/300...-10753287.html
    https://excel.recoverytoolbox.com/repairexcel/

Posting Permissions

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